RE: Dataguard switchover
Date: Thu, 2 Apr 2009 09:06:23 -0400
Start with the primary database.
Connect using sql*plus / as sysdba issue "alter database commit to switchover to standby with session disconnect;"
When that completes: alter database recover managed standby database disconnect;
Now on the standby server:
Connect as sys again.
"alter database recover managed standby database cancel;"
"alter database commit to switchover to primary with session
Now this does make the assumption that someone properly configured these two databases properly in the first place. If not then your in more trouble when it comes time to switch back.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham Sent: Thursday, April 02, 2009 7:33 AM
Subject: Dataguard switchover
Has anyone written a guide for a non dba to do a manual dataguard switchover on Linux Oracle 11g?
-- Howard A. Latham -- http://www.freelists.org/webpage/oracle-lReceived on Thu Apr 02 2009 - 08:06:23 CDT