Re: primary database dataguard archive

Posted by Roshan on Aug 09, 2017; 10:07am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/primary-database-dataguard-archive-tp3125p3127.html

I see there is a large gap between primary and standby DB

Standby DB
SQL> select max(sequence#) from v$archived_log where applied='YES' ;

MAX(SEQUENCE#)
--------------
        155750

SQL> select max(sequence#) from v$archived_log;

MAX(SEQUENCE#)
--------------
        156688

SHould I perform and incremental backup and restore?