← 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