select name from v$datafile;
--select 'alter database rename file '''||name||''' to '''|| replace(name,'+URPDBDG','/opt/app/oracle/oradata/URPDB')||''';' from v$datafile;
3 、将备份资料档案拷贝到测试机
rman>catalog start with '/data/urpdb/'; 执行一下，就是将这个目录下的资料档案的备份档案写入了 catalog 。
4 、 restore 资料库
select file#,name from v$datafile ； --- 看看控制档中资料档案存放的位置，这里是 “ +URPDBDG/..." ，替换为目标资料库档存放的位置。
set linesize 300
column name format a200
set pagesize 100
select 'set newname for datafile '||file#||' to '''||replace(name,'+URPDBDG','/opt/app/oracle/oradata/urpdb')||''';' newname from v$datafile -- 如果一个目标目录不够，可以用多个目标目录
union all
select 'restore datafile '||file#||';' newname from v$datafile;
select *
from dba_data_files
where tablespace_name in
('TSP_URP', 'TSP_URP_INDEX', 'TSP_JC', 'TSP_JC_INDEX', 'TSP_GXSJ',
'TSP_GXSJ_INDE', 'TSP_OWB', 'TSP_YJSSJCK', 'USERS', 'SYSTEM',
'SYSAUX', 'UNDOTBS1','UNDOTBS2', 'UNDOTBS3', 'UNDOTBS4');
rman>
run
{
allocate channel ch01 type disk;
allocate channel ch02 type disk;
set until time "to_date('2012-02-23 10:00:00','yyyy-mm-dd hh24:mi:ss')";
set newname for datafile 1 to '/opt/app/oracle/oradata/URPDB/system01.dbf';
set newname for datafile 2 to '/opt/app/oracle/oradata/URPDB/undotbs1.dbf';
set newname for datafile 3 to '/opt/app/oracle/oradata/URPDB/sysaux.dbf';
set newname for datafile 4 to '/opt/app/oracle/oradata/URPDB/users.dbf';
set newname for datafile 6 to '/opt/app/oracle/oradata/URPDB/undotbs2.dbf';
set newname for datafile 9 to '/opt/app/oracle/oradata/URPDB/tsp_urp.dbf';
set newname for datafile 10 to '/opt/app/oracle/oradata/URPDB/tsp_urp_index.dbf';
set newname for datafile 14 to '/opt/app/oracle/oradata/URPDB/tsp_gxsj.dbf';
set newname for datafile 16 to '/opt/app/oracle/oradata/URPDB/tsp_urp.dbf_1.ora';
set newname for datafile 18 to '/opt/app/oracle/oradata/URPDB/tsp_owb.ora';
set newname for datafile 19 to '/opt/app/oracle/oradata/URPDB/tsp_jc.dbf';
set newname for datafile 20 to '/opt/app/oracle/oradata/URPDB/tsp_jc_index.dbf';
set newname for datafile 26 to '/opt/app/oracle/oradata/URPDB/tsp_yjssjck.dbf';
set newname for datafile 29 to '/opt/app/oracle/oradata/URPDB/undotbs03.dbf';
set newname for datafile 30 to '/opt/app/oracle/oradata/URPDB/undotbs04.dbf';
restore datafile 1;
restore datafile 2;
restore datafile 3;
restore datafile 4;
restore datafile 6;
restore datafile 9;
restore datafile 10;
restore datafile 14;
restore datafile 16;
restore datafile 18;
restore datafile 19;
restore datafile 20;
restore datafile 26;
restore datafile 29;
restore datafile 30;
switch datafile all;
release channel ch01;
release channel ch02;
}
5 、修改日志档和暂存档案的路径为目标资料库的路径（可与 restore 同时进行）
select member from v$logfile;
select name from v$tempfile;
select 'alter database rename file '''||member||''' to '''|| replace(member,'+URPDBDG','/opt/app/oracle/oradata/URPDB')||''';' from v$logfile;
alter database rename file '+YWKDG/ywk/onlinelog/group15_1.log' to '/opt/app/oracle/oradata2/YWKDG/group15_1.log';
。。。。。
select 'alter database rename file '''||name||''' to '''|| replace(name,'+URPDBDG','/opt/app/oracle/oradata2/urpdb/')||''';' from v$tempfile;
alter database rename file '+YWKDG/ywk/tempfile/tsp_zc_temp02.dbf' to '/opt/app/oracle/oradata2/YWKDG/tsp_zc_temp02.dbf';
6 、将归档档拷到目标资料库伺服器，
rman>catalog start with '/data/urpdb/'; 执行一下，就是