Dear gurus !
A customer wants to have a backup database on a remote "in case of disaster"
site.
That database needs to be as much in sync with the primary DB as possible,
and a sort of failover must be implemented ,
i.e. if the primary site fails , the users will be AUTOMATICALLY routed to
the secondary one .
I thought of 2 possible approaches :
multimaster asynchronous replication and a standby database.
The problem is that AFAIK , there is no automatic failover in case of
standby DB , i.e.. U need to issue "ALTER DATABASE ACTIVATE STANDBY
DATABASE; " or something like that on a backup site.
>From the other hand multimaster replication sounds like a big headache .
So , gurus , what would U suggest ?
How do U implement HA on your sites ?
Thanks a lot in advance for your time.
Andrey.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
