RE: Dataguard switchover

    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
disconnect";

"shutdown immediate;"
"startup;"
 

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.    

Dick Goulet  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Howard Latham Sent: Thursday, April 02, 2009 7:33 AM
To: ORACLE-L
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-l