rman完成恢复到不同路径

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> }