Dataguard 10g switchover question
- From: "Newman, Christopher" <cjnewman@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 2 Nov 2009 20:36:59 -0600
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:
1) On Primary: Shutdown immediate, startup, switch log, ALTER DATABASE COMMIT
TO SWITCHOVER TO PHYSICAL STANDBY WITH SESSION SHUTDOWN;
2) 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
