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

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.