ORA-01578 ORACLE data block corrupted (file # 29, block # 2889087)

BW数据库后台报错如下：F:oracleSBPsaptracediag dbmssbpsbp race

ORA-01578: ORACLE data block corrupted (file # 29, block # 2889087)
ORA-01110: data file 29: 'G:ORACLESBPSAPDATA2SR3_18SR3.DATA18'
ORA-26040: Data block was loaded using the NOLOGGING option

解决方法：

1、查询坏块相对应的对象

SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTS  WHERE file_id = 29 AND 2889087 BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;
显示结果：INDEX PARTITION:SAPSR3./BIC/FZCCCO010~020


2、段类型为INDEX PARTITION,记录名称和所有者,然后确定哪些分区受到影响：
SELECT partition_name FROM dba_extents WHERE file_id = 29 AND 2889087 BETWEEN block_id AND block_id + blocks - 1;
显示结果
PARTITION_NAME:/BIC/FZCCCO0100000000881

方法可以u