Block Corruption, cant start DB -SOS

From: SGA <zeevikm_at_hotmail.com>
Date: 18 Sep 2002 01:49:18 -0700
Message-ID: <b0fb5246.0209180049.5f335a3f@posting.google.com>

Hello All,
This is what I get in alert log when trying to start DB. If anyone had similar problem before and have any idea how to startup the db anyway please help!

Thanks alot.

---

Alert log errors:

---

Tue Sep 17 16:51:25 2002
ALTER DATABASE OPEN
Beginning crash recovery of 1 threads
Tue Sep 17 16:51:27 2002
Thread recovery: start rolling forward thread 1 Recovery of Online Redo Log: Thread 1 Group 2 Seq 112952 Reading mem 0   Mem# 0 errs 0: /db/dwhs/data2/redo_raw/redo_g2_1.log   Mem# 1 errs 0: /db/dwhs/data2/redo_raw/redo_g2_2.log ***
Corrupt block relative dba: 0x1bcecb04 (file 111, block 969476) Bad header found during preparing block for write Data in bad block -
 type: 112 format: 114 rdba: 0x20646973
 last change scn: 0x0003.1a484def seq: 0x5 flg: 0x70  consistency value in tail: 0x4def7005
 check value in block header: 0x0, block checksum disabled  spare1: 0x6f, spare2: 0x64, spare3: 0x7465 ***
Tue Sep 17 16:53:03 2002
Errors in file /local/oracle/product/admin/DWHS/bdump/dwhs_dbw1_13174.trc: ORA-00600: internal error code, arguments: [kcbzpb_1], [466537220], [4], [0], [], [], [], []
Tue Sep 17 16:53:06 2002
Errors in file /local/oracle/product/admin/DWHS/bdump/dwhs_dbw1_13174.trc: ORA-00600: internal error code, arguments: [kcbzpb_1], [466537220], [4], [0], [], [], [], []
DBW1: terminating instance due to error 600 Instance terminated by DBW1, pid = 13174 Tue Sep 17 16:55:36 2002

---

DBV output on suspected dbf:

---

DBVERIFY: Release 8.1.7.3.0 - Production on Tue Sep 17 20:31:53 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

DBVERIFY - Verification starting : FILE = /db/dwhs/data2/DWHS_USA_31_1.dbf
Block Checking: DBA = 466537220, Block Type = KTB-managed data block kdbchk: row locked by non-existent transaction

        table=0   slot=3
        lockid=32   ktbbhitc=1

Page 969476 failed with check code 6101

DBVERIFY - Verification complete

Total Pages Examined         : 1280000
Total Pages Processed (Data) : 1264148
Total Pages Failing   (Data) : 1
Total Pages Processed (Index): 15369
Total Pages Failing   (Index): 0
Total Pages Processed (Other): 323
Total Pages Empty            : 160
Total Pages Marked Corrupt   : 0
Total Pages Influx           : 0

Received on Wed Sep 18 2002 - 03:49:18 CDT