Hello, I am having a DG setup on 12.2 test box. Currently my standby is lagging behind primary, and the mrp0 is stuck with wait_for_gap. There were some issues due to which the archive log was not sent across and its not available on the primary either. So I took incremental backup of the primary and restored on the standby. The scn did move forward but when recovery is started the MRP is stuck with the gap. Please advise how to resolve this issue.
-- On Standby
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
6649000
-- On Primary
SQL> select current_scn from v$database;
CURRENT_SCN
-----------
6974893
SQL> select scn_to_timestamp(6974893) from dual;
SCN_TO_TIMESTAMP(6974893)
---------------------------------------------------------------------------
20-MAY-18 04.33.56.000000000 AM
SQL> select scn_to_timestamp(6649000) from dual;
SCN_TO_TIMESTAMP(6649000)
---------------------------------------------------------------------------
19-MAY-18 06.35.49.000000000 AM
********After doing the restoring the incremental backup on the standby and recovering the database the SCN has moved ahead on the standby but the MRP is stuck
SQL> select current_scn from v$database; -- The scn has moved forward but the mrp is stuck
CURRENT_SCN
-----------
6981765
SQL> select process, status,thread#,sequence# from v$managed_standby where process = 'MRP0';
PROCESS STATUS THREAD# SEQUENCE#
--------- ------------ ---------- ----------
MRP0 WAIT_FOR_GAP 1 116
SQL> select * from v$archive_gap;
no rows selected