ORA-00600 [kdBlkCheckError] error code [6126] - kdbchk: avsp bad with OLTP Partial Compression UNDO and Row Store Compress
(Doc ID 2533998.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterInformation in this document applies to any platform.
Symptoms
There have been cases of ORA-00600: [kdBlkCheckError] error code [6126] - kdbchk: avsp bad if DB_BLOCK_CHECKING is enabled during queries.
There is no corruption after validating the datafile using RMAN or DBVerify.
The trace file of the ORA-00600: [kdBlkCheckError] contains the following details about the Redo Record which caused the corruption :
kdbchk: avsp bad (-19)
CON_ID:0 TYP:0 CLS:1 AFN:13 DBA:0x0342e063 OBJ:42746 SCN:0x000009d3f67ed882 SEQ:0 OP:11.28 ENC:0 RBL:0 FLG:0x0000
KDO Op code: CMP2 row dependencies Disabled
xtype: CR flags: 0x00000000 bdba: 0x0342e063 hdba: 0xbd80ca4a
itli: 3 ispac: 0 maxfr: 4858
---OLTP Compression REDO---
ccnt: 0
col: -1
pitli: 3
flag: 0
rcnt: 0
scnt: 0
---OLTP Partial Compression UNDO---
space saved: 1466 orig symbol cnt: 103
Affected Symbols cnt: 0 symbols:
Affected Rows cnt: 3
end_of_block_dump
Block Checking: DBA = 54714467, Block Type = KTB-managed data block
data header at 0xe091e2154
kdbchk: avsp bad (-19)
rechecking block failed with error code 6126
-- There is corruption on block image on memory after applying the UNDO
Disk Block image:
buffer tsn: 6 rdba: 0x0342e063 (13/188515)
checking disk block passed
-- There is no corruption on disk as disk block passed without error code.
Changes
Database is running with Oracle 12.2
The object table has "ROW STORE COMPRESS ADVANCED"
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |