Primary DB --------------------------------------------------------------------------------------------- SQL> connect /as sysdba Connected. SQL> select max(sequence#) Last_Archived_Log_Applied from v$archived_log where Applied=’YES’; LAST_ARCHIVED_LOG_APPLIED ------------------------- 27727 SQL> ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive destination E:\oracle\WU1\oraarch\WU1arch Oldest online log sequence 2080 Next log sequence to archive 2083 Current log sequence 2083 Standby DB --------------------------------------------------------------------------------------------- SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- ARCH CONNECTED 0 0 0 0 ARCH CLOSING 1 1613 1 129 RFS IDLE 0 0 0 0 MRP0 WAIT_FOR_LOG 1 27727 0 0 RFS IDLE 1 2083 21524 3 SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM V$MANAGED_STANDBY; PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS --------- ------------ ---------- ---------- ---------- ---------- ARCH CONNECTED 0 0 0 0 ARCH CLOSING 1 1613 1 129 RFS IDLE 0 0 0 0 MRP0 WAIT_FOR_LOG 1 27727 0 0 RFS IDLE 1 2083 21864 1 SQL> select max(sequence#) Last_Archived_Log_Applied from v$archived_log where Applied='YES'; LAST_ARCHIVED_LOG_APPLIED ------------------------- 27726 SQL> select * from v$archive_gap; no rows selected SQL> ARCHIVE LOG LIST Database log mode Archive Mode Automatic archival Enabled Archive destination E:\oracle\WU1\oraarch\WU1arch Oldest online log sequence 27724 Next log sequence to archive 0 Current log sequence 27727 SQL>