My Oracle Support Banner

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 7.3.0.0 to 11.2.0.4 [Release 7.3.0 to 11.2]
Information in this document applies to any platform.

Symptoms

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":

 

  Page 570736 is marked corrupt
  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).

 


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.