← Data Guard
Oracle · Data Guard
How to list applied archivelogs on an Oracle Data Guard standby
List archivelogs marked applied on an Oracle Data Guard standby with thread, sequence, and time range from GV$ARCHIVED_LOG.
Tested on11g12c18c19c21c23ai26ai
Simple listing of archivelogs marked applied=''YES''. Useful for spot-checking whether a specific sequence range made it through, or for auditing apply activity over a window.
SELECT thread#, sequence#, first_time, next_time, applied
FROM gv$archived_log
WHERE applied = 'YES';data guardapplied archiveloggv$archived_log