SWITCHOVER_STATUS

VARCHAR2(18)

Indicates whether switchover is allowed:

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.
SESSIONS 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. Query the V$SESSION view to identify the specific processes that need to be terminated.
SWITCHOVER PENDING - This is a standby database and the primary database switchover request has been received but not processed.
SWITCHOVER LATENT - The switchover was in pending mode, but did not complete and went back to the primary database.
TO PRIMARY - This is a standby database and is allowed to switch over to a primary database.
TO STANDBY - This is a primary database and is allowed to switch over to a standby database.
RECOVERY NEEDED - This is a standby database that has not received the switchover request.

[@more@]

ITPub博客

oracle 9i physical standby database 中v$database switchover_status的含义