Oracle reports corrupted data blocks
Issue
- Oracle error logs report corruption:
Wed Jan 21 17:05:01 2015
Hex dump of (file 20, block 1871182) in trace file /path/file.trc
Corrupt block relative dba: 0x051c8d4e (file 20, block 1871182)
Completely zero block found during buffer read
Reading datafile '/mountpoint/db_file.dbf' for corruption at rdba: 0x051c8d4e (file 20, block 1871182)
Reread (file 20, block 1871182) found same corrupt data (no logical check)
Wed Jan 21 17:05:01 2015
Corrupt Block Found
TSN = 4, TSNAME = POOL_DATA
RFN = 20, BLK = 1871182, RDBA = 85757262
OBJN = 325000, OBJD = 325000, OBJECT = WI_EXPIRED, SUBOBJECT =
SEGMENT OWNER = SOAASYNC_SOAINFRA, SEGMENT TYPE = Index Segment
Environment
- Red Hat Enterprise Linux 5.7
- Oracle
- LVM
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.