ora-01578: oracle 数据块损坏,Oracle ORA-01578坏块解决方法

本帖最后由 paulyi 于 2014-1-19 13:15 编辑

一.   出问题时的情景

我在自己测试数据库上给大表 tb_table导完数据后，建立索引时，出现以下错误

ORA-01578: ORACLE data block corrupted (file # 7, block # 28969)

ORA-01110: data file 7: 'D:\ORACLE\ORADATA\PAUL\GAME_LARGE.DBF'

查看alert.log日志时有以下错误

Corrupt block relative dba: 0x01c07129 (file 7, block 28969)

Bad check value found during buffer read

Data in bad block -

type: 6 format: 2 rdba: 0x01c07129

last change scn: 0x0000.00035361 seq: 0x1 flg: 0x04

consistency value in tail: 0x53610601

check value in block header: 0x302a, computed block checksum: 0x8

spare1: 0x0, spare2: 0x0, spare3: 0x0

二. 解决方法

1.执行以下语句看哪个段坏了

select segment_type,owner||'.'||segment_name

from dba_extents

where 7 = file_id and 28969 between block_id and block_id+blocks -1

segment_type ow