Question

How do you find protection mode, the protection level, the role of the database, and switchover status ?

Answer 1

SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE, -
       PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS -
       FROM V$DATABASE;

     SQL> SELECT FS_FAILOVER_STATUS FSFO_STATUS, FS_FAILOVER_CURRENT_TARGET -
       TARGET_STANDBY, FS_FAILOVER_THRESHOLD THRESHOLD, -
       FS_FAILOVER_OBSERVER_PRESENT OBS_PRES -
       FROM V$DATABASE