Fix : ORA-10562: Error occurred while applying redo to data block

During recovering in standby using manual process ( no DG configured), I found below error in laert log.

Error in Alert Log:

Thu Mar 31 10:42:10 2016
Dumping diagnostic data in directory=[cdmp_20160331104210], requested by (instance=1, osid=23658610 (PR01)), summary=[incident=4
226].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Slave exiting with ORA-10562 exception
Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_pr01_23658610.trc:
ORA-10562: Error occurred while applying redo to data block (file# 80, block# 1288553)
ORA-10564: tablespace sample
ORA-01110: data file 80: '/u02/flash_recovery_area/PROD/ORADATA/sample01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 89532
ORA-00600: internal error code, arguments: [kdBlkCheckError], [80], [1288553], [6264], [], [], [], [], [], [], [], []
Recovery Slave PR01 previously exited with exception 10562
Thu Mar 31 10:42:10 2016
Errors with log /u03/restore_archive/2016_03_30/thread_2_seq_625.1575.907832317
MRP0: Background Media Recovery terminated with error 448
Errors in file /u01/app/oracle/diag/rdbms/prod/PROD/trace/PROD_pr00_9109508.trc:
ORA-00448: normal completion of background process
Recovery interrupted!

Solution:

(1) Take backup of related datafiles.(in primary)

e.g.,
RMAN> backup datafile 80 format '/u02/df_80_pr.bk' ;

Now transfer this backup piece to standby server.

(2) In standby : catalog the backup piece location 

RMAN > catalog backuppiece '/u03/backup_files/df_80_pr.bk';

Then list it for confirmation.

RMAN> list backuppiece'/u03/backup_files/df_80_pr.bk';
RMAN> list backup of datafile 80; # Check the backup piece

(3) Cancel MRP if started.

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

(4) Restore from backup piece:

e.g., restore datafile 80; # restore datafile 80 ;

RMAN> restore datafile 80;

Starting restore at 31-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=199 device type=DISK

channel ORA_DISK_1: starting datafile backup set restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
channel ORA_DISK_1: restoring datafile 00080 to /u02/flash_recovery_area/PROD/ORADATA/sample01.dbf
channel ORA_DISK_1: reading from backup piece /u03/backup_files/df_80_pr.bk
channel ORA_DISK_1: piece handle=/u03/backup_files/df_80_pr.bk tag=TAG20160331T121840
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:45
Finished restore at 31-MAR-16

RMAN>

(5) Start the MRP in standby:

SQL> alter database recover managed standby database disconnect ;

Sure, It will apply archivelogs again.

Thanks .