undofile故障恢复 -电脑资料

    测试表：

    SQL> select count(*) from t1;

    COUNT(*)

    --------------------

    100958

    活动事物模拟：

    SQL> insert into t1 select * from dba_objects;

    50479 rows created.

    模拟回滚数据文件损坏：

    SQL> !

    oracle@readerlogdb-> rm -rf /database2/oradata/skyread/undotbs02.dbf

    正常无法关闭，因为需要用到undo

    SQL> shutdown immediate;

    ORA-01097: cannot shutdown while in a transaction - commit or rollback first