RE: Data Guard question
Date: Tue, 28 Jul 2009 19:15:52 -0400
Message-ID: <56211FD5795F8346A0719FEBC0DB067504A7BA6E_at_mds3aex08.USIEXCHANGE.COM>
Agreed- I have done this a few times with 3 node Dataguard configuration. One thing to note is that your applications need to have a correctly configured tnsnames.ora (or jdbc connect string) if you want them to connect to the current primary node. If one node is down, then data will stack up on the primary until that node is brought back up. It should catch up as long as disk for archive logs is not exhausted (or other speed limits are hit).
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Niall Litchfield
Sent: Tuesday, July 28, 2009 4:30 PM
To: bill_at_intactus.com
Cc: ORACLE-L
Subject: Re: Data Guard question
if correctly configured and the switchover is done correctly then yes, for many practical purposes no.
you'll need to let us know at least
the LOG_ARCHIVE_x values,
the net8 config
any dg broker config
and your switchover process.
On Tue, Jul 28, 2009 at 7:56 PM, Bill Zakrzewski <bill_at_intactus.com> wrote:
Environment:
Oracle 10.2.0.4.0
3 - HP Servers running RH Linux
Primary Database - DB-A
Physical Standby - DB-B
Logical Standby - DB-C
So I have the primary database of DB-A and it replicates to both DB-B and DB-C. The Logical standby DB-C has a couple of reporting schemas in addition to the primary DB schemas. My question is.....if I perform a switchover from the primary DB-A to the physical standby DB-B, will DB-B also replicate to DB-C after the switchover since it will become the primary database? It probably doesn't matter, but each database is on its own server.
Thanks in advance,
Bill
--
http://www.freelists.org/webpage/oracle-l
--
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 28 2009 - 18:15:52 CDT