Email: service@parnassusdata.com 7 x 24 online support!
ORA-00600: 内部エラー・コード, 引数: [kdBlkCheckError]
プロのOracle Databaseの復旧サービスを提供
携帯番号： +86 13764045638 メール：service@parnassusdata.com
ORA-00600: 内部エラー・コード, 引数: [kdBlkCheckError]
kdBlkCheckErrorはKernel Data Block Check Errorである。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 あるいはメモリーにエラがある。
ORA-00600[kdBlkCheckError]エラに関するは以下の通り：
| 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 |