ORA-1578 Fractured block found in SYS_IOT_TOP_8807
(Doc ID 560499.1)
Last updated on NOVEMBER 15, 2019
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterOracle Database Cloud Schema 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
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Alert.log shows:
Corrupted block found:
Fractured block found during buffer read
Reread of rdba: 0x00c0b91e (file 3, block 47390) found same corrupted data
ORA-1578 encountered when generating server alert SMG-3503
Query on dba_extents shows that affected segment is:
SYS_IOT_TOP_8807
analyze index SYS.SYS_IOT_TOP_8807 validate structure
ORA-01578: ORACLE data block corrupted (file # 3, block # 47390)
ORA-01110: data file 3: 'K:\ORACLE\FNCE\DBS\FNCE_SYSAUX01.DBF'
select table_name FROM dba_indexes WHERE index_name = 'SYS_IOT_TOP_8807';
TABLE_NAME
------------------------------
AQ$_ALERT_QT_H
TABLE_NAME
------------------------------
AQ$_ALERT_QT_H
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 |