【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 或者内存存在讹误。
如果自己搞不定可以找ASKMACLEAN专业ORACLE数据库修复团队成员帮您恢复!、
与该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 |
Leave a Reply