Query to check protection mode in Oracle database

 

#Query to check protection mode in Oracle database SQL> set lines 300 pages 3000 SQL> col name for a14 SQL> col DB_UNIQUE_NAME for a14 SQL> select name,db_unique_name,open_mode,database_role,protection_mode,controlfile_type from v$database; NAME  DB_UNIQUE_NAME OPEN_MODE    DATABASE_ROLE  PROTECTION_MODE      CONTROL ----- -------------- ------------ -------------- -------------------- ------- TEST  test           READ WRITE   PRIMARY        MAXIMUM PERFORMANCE  CURRENT