RE: Corrupt Data Block, some advice, pls?
- From: Srinivasan Vasan <Vasan.Srinivasan@xxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Apr 2004 10:35:53 +0100
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@xxxxxxxxxx]
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
76101 is marked corrupt
***
Corrupt block relative dba: 0x03012945 (file 0, block 76101)
Bad header found during dbv:
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
***
....
.........................................................................=
.......
.........................................................................=
.......
................
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
