My Oracle Support Banner

False Corruption ORA-1498 for Compressed tables (Doc ID 2789589.1)

Last updated on JULY 06, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 19.10.0.0.0 [Release 12.2 to 19]
Information in this document applies to any platform.

Symptoms

Analyze table validate structure of compressed tables fails with ORA-1498, but DBV or RMAN check logical validate doesn't detect any corruption.
ORA-1498 tracefile shows block is corrupted, but doesn't say how Oracle judged it is corrupted.
Blockdump is written in readable format, not binary dump, and contains for each block

skipping corrupted block at rdba: xxxxxxxxxx
9ir2 HEAP BLOCK FORMAT



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
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.