← 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