7 x 24 在线支持!
Oracle DBWR Terminates Instance With ORA-600 [kcbzpb_1] during Startup
Oracle DBWR Terminates Instance With ORA-600 [kcbzpb_1] during Startup
The information in this article applies to:
Oracle RDBMS in any platform usually after a instance crash caused by
some hardware problem.
Symptom(s)
~~~~~~~~~~
After the instance crashed you receive the following error during startup and
DBWR terminates instance:
***
Corrupt block relative dba: 0x02c31d6a (file 11, block 204138)
Bad header found during preparing block for write
Data in bad block -
type: 100 format: 101 rdba: 0x1e010101
last change scn: 0x0000.0c117747 seq: 0x2 flg: 0x20
consistency value in tail: 0x77476402
check value in block header: 0x0, block checksum disabled
spare1: 0x1, spare2: 0x1, spare3: 0x2020
***
Thu May 22 10:32:16 2003
Errors in file /oracle/app/oracle/admin/UNST/bdump/dbw0_1123.trc:
ORA-00600: internal error code, arguments: [kcbzpb_1], [46341482], [4], [0], [],
[], [], []
DBW0: terminating instance due to error 600
Instance terminated by DBW0, pid = 1123
Cause
~~~~~~~
Normally you will get this error after some hardware problem, like a disk or
a memory failure. You are not able to open database unless
you put corrupted block's datafile (you can identify it in alert log) offline.
Block corrupted is in the dirty queue when instance crashed and during startup
DBWR will try to write it to disk and got a failure.
Fix
~~~~
First you must find out and fix the hardware failure.