ORA-1578 Fractured block found in SYS_IOT_TOP_8807

刘泽宇

现象：
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



原因：
Possible Cause: Power Outage

处理方法：

1) exec dbms_aqadm.drop_queue_table(queue_table=>'SYS.ALERT_QT',force=>TRUE);
2) rerun catalrt.sql

This solved the problem.