rman 恢复 不同目录

rman 恢复 不同目录
源端 sid=orcl
环境：linux CentOSX86_64
datafile路径：/data/oracle/oradata/orcl
oracle 版本：11.2.0.4.0 Production


目标 sid=orcl
环境:linux CentOSX86_64
datafile 路径:/data/oracle/oradata/orcl1
oracle 版本：11.2.0.4.0 Production

源端：
1.rman备份
2.把备份文件拷贝到目标端
查看数据
SQL> select * from f;
ID NAME
---------- --------------------
1 aaa
2 bbb
目标端：
1.startup nomount
2.恢复control文件
restore controlfile from '/data/rmanbak/c-1377240132-20140716-01';
3.alter database mount;
4.alter database backup controlfile to trace as '/home/oracle/control0726.trc';
5. RMAN> list backup;  看到路径不同，需要更改
  1    0  Incr 5240348    16-JUL-14 /data/oracle/oradata/orcl/system01.dbf
  3    0  Incr 5240348    16-JUL-14 /data/oracle/oradata/orcl/undotbs01.dbf
  4    0  Incr 5240348    16-JUL-14 /data/oracle/oradata/orcl/users01.dbf
  2    0  Incr 5240349    16-JUL-14 /data/oracle/oradata/orcl/sysaux01.dbf
  5    0  Incr 5240349    16-JUL-14 /data/oracle/oradata/orcl/DIYINDO.DBF
RMAN> run {
 set newname for datafile 1 to '/data/oracle/oradata/orcl1/system01.dbf';
 set newname for datafile 2 to '/data/oracle/oradata/orcl1/sysaux01.dbf';
 set newname for datafile 3 to '/data/oracle/oradata/orcl1/undotbs01.dbf';
 set newname for datafile 4 to '/data/oracle/oradata/orcl1/users01.dbf';
 set newname for datafile 5 to '/data/oracle/oradata/orcl1/DIYINDO.DBF';
 restore database;
 switch datafile all;
 }
6. trc文件重建control 文件,修改相关路径;
shutdown immediate;
startup nomount;
重建control文件脚本（从backup to trace 的文件得来）
CREATE CONTROLFILE REUSE DATABASE "ORCL" RESETLOGS  ARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 3
    MAXDATAFILES 100
    MAXINSTANCES 8
    MAXLOGHISTORY 292
LOGFILE
  GROUP 1 '/data/oracle/oradata/orcl1/redo01.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 2 '/data/oracle/oradata/orcl1/redo02.log'  SIZE 50M BLOCKSIZE 512,
  GROUP 3 '/data/oracle/oradata/orcl1/redo03.log'  SIZE 50M BLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
  '/data/oracle/oradata/orcl1/system01.dbf',
  '/data/oracle/oradata/orcl1/sysaux01.dbf',
  '/data/oracle/oradata/orcl1/undotbs01.dbf',
  '/data/oracle/oradata/orcl1/users01.dbf',
  '/data/oracle/oradata/orcl1/DIYINDO.DBF'
CHARACTER SET AL32UTF8;

RMAN> recover database;
RMAN>alter database open resetlogs;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24974673/viewspace-1980091/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24974673/viewspace-1980091/