Re: Fractured block found during backup

Khayyam,

   The last message ("Reread of blocknum=1393523, 
file=/u1/ibs/data/datausr04.dbf. found valid data") indicate there is no 
corruption on disk.

   This likely indicates a operating system or disk controller issue. Even so 
it is better to check the datafile with DBV or rman to be sure there is no 
corruption. If you do daily backups with RMAN the error should not appear on 
the next full backup.

   If the block is really corrupted then fixing it may not be easy since you 
will need a backup from before the corruption took place. Look to see if the 
message repeats in the alert.log with the same block each time the backup run.

   Also the operating system or disk controller problem needs to be fixed since 
it could be causing silent corruption of your database. If it fails on reads it 
could be failing on writes also. This kind of issue would show the message 
several times on the alert.log with different block numbers.  If you dont need 
performance on this database you may want to enable block checking or disable 
asyncronous I/O until you can diagnose the issue more clearly.

Regards,
Luis


--- On Sun, 11/16/08, khabeer khayyam <khabeer1983@xxxxxxxxx> wrote:
From: khabeer khayyam <khabeer1983@xxxxxxxxx>
Subject: Fractured block found during backup
To: ora-apps-dba@xxxxxxxxxxxxx
Date: Sunday, November 16, 2008, 5:36 AM

Hello!

The backup policy we've in our organization is:

RMAN - 0300 hrs

Export - 0500 hrs

When I logged in today n checked the Alert logfile it shows:

Corrupt block relative dba: 0x0bd54373 (file 47, block 1393523)
Fractured block found during backing up datafile
Data in bad block -
 type: 6 format: 2 rdba: 0x0bd54373
 last change scn: 0x0002.cf262152 seq: 0x1 flg: 0x04
 consistency value in tail: 0x26e70606
 check value in block header: 0x7058, computed block checksum: 0x3ce2
 spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of blocknum=1393523, file=/u1/ibs/data/datausr04.dbf. found valid data
Hex dump of Absolute File 47, Block 1393863 in trace file 
/u5/ibs/dump/udump/mcibs54_ora_22273.trc

Please help me in resolving this

Thanks & Regards,

Khayyam 

 
       Connect with friends all over the world.  Get Yahoo! India Messenger.

Other related posts: