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 <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>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: [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).
_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
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).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Kevin Lange
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).
