RE: Dataguard 10g switchover question
Date: Tue, 3 Nov 2009 07:52:44 +0100
Message-ID: <4814386347E41145AAE79139EAA398980D33FD8065_at_ws03-exch07.iconos.be>
Chris,
With a switchover, the other standby databases (often called the bystander databases) will stop processing the redo stream and you should thus restart the managed recovery again. Unless you specified the clause "through all switchover" when you originally started the recovery, but then you you should stop the recovery manually on the standby database that will become primary.
When you do a failover, then the actions depend on whether or not the bystander databases are ahead of the new primary.
Checkout the following MAA document : http://www.oracle.com/technology/deploy/availability/pdf/maa10gr2multiplestandbybp.pdf
regards,
Freek D'Hooge
Uptime
Oracle Database Administrator
e-mail: freek.dhooge_at_uptime.be
tel. +32 (0)3 451 23 82
http://www.uptime.be
disclaimer
From: oracle-l-bounce_at_freelists.org [oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher [cjnewman_at_uillinois.edu] Sent: 03 November 2009 03:36
To: oracle-l_at_freelists.org
Subject: Dataguard 10g switchover question
Sanity Check: We're have a primary and 3 physical standby's in ARCH mode. We're going to activate one of the standby's as primary, ditch the original primary and have the other 2 standby's feeding off the new primary.
So here's a rough plan, let me know if you see anything horribly wrong:
- On Primary: Shutdown immediate, startup, switch log, ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
- On the standby we'll be turning on as the primary: Verify last log applied then ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; ALTER DATABASE OPEN; Point OID to the new primary, enable the other standby locations on the new primary, verify logs are being shipped and applied and backup the new primary.
My main concern is making sure that the other two standby's are still usable.
I believe if I use the 'activate standby' it will make the other standby's unusable, but a graceful switchover should be OK.
Thanks- Chris
-- http://www.freelists.org/webpage/oracle-l-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 03 2009 - 00:52:44 CST