ORA-1578 Misplaced blocks against datafiles stored in NFS filers
(Doc ID 1525108.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 7.3.0 to 11.2]
Information in this document applies to any platform.
ORA-1578 due to misplaced blocks. Database Files are stored in NFS filers. A misplaced block means that a block content was written in a different location (different file or different block) overwriting the original block. The corruption is reported in the alert log and by dbverify with message "Bad header found":
Corrupt block relative dba: 0x0b48b570 (file 45, block 570736)
Bad header found during dbv:
Data in bad block:
type: 6 format: 2 rdba: 0x07078aed (28/494317)
last change scn: 0x0003.c2d39f61 seq: 0x2 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x9f610602
check value in block header: 0x5363
computed block checksum: 0x0
The block is healthy (computed block checksum is 0x0) but the content belongs to a different block. In this example rdba: 0x0b48b570 (rfile#=45, block#=570736) was overwritten with the content of rdba: 0x07078aed (rfile#=28 block#=494317).
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