Skip to content
Advertisements

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.

Advertisements
6 Comments Post a comment
  1. khater #

    Very good article

    November 1, 2010
  2. smmer #

    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

    August 27, 2011
  3. smmer #

    My database also out this error, but learn your methods did not succeed.I’m new here.What should I do?

    August 27, 2011
  4. Sundar #

    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

    January 3, 2012
  5. ravi kumar #

    hello its saying datafile not found first check the backup exist or not.

    Thanks
    Ravi

    June 25, 2012

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: