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

Migrating From Oracle to PostgreSQL using ora2pg open source tools

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

How to configure Replication Manager (repmgr) ?