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:

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
--
http://www.freelists.org/webpage/oracle-l


Other related posts: