Re: Fractured block found during backup
- From: Luis Freitas <lfreitas34@xxxxxxxxx>
- To: ora-apps-dba@xxxxxxxxxxxxx
- Date: Mon, 17 Nov 2008 02:56:29 -0800 (PST)
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:
