CHECKING Dataguard ARCHIVE SYNC

SIMPLE STEPS TO CHECK ARCHIVE SYNC

PRIMARY:
Run this below query in Primary side

select max(sequence#), archived FROM V$LOG where status <>'CURRENT' group by archived;


STANDBY:
Run this below query at Standby side

select max(first_time),max(sequence#), applied from v$archived_log group by applied;