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

ORA-01261: Parameter db_recovery_file_dest destination string cannot be translated ORA-01262: Stat failed on a file destination directory Linux-x86_64 Error: 2: No such file or directory

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

PostgreSQL Pgbadger Installation On Linux

PostgreSQL Database startup / shutdown /restart