Re: Help with Oracle corruption

Hi Alistair,

Check out c.d.o.server.

Cheers

Richard
"Alistair Thomson" <thomson_alistair_at_no.spam.yahoo.co.uk> wrote in message news:arfocm$hd2$1$8302bc10_at_news.demon.co.uk...
> Hi
>
> 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 - 08:08:10 CST