Oracle Dataguard Switchover_Status
The switchover_status column of v$database can have the following values:
1.Not Allowed : Either this is a standby database and the primary database has not been switched first, or this is a primary database and there are no standby databases.
2.Session Active : Indicates that there are active SQL sessions attached to the primary or standby database that need to be disconnected before the switchover operation is permitted.
3.Switchover Pending : This is a standby database and the primary database switchover request has been received but not processed.
4.Switchover Latent : The switchover was in pending mode, but did not complete and went back to the primary database.
5.To Primary : This is a standby database, with no active sessions, that is allowed to switch over to a primary database.
6.To Standby : This is a primary database, with no active sessions, that is allowed to switch over to a standby database.
7.Recovery Needed : This is a standby database that has not received the switchover request
Comments
Post a Comment