Here is the case: On standby database: Check the apply lag: SQL> select name,value from v$dataguard_stats where name in ('transport lag','apply lag') and (value > '+00 01' or value is null); NAME VALUE -------------------- -------------------- apply lag +00 08:19:40 SQL> SELECT INST_ID, DEST_ID, DEST_NAME, STATUS, TYPE, SRL, RECOVERY_MODE FROM gV$ARCHIVE_DEST_STATUS WHERE DEST_ID=1; INST_ID DEST_ID DEST_NAME STATUS TYPE SRL RECOVERY_MODE ---------- ---------- ------------------------------------ --------- -------------- --- ----------------------- 2 1 LOG_ARCHIVE_DEST_1 VALID LOCAL NO MANAGED REAL TIME A