Email: [email protected] 7 x 24 online support!
ORA-600 [kdblkcheckerror]
If you cannot recover the data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.
Parnassusdata Software Database Recovery Team
Service Hotline: +86 13764045638 E-mail: [email protected]
Format: ORA-600 [kdblkcheckerror] [a] [b] [c] [d] [e]
VERSIONS:
versions X.X to X.X
DESCRIPTION:
--what condition caused the error to be reported ARGUMENTS:
Arg [a] --described here Arg [b] --described here
.
.
FUNCTIONALITY:
--NAME description of source code raising the OERI
IMPACT:
--List possible impact - for example :
INSTANCE FAILURE PROCESS FAILURE NO IMPACT
MEMORY CORRUPTION
NON CORRUPTIVE - No underlying data corruption. POSSIBLE PHYSICAL CORRUPTION
|
NB |
Bug |
Fixed |
Description |
|
|
12.1.0.2, 12.2.0.0 |
Diagnostic enhancement for ORA-600 [kdBlkCheckError] .. [18007] errors |
|
|
|
11.2.0.4, 12.2.0.0 |
Bad redo / ORA-600 [kdBlkCheckError] .. [6135] for opcode 19.1 redo |
|
|
|
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 |
|
|
|
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 |
|
|
|
11.2.0.4, 12.2.0.0 |
Corrupt block with check code 6101, 6110 or 6255 on compressed table with DML workload |
|
|
|
12.1.0.2 |
Drop column with DEFAULT value and NOT NULL definition ends up with dropped column data hitting disk leading to corruption |
|
|
|
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 |
|
|
|
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 |
|
|
|
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 |
|
|
|
11.2.0.4, 12.1.0.1 |
CREATE TABLE fails with ORA-600 [kddummy_blkchk] with large datafile |
|
|
* |
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 |
|
|
|
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 |
|
|
* |
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 |
|
|
|
11.2.0.3, 12.1.0.1 |
ORA-600 [kdBlkCheckError] .. [6251] / block corruption during parallel DML |
|
|
+ |
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 |
|
|
* |
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 |
|
|
|
11.2.0.4, 12.1.0.1 |
Create materialized view on views based on CON$ fails with ORA-600 [kdBlkCheckError] |
|
|
* |
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 |
|
|
|
11.2.0.2, 12.1.0.1 |
ORA-600 [ktsk_dba_to_hwm-1] / corruption during SHRINK of HWM |
|
|
+ |
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 |
|
|
|
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) |
|
|
* |
11.2.0.3, 12.1.0.1 |
Corrupt Undo. ORA-600 [2015] during rollback in undo block for COMPRESS table with SUPPLEMENTAL LOGGING |
|
|
|
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). |
|
|
|
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 |
|
|
|
10.2.0.4.3, 10.2.0.5, 11.1.0.7.7, 11.2.0.1 |
ASSM first level bitmap block corruption |
|
|
|
11.1.0.7.6, 11.2.0.1 |
ORA-600 [kdBlkCheckError] [6110] / corruption from insert |
|
|
* |
10.2.0.5, 11.2.0.1 |
OERI [kddummy_blkchk] / OERI [5467] for an aborted transaction of allocating extents |
|
|
|
11.1.0.7.2, 11.2.0.1 |
Corruption on compressed tables. Error codes 6103 / 6110 |