ORA-00600: internal error code, arguments:[kdBlkCheckError] 错误解析

Posted by PDSERVICE on Jun 01, 2016 In

ORA-00600: internal error code, arguments:[kdBlkCheckError]

【Oracle数据恢复】ORA-600[kdBlkCheckError]错误解析

kdBlkCheckError本质上是 Kernel Data Block Check Error, 是对数据块的逻辑检测配合db_block_checking的存在，当db_block_checking!=false 且其发现了一个损坏，则报一个ORA-600 [kddummy_blkchk] / ORA-600 [kdBlkCheckError] . 进一步的损坏/坏块将被终止

kdBlkCheckError/kddummy_blkchk有一大堆的检测代码，每一个检测代码对应对数据块中数据的一个逻辑分析，如果分析发现存在mismatch则认为数据块存在逻辑讹误。

例如检测代码23001 代表Wrong total extent count。

如果出现ORA-00600[kdBlkCheckError]则一般是ORACLE 软件BUG 或者内存存在讹误。

如果自己搞不定可以找诗檀软件专业ORACLE数据库修复团队成员帮您恢复!

诗檀软件专业数据库修复团队

服务热线： 13764045638 QQ号:47079569 邮箱：service@parnassusdata.com

与该ORA-00600[kdBlkCheckError]错误相关的Bug Note如下：

NB	Bug	Fixed	Description
	17447078	12.1.0.2, 12.2.0.0	Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors
	14400110	11.2.0.4, 12.2.0.0	Bad redo / ORA-600 [kdBlkCheckError] .. [6135] for opcode 19.1 redo
	12349316	11.2.0.4, 12.2.0.0	DBMS_SPACE_ADMIN.TABLESPACE_FIX_BITMAPS fails with ORA-600 [kddummy_blkchk] / ORA-600 [kdBlkCheckError] / ORA-607
	14351566	11.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1	ORA-600 [kclchkblk_4] when doing flash back
	16347904	11.2.0.4, 12.2.0.0	Corrupt block with check code 6101, 6110 or 6255 on compressed table with DML workload
	17325413	12.1.0.2	Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption
	14741727	11.2.0.2.9, 11.2.0.2.BP19, 11.2.0.3.BP12, 11.2.0.3.BP13, 12.1.0.1	Fixes for bug 12326708 and 14624146 can cause problems – backout fix
	14551844	11.2.0.4, 12.1.0.1	ORA-600 [kdblkcheckerror] [6126] / ORA-600 [17182] for DELETE / INSERT (QMD / QMI) in COMPRESS BASIC table due to negative avsp
	13804294	11.2.0.3.4, 11.2.0.3.BP07, 11.2.0.4, 12.1.0.1	Internal errors, corruptions, using pipelined function whose rows raise exceptions
	13715932	11.2.0.4, 12.1.0.1	CREATE TABLE fails with ORA-600 [kddummy_blkchk] with large datafile
*	13605839	11.2.0.3.8, 11.2.0.3.BP21, 11.2.0.4, 12.1.0.1	ORA-600 [ktbsdp1] ORA-600 [kghfrempty:ds]. Corruption in Rollback with Clusterwide Global Transactions in RAC
	12417369	11.2.0.2.5, 11.2.0.2.BP13, 11.2.0.2.GIPSU05, 11.2.0.3, 12.1.0.1	Block corruption from rollback on compressed table
*	10205230	11.2.0.1.6, 11.2.0.1.BP09, 11.2.0.2.2, 11.2.0.2.BP04, 11.2.0.3, 12.1.0.1	ORA-600 / corruption possible during shutdown in RAC
	10180121	11.2.0.3, 12.1.0.1	ORA-600 [kdBlkCheckError] .. [6251] / block corruption during parallel DML
+	9724970	11.2.0.1.BP08, 11.2.0.2.2, 11.2.0.2.BP02, 11.2.0.3, 12.1.0.1	Block Corruption with PDML UPDATE. ORA_600 [4511] OERI[kdblkcheckerror] by block check
*	9711859	10.2.0.5.1, 11.1.0.7.6, 11.2.0.2, 12.1.0.1	ORA-600 [ktsptrn_fix-extmap] / ORA-600 [kdblkcheckerror] during extent allocation caused by bug 8198906
	9541485	11.2.0.4, 12.1.0.1	Create materialized view on views based on CON$ fails with ORA-600 [kdBlkCheckError]
*	9406607	11.2.0.1.3, 11.2.0.1.BP06, 11.2.0.2, 12.1.0.1	Corrupt blocks in 11.2 in table with unique key. OERI[kdBlkCheckError] by block check
	9295217	11.2.0.2, 12.1.0.1	ORA-600 [ktsk_dba_to_hwm-1] / corruption during SHRINK of HWM
+	9019113	11.2.0.1.BP02, 11.2.0.2, 12.1.0.1	ORA-600 [17182] for OLTP COMPRESS table in OLTP Compression REDO during RECOVERY
	8720802	10.2.0.5, 11.2.0.1.BP07, 11.2.0.2, 12.1.0.1	Add check for row piece pointing to itself (db_block_checking,dbv,rman,analyze)
*	8331063	11.2.0.3, 12.1.0.1	Corrupt Undo. ORA-600 [2015] during rollback in undo block for COMPRESS table with SUPPLEMENTAL LOGGING
	8277580	11.1.0.7.2, 11.2.0.1, 11.2.0.2, 12.1.0.1	Corruption on compressed tables during Recovery and Quick Multi Delete (QMD).
	6523037	11.2.0.1.BP07, 11.2.0.2.2, 11.2.0.2.BP01, 11.2.0.3, 12.1.0.1	Corruption / ORA-600 [kddummy_blkchk] [6110] on update
	8437213	10.2.0.4.3, 10.2.0.5, 11.1.0.7.7, 11.2.0.1	ASSM first level bitmap block corruption
	8360192	11.1.0.7.6, 11.2.0.1	ORA-600 [kdBlkCheckError] [6110] / corruption from insert
*	8198906	10.2.0.5, 11.2.0.1	OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents
	7715244	11.1.0.7.2, 11.2.0.1	Corruption on compressed tables. Error codes 6103 / 6110

You are here

ORA-00600: internal error code, arguments:[kdBlkCheckError] 错误解析