Description of the switchover_status column in the dynamic performance view of v $ database in Oracle DataGuardHelloblock writing)
SESSIONS ACTIVE
Active SQL sessions exist in the primary database. These sessions must be disconnected before continuing execution.
TO PRIMARY
The standby database can be converted to the primary database.
TO STANDBY
The primary database can be converted to a backup database.
TO LOGICAL STANDBY
The master database has received a complete dictionary from the logical standby database.
NOT ALLOWED
The current database is not a master database with a backup database.
PREPARING DICTIONARY
The logical standby database is sending its redo data to a primary database and other standby databases to prepare for switchover.
PREPARING SWITCHOVER
When you accept the redo data used for switching, the logical backup configuration will use it.
RECOVERY NEEDED
The slave database has not received the switch request.
SWITCHOVER PENDING
Applicable to the standby databases that have received the master database switch request but have not yet processed the request.
SWITCHOVER LATENT
The switchover is not completed and is returned to the primary database.
Mail: helloblock@126.com
QQ: 1654294099
This article is from the "Helloblock DBA footprint" blog, please be sure to keep this source http://helloblock.blog.51cto.com/7899615/1294371
