I have create DR for 12.1.0.2 database. After starting the recovery , still it is showing lag.
I have enabled dest_2 at primary as well.
alert log standby is saying below
Media Recovery Log /u01/PRODDR/archive/PRODDR/archivelog/2017_11_15/o1_mf_2_68952_f0s7w3kf_.arc
Media Recovery Waiting for thread 1 sequence 68782
Fetching gap sequence in thread 1, gap sequence 68782-68782
Completed: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE disconnect from session
ALTER DATABASE RECOVER Managed standby database cancel
Thu Nov 16 09:54:28 2017
FAL[client]: Failed to request gap sequence
GAP - thread 1 sequence 68782-68782
DBID 3470723829 branch 827335029
FAL[client]: All defined FAL servers have been attempted.
------------------------------------------------------------
Check that the CONTROL_FILE_RECORD_KEEP_TIME initialization
parameter is defined to a value that's sufficiently large
enough to maintain adequate log switch information to resolve
archivelog gaps.
------------------------------------------------------------
I have applied RMAN incremental backup using SCN , still same.
Query output from standby:
SQL> select arch.thread# "Thread",arch.sequence# "Last Sequence Received",
appl.sequence# "Last Sequence Applied",(arch.sequence# - appl.sequence#) "Difference"
from (select thread#,max(sequence#) as sequence#
from v$archived_log
where RESETLOGS_CHANGE# = (SELECT RESETLOGS_CHANGE# FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT')
and archived = 'YES'
group by thread#
2 3 4 5 6 7 8 order by thread#
) arch,
(select thread#,max(sequence#) as sequence#
from v$archived_log
where RESETLOGS_CHANGE# = (SELECT RESETLOGS_CHANGE# FROM V$DATABASE_INCARNATION WHERE STATUS = 'CURRENT')
and applied = 'YES'
group by thread#
order by thread#
) appl
where arch.thread# = appl.thread#; 9 10 11 12 13 14 15 16 17
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 68794 68788 6
2 68960 68957 3