Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Corrupt Data Block, some advice, pls?
There is a block edit utility that can be used to edit the contents of
blocks. To be used with care. We have used it once (to set everything in the
block to zero) when we knew for sure that the contents of the block were no
longer accessed.
Cheers,
Vasan.
-----Original Message-----
From: Denham Eva [mailto:EVAD_at_TFMC.co.za]
Sent: 19 April 2004 08:58
To: Oracle-L (E-mail 2)
Subject: Corrupt Data Block, some advice, pls?
Hello Group,
We had a Disk go on us the other day, I got a=20
***
Corrupt block relative dba: 0x03012945 (file 12, block 76101)
Bad header found during buffer read
Data in bad block -
type: 6 format: 2 rdba: 0x03012945
last change scn: 0x0000.05dae8f2 seq: 0x2 flg: 0x00
consistency value in tail: 0xe8f20602
check value in block header: 0xc1d5, block checksum disabled
spare1: 0x0, spare2: 0x0, spare3: 0x0
***
In the Alert Log. The disk was replaced and the Raid rebuilt.
I also dropped and rebuilt the object involved, all successful. Backup = also runs smoothly without error.
However when I do a DB_Verify, I get the following
E:\oracle>dbv file=3De:\oracle\oradata\xxxxxx\xxxxxxxx05.ora =
feedback=3D1000 blocksi
ze=3D8192
DBVERIFY: Release 8.1.7.4.1 - Production on Mon Apr 19 09:32:13 2004
(c) Copyright 2000 Oracle Corporation. All rights reserved.
DBVERIFY - Verification starting : FILE =3D =
e:\oracle\oradata\xxxx\xxxxxx05.or
a
.........................................................................=...Page
.... .........................................................................= ....... .........................................................................=.......
................
DBVERIFY - Verification complete
Total Pages Examined : 256000 Total Pages Processed (Data) : 194147 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 513 Total Pages Failing (Index): 0 Total Pages Processed (Other): 123 Total Pages Empty : 61216 Total Pages Marked Corrupt : 1 Total Pages Influx : 0
Question is Is there some way that to correct Oracle's marked status, or = should I live with it?
TIA
Regards
Denham
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ___________________________________________________________________________ This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Mon Apr 19 2004 - 04:32:14 CDT
![]() |
![]() |