Home » Server Options » Data Guard » Switchover status (Oracle 9.2.0.1.0)
Switchover status [message #288745] Tue, 18 December 2007 09:17 Go to next message
sushil.krishn
Messages: 7
Registered: October 2007
Location: Bangalore
Junior Member
Hi,
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

Report message to a moderator

Re: Switchover status [message #294212 is a reply to message #288745] Wed, 16 January 2008 17:58 Go to previous message
chiluveru49
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

Report message to a moderator

Previous Topic: Oracle Data Guard for Reporting
Next Topic: Using DGMGRL on Sun Cluster 3.1
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jan 15 04:57:12 CST 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.