Re: Dataguard 10g switchover question

Joe
Sent from the crackberry, so please excuse the typos and terseness.

• Original Message ----- From: "Newman, Christopher" [cjnewman_at_uillinois.edu] Sent: 11/02/2009 08:36 PM CST 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:

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

--

http://www.freelists.org/webpage/oracle-l Received on Tue Nov 03 2009 - 05:50:35 CST