怎么解决ORA-01578: ORACLE data block corrupted (file # 2, block # 115352)

[ii_木兮]

Errors in file d:\app\administrator\diag\rdbms\orcl\orcl\trace\client_j000_2188.trc (incident=756655):
ORA-01578: ORACLE data block corrupted (file # 2, block # 115352)
ORA-01110: data file 2: 'D:\APP\ADMINISTRATOR\ORADATA\ORCL\SYSAUX01.DBF'
ORA-26040: Data block was loaded using the NOLOGGING option

SQL> SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME
2 FROM DBA_EXTENTS
3 WHERE FILE_ID = 2 AND 115352 BETWEEN BLOCK_ID
4 AND BLOCK_ID+BLOCKS -1;

SEGMENT_TYPE
------------------
OWNER||'.'||SEGMENT_NAME
-------------------------------------------------------------------------------

TABLE PARTITION
SYS.WRH$_ACTIVE_SESSION_HISTORY

[惜分飞]

这个表，不是那么重要，可以truncate掉，或者设置跳过坏块 但是不建议顺便设置nologing