Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Check Data Guard Recovery Mode
You can find database_mode, recovery mode and protection mode of your Data Guard as follows.
1 2 3 4 5 | SQL> select DATABASE_MODE, RECOVERY_MODE, PROTECTION_MODE from v$archive_dest_status; DATABASE_MODE RECOVERY_MODE PROTECTION_MODE --------------- ----------------------- -------------------- MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE |
Data Guard Recovery Modes
| IDLE | Shows that Recovery is not enabled. |
| MANAGED | Shows that ARCHIVED Recovery is enabled. |
| MANAGED REAL TIME APPLY | Shows that Real-Time Recovery is enabled. |
| LOGICAL REAL TIME APPLY | Shows that Real-Time Recovery is enabled in Logical Standby. |
| LOGICAL APPLY | Shows that ARCHIVED Recovery is enabled in Logical Standby. |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 | SQL> desc v$archive_dest_status Name Null? Type ----------------------------------------- -------- ---------------------------- DEST_ID NUMBER DEST_NAME VARCHAR2(256) STATUS VARCHAR2(9) TYPE VARCHAR2(14) DATABASE_MODE VARCHAR2(15) RECOVERY_MODE VARCHAR2(23) PROTECTION_MODE VARCHAR2(20) DESTINATION VARCHAR2(256) STANDBY_LOGFILE_COUNT NUMBER STANDBY_LOGFILE_ACTIVE NUMBER ARCHIVED_THREAD# NUMBER ARCHIVED_SEQ# NUMBER APPLIED_THREAD# NUMBER APPLIED_SEQ# NUMBER ERROR VARCHAR2(256) SRL VARCHAR2(3) DB_UNIQUE_NAME VARCHAR2(30) SYNCHRONIZATION_STATUS VARCHAR2(22) SYNCHRONIZED VARCHAR2(3) GAP_STATUS VARCHAR2(24) |
