Fractured blocks found during crash or instance recovery when using EMC Symmetrix storage
(Doc ID 758055.1)
Last updated on FEBRUARY 26, 2019
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 to 18.104.22.168 [Release 7.0 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
***Checked for relevance on 07-Dec-2016***
This note applies both to single instance and RAC.
In an Oracle and EMC Symmetrix storage environment, in some very extreme cases, if a node crashes due to a hard error, or there is a hardware error during a write, a surviving instance (in the case of RAC) or the same instance (in the case of single instance) may encounter Fractured Block errors upon crash/instance recovery attempts as follows:
Corrupt block relative dba: 0x03457f5b (file 13, block 360283)
Fractured block found during crash/instance recovery
Data in bad block:
type: 6 format: 2 rdba: 0x03457f5b
last change scn: 0x0009.ec82ba18 seq: 0x1 flg: 0x02
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0xdb070601
check value in block header: 0x0
block checksum disabled
Subsequent attempts to reuse the affected blocks by any instance results in the ORA-1578 block corrupted error as:
ORA-1578: ORACLE data block corrupted (file # 13, block # 360283)
If a hardware failure is involved, the OS on the failed instance/node might show (on console or system log) IO errors leading to the failure similar to:
<date-time> <nodename> kernel: end_request: I/O error, dev sdar, sector 45153
<date-time> <nodename> kernel: end_request: I/O error, dev sdar, sector 45161
<date-time> <nodename> kernel: SCSI error : <1 0 0 133> return code = 0x20000
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