Check Dataguard Sync Status Oracle 10g 11g

On Primary:-
select thread#, max(sequence#) “Last Primary Seq Generated”
from v$archived_log
where first_time between (sysdate-1) and (sysdate+1)
group by thread# order by 1;
On Standby:-
select thread#, max(sequence#) “Last Standby Seq Received”
from v$archived_log
group by thread# order by 1;
select thread#, max(sequence#) “Last Standby Seq Applied”
from v$archived_log where applied=’YES’
group by thread# order by 1;
SELECT THREAD#, SEQUENCE#, APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE# ASC;
select process, thread#, sequence#, status from v$managed_standby where process=’MRP0′;
#Status should be ‘APPLYING_LOG’

Category: DatabaseSQL

One comment

  1. Thanks for the article. Is there any way that we can automate this instead of doing this manually?

    Is there is a way I can connect to dataguard from the primary?

Leave a Reply

Article by: Shadab Mohammad