Re: Dataguard 10g switchover question
Date: Tue, 3 Nov 2009 11:29:23 -0600
What you've outlined below should work just fine -- we recently did a switchover with one physical standby and 2 logical standbys in place. No issues observed with a graceful switchover. The redo stream should catch up from the last log for the additional standbys not involved in the switchover (you can also manually register the logs and apply later). You might want to defer the additional standbys; perform the switchover and then add the destinations back and recover for the other physical standbys. This is what we did for our logical standbys.
On Mon, Nov 2, 2009 at 8:36 PM, Newman, Christopher <cjnewman_at_uillinois.edu>wrote:
> 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
> My main concern is making sure that the other two standby's are still
> 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