| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> FW: Advanced Replication Question for Advanced DBAs
Dennis,
At our site, we use Replication (not for the entire DB, but only for important tables). But from the User group meetings, I get a feeling that Standby is the way to go and Oracle is trying hard to improve it in 9i....
Does that mean, Oracle prefers us to go Standby route in the long run? Can some experts share their wisdom on this?
Rama
-----Original Message-----
From: dmeng_at_focal.com [mailto:dmeng_at_focal.com]
Sent: Tuesday, January 02, 2001 7:45 AM
To: oracledba_at_quickdoc.co.uk
Subject: Advanced Replication Question for Advanced DBAs
Greetings,
I am evaluating different High Availability options for our shop and I am
kind of undecided between Hot Standby and Advanced Replication(AR) :
It seems to me that Multi-master replication is a much better choice for
us -- all we need is to set up two master sites
with one of them read-only. Also it seems to be fairly easy to set up using
Replication Manager ( it is up and running in my test instances after only
one day's work including reading the docs). This will prevent conflicts and
give us the extra benefit of a reporting instance. Hot Standby, on the
other hand, might take longer to set up and does not provide
read capability ( yes, I know in 8i you can open for read, but it does not
apply the logs when it is in readable mode, right? ).
So what caveats are associated with AR that drive people to use Standby at
all? I know there might be problems with AR if the transaction volume is
high. The databases here typically generates less than 100M of redo
everyday.
TIA
Dennis Meng
Database Administrator
Focal Communications
847-954-8328
 |
 |