UNDO 表空间数据块损坏 ORA-01578 & ORA-01110
前两天搭了某测试数据库,最近被告之删除数据时报错。
alert .log
--------------------------------------
Thu Apr 14 01:58:49 2011
Errors in file D:/oracle/admin/MRC/bdump/mrcSMON.TRC:
ORA-01595: error freeing extent (2) of rollback segment (1))
ORA-01578: ORACLE data block corrupted (file # 2, block # 3)
ORA-01110: data file 2: 'E:/ORADATA/UNDOTBS01.DBF'
--------------------------------------
是程序员执行delete 语句时报错,工具toad 。
Oracle version :9205