DB mirroring

From: Morten <lists_at_kikobu.com>
Date: Tue, 13 Jul 2004 16:40:44 +0200 (CEST)
Message-ID: <Pine.LNX.4.44.0407131629240.31174-100000@hulk.itu.dk>

Hi.

I have two servers A and B. They are physically separated, and are only allowed to communicate over LAN (ie. no shared storage).

If one server dies, clients should access the other, so they need to be in sync. So far I've found the following options for making a fail-over system for Oracle (9i2 BTW):

RAC - this requires shared storage as far as I can tell from the whitepaper.
Oracle Data Guard w. primary/secondary servers. Requires operator intervention upon failure at the primary host. If this is acceptable, it's still not an optimal solution as we can expect lots of structural changes to the DB (new tables, altered tables, new/dropped indexes etc).

What other options are there? Is there a "mirror all ddl+dml operations on this DB to that DB" option?

Any tips greatly appreciated,

Morten

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

Received on Tue Jul 13 2004 - 09:37:57 CDT