Corrupt Data Block, some advice, pls?

From: Denham Eva <EVAD_at_TFMC.co.za>
Date: Mon, 19 Apr 2004 09:58:08 +0200
Message-ID: <B822F724868AE8419D78F162BE7C2DB6694ECB@cent12000.tfmc.co.za>

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

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_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 - 02:54:35 CDT