ORA-19566: exceeded limit of 0 corrupt blocks
When i try to take backup, it will shows block corrupted errors,
RMAN> backup database;
Starting backup at 25-MAY-10
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
input datafile fno=00003 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/sysaux01.dbf
input datafile fno=00005 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/example01.dbf
input datafile fno=00006 name=/home/oracle/oracle/mytest/test01.dbf
input datafile fno=00002 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/undotbs01.dbf
input datafile fno=00004 name=/home/oracle/oracle/product/10.2.0/oradata/orcl/users01.dbf
channel ORA_DISK_1: starting piece 1 at 25-MAY-10
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/25/2010 13:22:00
ORA-19566: exceeded limit of 0 corrupt blocks for file /home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf
In this case, i have checked my alert log file and find out which block corrupted and reocvered using rman.
My alertlog file
Hex dump of (file 1, block 61441) in trace file /home/oracle/oracle/product/10.2.0/db_1/admin/orcl/udump/orcl_ora_17556.trc
Corrupt block relative dba: 0x0040f001 (file 1, block 61441)
Completely zero block found during backing up datafile
Reread of blocknum=61441, file=/home/oracle/oracle/product/10.2.0/oradata/orcl/system01.dbf. found same corrupt data
RMAN> blockrecover datafile 1 block 61441;
Starting blockrecover at 25-MAY-10
using channel ORA_DISK_1
(skipped)
Finished blockrecover at 25-MAY-10.