1.关闭数据库并删除数据文件
SQL> shutdown immediate
[oracle@asm demo1]$ rm -f app3_01.dbf
2.启动数据库到mount状态
SQL> startup mount
3.连接数据库
C:\Documents and Settings\una>rman target sys/sysdba@demo1 nocatalog
4.恢复数据库
RMAN> run {
2> set newname for datafile 7 to '/u01/app/oracle/oradata/app3_01.dbf';
3> restore database;
4> switch datafile all;
5> recover database;
6> alter database open;
7> }