MRP stuck on old scan whitch is not available in standby archivelogs

----- MRP stuck on old scan whitch is not available in standby archivelogs

1. check minimum scn from database datafiles.

SQL> select distinct to_char(fhscn, '99999999999999999999') as "Stby_datafile_hdr_SCN" from X$KCVFH;

Stby_datafile_hdr_SCN
---------------------
              1920034
              1921414
              1923571
              1923696
              1923788
              1923903
              1924025
              1924144
       12246209080156

2. found few old scn's in datafiles, now check which datafiles has old scn.
 
select file#, name, to_char(checkpoint_change#, '99999999999999999999') from v$datafile_header where checkpoint_change# = 0;

 FILE# NAME                                             
------ ----------------------------------------------------
    11 +DATA_P/DATAFILE/abc 
    24 +DATA_P/DATAFILE/abc 
    43 +DATA_P/DATAFILE/abc 


  SQL > select file#, name from v$datafile where file# = 299

3. Copy datafile identified in step 2 from primary to standby database
4. Recreate standby control file from current control file at primary. And restore at standby.
5. Restart standby recovery.

  sql> alter database recover managed standby database disconnect;

  SELECT PROCESS, STATUS, THREAD#, SEQUENCE#, BLOCK#, BLOCKS FROM GV$MANAGED_STANDBY;