ORA-10562: Error occurred while applying redo to data block (file# 11, block# 238825)

 💡 I was cloning a database from rman backup . After completion of cloning, when I did RESETLOG it failed with ORA-00344 error.

Errors in file /u01/app/oracle/admin/icai/bdump/icai_mrp0_20855.trc:
ORA-10562: Error occurred while applying redo to data block (file# 11, block# 238825)
ORA-10564: tablespace CADATA
ORA-01110: data file 11: '/bkp/data/cadata01.dbf'
ORA-10560: block type 'FIRST LEVEL BITMAP BLOCK'
ORA-00600: internal error code, arguments: [ktspfredo-clr], [0], [8], [], [], [], [], []

SOLUTION:

First, check the status of REDO LOGS.

RMAN> backup validate check logical database;

Starting backup at 05-SEP-10
using target database controlfile instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=86 devtype=DISK
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00011 name=/bkp/data/cadata01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/icai/undotbs01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/icai/indx01.dbf
input datafile fno=00001 name=/u01/app/oracle/oradata/icai/system01.dbf
input datafile fno=00009 name=/u01/app/oracle/oradata/icai/users01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/icai/example01.dbf
input datafile fno=00010 name=/u01/app/oracle/oradata/icai/xdb01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/icai/cwmlite01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/icai/drsys01.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/icai/odm01.dbf
input datafile fno=00008 name=/u01/app/oracle/oradata/icai/tools01.dbf
input datafile fno=00023 name=/bkp/data/cadata02.dbf
input datafile fno=00018 name=/bkp/data/UNDOTBS03.dbf
input datafile fno=00022 name=/bkp/data/undotbs02.dbf
input datafile fno=00021 name=/bkp/data/tempschema01.dbf
input datafile fno=00017 name=/bkp/data/cadatawro01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:26:36
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00016 name=/bkp/data/cadataoth01.dbf
input datafile fno=00019 name=/bkp/data/mfxpima01.dbf
input datafile fno=00020 name=/bkp/data/racconfig01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:25
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00015 name=/bkp/data/cadatanro01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00012 name=/bkp/data/cadatacro01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00013 name=/bkp/data/cadataero01.dbf
input datafile fno=00014 name=/bkp/data/cadataho01.dbf
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:35
Finished backup at 05-SEP-10

RMAN> blockrecover corruption list;

Starting blockrecover at 05-SEP-10
using channel ORA_DISK_1

starting media recovery
media recovery complete

Finished blockrecover at 05-SEP-10

RMAN>

SQL> select * from v$database_block_corruption ;

no rows selected

SQL> /

no rows selected

Related posts

Error: ORA-16765: Redo Apply is running

Khắc phục lỗi recovery khi OPEN RESETLOGS lỗi SYSTEM trong Oracle Database?

check the FRA usage and troubleshoot the issue in oracle DB