Monday, 15 December 2014

Find Archivelog GAP in Dataguard


select MAX(SEQUENCE#) from v$archived_log where ARCHIVED='YES';

select MAX(SEQUENCE#) from v$archived_log where APPLIED='YES';

No comments:

Post a Comment