False Corruption ORA-1498 for Compressed tables
(Doc ID 2789589.1)
Last updated on JULY 20, 2024
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 |