Issue:- ORA-10562: Error occurred while applying redo to data block
While recovering the standby database found the below error in alert log
Sun Aug 09 03:21:37 2020
Errors in file /u01/app/testdb/oracle/diag/rdbms/testdb/testdb/trace/testdb_mrp0_15081.trc:
ORA-10562: Error occurred while applying redo to data block (file# 4, block# 7173)
ORA-10564: tablespace TOOLS
ORA-01110: data file 4: '/u01/app/testdb/oradata02/testdb/tools_01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 304906
ORA-00607: Internal error occurred while making a change to a data block
ORA-00602: internal programming exception
ORA-07445: exception encountered: core dump [kdr9ir2rst0()+886] [SIGSEGV]
[ADDR:0x7FFC05A5AFE0] [PC:0xB589B86] [Address not mapped t
Sun Aug 09 03:21:37 2020
MRP0: Background Media Recovery process shutdown (testdb)
To Resolve the issue I have implemented the below steps
1) Take the backup of the data file which is impacted (Backup need to take from primary database)
In My case data file 4 is impacted
connect to RMAN on primary
rman target /
Recovery Manager: Release 12.1.0.2.0 - Production on Sun Aug 9 03:54:26 2020
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
connected to target database: prod (DBID=3642994164)
RMAN> backup datafile 4 format '/u01/app/prod/backup/Datafilefile_4.bk';
2) Transfer the backup piece to standby database
You can use any tool to move file from primary to standby(i.e scp,ftp)
3) catalog the backup piece location on the standby side
RMAN> catalog backuppiece '/u01/app/backup/Datafilefile_4.bk';
4) check and confirm the backup piece
RMAN> list backuppiece '/u01/app/backup/Datafilefile_4.bk';
RMAN> list backup of datafile 4;
once confirm the backup
5) check mrp is running if mrp is running stop it .
alter database recover managed standby database cancel;
6)once MRP down restore the backup
RMAN> Restore datafile 4;
channel ORA_DISK_1: restore complete, elapsed time: 00:02:20
Finished restore at 09-Aug-20
7) start the MRP on standby database
SQl> Alter database recover managed standby disconnect from session;
check the alert log it will start applying the alert log
Hope it will help to resolve issue
Thank you .
