ORACLE undo datafile误删后的恢复

目的：本实验用来学习oracle undo datafile误删除后的恢复技术。

实验环境：rhel6.3+oracle 11g。

实验步骤：

1、查询undo datafile的位置并删除

      SQL> select name from v$datafile;
       NAME
       --------------------------------------------------------------------------------
       /lvm/app/oracle/oradata/updb/system01.dbf
      /lvm/app/oracle/oradata/updb/sysaux01.dbf
      /lvm/app/oracle/oradata/updb/users01.dbf
     /lvm/app/oracle/oradata/updb/example01.dbf
     /lvm/app/oracle/oradata/updb/undotbs01.dbf

     SQL> ho rm /lvm/app/oracle/oradata/updb/undotbs01.dbf

2、关闭数据库并尝试重新启动

     SQL> shutdown transactional;
    shutdown transactional;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
startup
ORACLE instance started.


Total System Global Area  238034944 bytes
Fixed Size    2227136 bytes
Variable Size  180356160 bytes
Database Buffers   50331648 bytes
Redo Buffers    5120000 bytes
Database mounted.
ORA-01157: cannot identify/lock data file 6 - see DBWR trace file
ORA-01110: data file 6: '/lvm/app/oracle/oradata/updb/undotbs01.dbf'