Home » Server Options » Data Guard » Switchover status (Oracle
Switchover status [message #288745] Tue, 18 December 2007 09:17 Go to next message
Messages: 7
Registered: October 2007
Location: Bangalore
Junior Member

I have configured Data Guard setup on same machine just for testing purpose, when I queried for SWITCHOVER_STATUS it is showing SESSION ACTIVE for both Primary and Standby DB, but I am still able to switchover from Primary to Standby.
Can anyone tell me the reason for the same? Confused
Re: Switchover status [message #294212 is a reply to message #288745] Wed, 16 January 2008 17:58 Go to previous message
Messages: 1
Registered: January 2008
Junior Member
its not possible to switchover untill the switchover_status column value is TO STANDBY. Sessions Active means, there are some sql statements running, probably insert or update. Try to stop them if any and try
Previous Topic: Oracle Data Guard for Reporting
Next Topic: Using DGMGRL on Sun Cluster 3.1
Goto Forum:

Current Time: Sat Aug 13 07:57:10 CDT 2022