Query to check whether logs are applying at DR side or not.

Below query will display archive logs applying block by block:

select PROCESS, status,THREAD#,SEQUENCE#,BLOCK#,BLOCKS from gv$managed_standby;

 

Below query will display total count of archive applied at DR side:

From below replace sequence# and thread# accordingly:

select distinct THREAD#,SEQUENCE# from v$archived_log where sequence# like '3080%' and thread#=2 order by 2;
Please share If you like..Share on FacebookShare on Google+Tweet about this on TwitterShare on LinkedInShare on Yummly

3 Comments

Add a Comment
  1. Good Very NeedFull

  2. I am often blogging and i really appreciate your content. The article has really peaked my interest. I am going to bookmark your site and keep checking for new inofnmatior.

Leave a Reply

Your email address will not be published. Required fields are marked *

Fariddin Shaikh's Oracle DBA Blog © 2016 Being DBA
Go Back