RMAN> run{
set until scn 3065439;
set newname for datafile 1 to 'D:\oracle\oradata\orcl\system01.dbf'; --源端为:+DATA/ORCL/DATAFILE/system.258.1032447273,WINDOWS上是文件系统,需要进行转换,其他文件同样
set newname for datafile 2 to 'D:\oracle\oradata\orcl\tsp_test01.dbf';
set newname for datafile 3 to 'D:\oracle\oradata\orcl\sysaux01.dbf';
set newname for datafile 4 to 'D:\oracle\oradata\orcl\undotbs101.dbf';
set newname for datafile 5 to 'D:\oracle\oradata\orcl\example01.dbf';
set newname for datafile 6 to 'D:\oracle\oradata\orcl\users01.dbf';
ALTER DATABASE RENAME FILE '+DATA/ORCL/ONLINELOG/group_1.262.1035645739' to 'D:\oracle\oradata\orcl\redo01a.log'; --改变联机日志文件位置
ALTER DATABASE RENAME FILE '+FRA/ORCL/ONLINELOG/group_1.257.1035645739' to ''D:\oracle\oradata\orcl\redo01b.log';
ALTER DATABASE RENAME FILE '+DATA/ORCL/ONLINELOG/group_2.263.1035645739' to 'D:\oracle\oradata\orcl\redo02a.log';
ALTER DATABASE RENAME FILE '+FRA/ORCL/ONLINELOG/group_2.258.1035645739' to 'D:\oracle\oradata\orcl\redo02b.log';
ALTER DATABASE RENAME FILE '+DATA/ORCL/ONLINELOG/group_3.264.1035645739' to 'D:\oracle\oradata\orcl\redo03a.log';
ALTER DATABASE RENAME FILE '+FRA/ORCL/ONLINELOG/group_3.261.1035645739' to 'D:\oracle\oradata\orcl\redo03b.log';
restore database; --还原数据库
switch datafile all; --切换目录位置
recover database; --恢复数据库
}
13.使用RESETLOGS打开数据库
rman>alter database open resetlogs;