Finding Redo log Gap


On primary database:
select thread#,max(sequence#)
from v$archived_log group by thread#;

On standby database:
select thread#,max(sequence#),applied from v$archived_log
where applied='YES' group by thread#,applied;

An alternative to running the two commands above is to run the following command on the standby database:
select * from v$dataguard_stats where name = 'apply lag';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: