Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> A high-availability question (standby , replication or ....)
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: andreyb_at_elrontelesoft.com 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: ListGuru_at_fatcity.com (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).Received on Thu Aug 16 2001 - 10:18:36 CDT
![]() |
![]() |