Help with Oracle corruption

From: Alistair Thomson <thomson_alistair_at_no.spam.yahoo.co.uk>
Date: Wed, 20 Nov 2002 10:32:55 -0000
Message-ID: <arfocm$hd2$1$8302bc10@news.demon.co.uk>

Oracle 8.1.7.0.0 EE
NT 4 service pack 6e

I have some very large partitioned tables. When trying to delete some records I was getting the following trace files and on two occassions the server crashed! Nothing was showing in the alert log.

I've searched through metalink but can't find anything of much use!

The trace file contains information as shown below:

SESSION ID:(14.37185) 2002-10-16 06:00:34.078
***
Corrupt block relative dba: 0x114042e3 (file 69, block 17123) Bad header found during buffer read Data in bad block - type: 6 format: 2 rdba: 0x114042db last change scn: 0x0000.54f4cd23 seq: 0x1 flg: 0x02 consistency value in tail: 0xcd230601 check value in block header: 0x0, block checksum disabled spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x114042e3 (file 69, block 17123) found valid data
***
Corrupt block relative dba: 0x114101fa (file 69, block 66042) Bad header found during buffer read Data in bad block - type: 6 format: 2 rdba: 0x114101f2 last change scn: 0x0000.557786e1 seq: 0x1 flg: 0x02 consistency value in tail: 0x86e10601 check value in block header: 0x0, block checksum disabled spare1: 0x0, spare2: 0x0, spare3: 0x0
***
Reread of rdba: 0x114101fa (file 69, block 66042) found valid data

Any advice about what's going wrong here or how to fix it would be appreciated.

Thanks

Alistair Received on Wed Nov 20 2002 - 04:32:55 CST