ORACLE在10点突然崩溃并经过2天恢复后,出错savepoint 'BEGINACTION' never established ORACLE在10点突然崩溃并经过2天恢复后,在做业务时报错: ORA-01086: savepoint 'BEGINACTION' never established ORA-06512: at "HLHOME.PRO_REQUIRE_SEND_DEALWITH", line 267 ORA-01578: ORACLE data block corrupted (file # 6, block # 18104) ORA-01110: data file 6: 'E:\HLDRP1\HLINDEX01.DBF' ORA-06512: at line 2请大侠帮忙,如何解决?
'E:\HLDRP1\HLINDEX01.DBF' 查一下这个坏块是什么对象,如果是Index可以rebuild index一般即可解决问题。select * from dba_extents where file_id=6 and 18104 between block_id and Block_id+blocks; 先删除该索引,而后新建该索引 就OK了!
ORACLE在10点突然崩溃并经过2天恢复后,在做业务时报错:
ORA-01086: savepoint 'BEGINACTION' never established
ORA-06512: at "HLHOME.PRO_REQUIRE_SEND_DEALWITH", line 267
ORA-01578: ORACLE data block corrupted (file # 6, block # 18104)
ORA-01110: data file 6: 'E:\HLDRP1\HLINDEX01.DBF'
ORA-06512: at line 2请大侠帮忙,如何解决?
查一下这个坏块是什么对象,如果是Index可以rebuild index一般即可解决问题。select * from dba_extents where file_id=6 and 18104 between block_id and Block_id+blocks;
先删除该索引,而后新建该索引 就OK了!