My Oracle Support Banner

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 SEPTEMBER 05, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 and later
Information 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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.