# When DATABASE_ROLE=”PHYSICAL STANDBY” AND “MOUNTED” is the result for OPEN_MODE – the standby is NOT in active dataguard mode, when OPEN_MODE=”READ ONLY” and DATABASE_ROLE=”PHYSICAL STANDBY” then you are using active dataguard.
SQL> SELECT database_role, open_mode FROM v$database;
DATABASE_ROLE OPEN_MODE
—————- ——————–
PHYSICAL STANDBY MOUNTED
SQL> set line 400
SQL> — only returns rows when connected to the standby
select * from v$dataguard_stats;SQL>
SOURCE_DBID SOURCE_DB_UNIQUE_NAME NAME VALUE UNIT TIME_COMPUTED DATUM_TIME CON_ID
———– ——————————– ——————————– —————————————————————- —————————— —————————— —————————— ———-
0 transport lag +00 00:00:00 day(2) to second(0) interval 08/28/2017 14:46:07 08/28/2017 14:46:06 0
0 apply lag +00 00:00:00 day(2) to second(0) interval 08/28/2017 14:46:07 08/28/2017 14:46:06 0
0 apply finish time +00 00:00:00.000 day(2) to second(3) interval 08/28/2017 14:46:07 0
0 estimated startup time 9 second 08/28/2017 14:46:07 0