| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: A high-availability question (standby , replication or ....)
Rachel is 100% right (do we ever expect differently ??)
We currently use standby databases that have their logs updated every 15 minutes. If the Prod goes down it does take some manual intervention on our part ... chaning DNS and brining the Standby up in real mode. But our down time is less than an hour. That is acceptable in our work. It was also the simplest to create and maintain.
As for replication, at my old job we replicated DB2 data down to Oracle every 5 minutes. There were times when communications lagged and the replications broke. This caused a lot of problems because we ended up having to rebuild the table way too many times. The setup was also complex. It took us to maintain it and it was a 24x7 job. This one had the added complexity of not having structure changes automatically roll between databases. Whenever we changed something on the master side we had to physically go and make the changes on the secondary side.
We also setup oracle to oracle replication. That was another nightmare. We had to make sure structres were maintained between these as well. High Maintenance, High setup.
Now .... for Failover. We were in the process of getting ready to setup
HACMP rollovers between two servers. WOW ... now THAT was complicated AND
EXPENSIVE.
-----Original Message-----
Sent: Thursday, August 16, 2001 12:06 PM
To: Multiple recipients of list ORACLE-L
....)
Standby... even if I have to be paged in the middle of the night to bring it
up and live.
replication is a nightmare to implement unless you plan for it. Standby is a
breeze to implement and maintain.
>From: Andrey Bronfin <andreyb_at_elrontelesoft.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: A high-availability question (standby , replication or ....)
>Date: Thu, 16 Aug 2001 08:11:09 -0800
>
>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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: kgel_at_ppoone.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 - 11:56:58 CDT
 |
 |