Pages

Sunday, December 10, 2017

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




----

No comments:

Post a Comment