Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

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

Popular posts from this blog

PostgreSQL Pgbadger Installation On Linux

PostgreSQL pgBadger

How to configure Replication Manager (repmgr) ?

Migrating From Oracle to PostgreSQL using ora2pg open source tools

How To Schedule PostgreSQL Jobs using pgAgent on Linux plateform