RE: Dataguard switchover
- From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- To: <howard.latham@xxxxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 2 Apr 2009 09:06:23 -0400
Howard,
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
Other related posts:
