Corrupt Data Block, some advice, pls?
- From: "Denham Eva" <EVAD@xxxxxxxxxx>
- To: "Oracle-L (E-mail 2)" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 19 Apr 2004 09:58:08 +0200
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
-----------------------------------------------------------------
Other related posts:
