← Data Guard
Oracle · Data Guard

How to check the archive log gap on an Oracle Data Guard standby

List missing archivelog sequences on an Oracle Data Guard standby from V$ARCHIVE_GAP.

Tested on11g12c18c19c21c23ai26ai

V$ARCHIVE_GAP reports missing archivelog sequences on the standby. Empty result = no gap; any row means FAL cannot advance past this range and you may need to manually register or copy the missing archivelogs from the primary.

SELECT thread#, low_sequence#, high_sequence#
FROM   v$archive_gap;
data guardarchive gapv$archive_gap