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’
One comment
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?