在Oracle中，如何在执行恢复的时候将数据文件恢复到别的路径？

主要采用命令“set newname for datafile”和“switch datafile all;”。下面给一个RMAN的例子：

run {

set until time 'Jul 01 1999 00:05:00';

allocate channel d1 type disk;

set newname for datafile '/u04/oracle/prod/sys1prod.dbf' to '/u02/oracle/prod/sys1prod.dbf';

set newname for datafile '/u04/oracle/prod/usr1prod.dbf' to '/u02/oracle/prod/usr1prod.dbf';

set newname for datafile '/u04/oracle/prod/tmp1prod.dbf' to '/u02/oracle/prod/tmp1prod.dbf';

restore controlfile to '/u02/oracle/prod/ctl1prod.ora';

replicate controlfile from '/u02/oracle/prod/ctl1prod.ora';

restore database;

sql "alter database mount";

switch datafile all;

recover database;

sql "alter database open resetlogs";

release channel d1;

}