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.
DBA 
Very good article
You’re Welcome 🙂
Hex dump of (file 5, block 11701) in trace file /u01/app/oracle/admin/ora10g/udump/ora10g_ora_6482.trc
Corrupt block relative dba: 0x01402db5 (file 5, block 11701)
Bad check value found during backing up datafile
Data in bad block:
type: 0 format: 2 rdba: 0x01402db5
last change scn: 0x0000.00000000 seq: 0x1 flg: 0x05
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x00000001
check value in block header: 0x8bf5
computed block checksum: 0x2
Reread of blocknum=11701, file=/u01/app/oracle/oradata/ora10g/example01.dbf. found same corrupt data
RMAN> blockrecover datafile 5 block 11701;
Starting blockrecover at 27-AUG-11
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of blockrecover command at 08/27/2011 19:40:13
RMAN-06026: some targets not found – aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
My database also out this error, but learn your methods did not succeed.I’m new here.What should I do?
Hi,
I’m facing the same issue now. My first RMAN backup showing ora-19566 . I can’t do a “block recover” in rman, because this is my first RMAN backup.
Any advise ?
Sundar K
hello its saying datafile not found first check the backup exist or not.
Thanks
Ravi