SQL Query to fetch dataguard sync status after resetlogs

SQL Query to fetch dataguard sync status after reset logs

You may run both the below query on Primary site:

select 'PROD = '||max(a.sequence#) from v$archived_log a join v$database_incarnation b using (resetlogs_id) where b.status = 'CURRENT';

select 'DR   = '||max(a.sequence#) from v$archived_log a join v$database_incarnation b using (resetlogs_id) where b.status = 'CURRENT' and a.applied= 'YES';

The result should look like below:

PROD = 91678

  

DR   = 91678

----