185
💡 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