RE: Dataguard 10g switchover question
Date: Tue, 3 Nov 2009 07:33:41 -0500
A graceful switch over, without the shutdown of the primary in the first place, will be just fine. Part of the switchover from primary to standby process is to ensure that the last log data is sent to all of the existing standby's. Also, I don't recommend using arch since log stream feeds only happen at log switches, when arch becomes active. Instead I recommend LGWR with standby redo logs. That way instead of network bursts when you switch archive logs, you get this steady stream of data as LGWR becomes active whenever a commit is issued or the log buffer fills up. It's a pretty constant stream, but takes up almost no bandwidth.
Senior Oracle DBA/NA Team Lead
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Newman, Christopher Sent: Monday, November 02, 2009 9:37 PM
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.
http://www.freelists.org/webpage/oracle-l Received on Tue Nov 03 2009 - 06:33:41 CST