[root@oraclea ~]# su - oracle
[oracle@oraclea ~]$ bplist -C oracle-db1 -s // -e // -k oracle_oracle-db1_0_17_arch -t -R -b -l /
-rw-rw---- oracle asmadmin Mar : /cntrl_4852_1_970455842
-rw-rw---- oracle asmadmin Mar : /al_4851_1_970455815
-rw-rw---- oracle asmadmin Mar : /al_4850_1_970455815
-rw-rw---- oracle asmadmin Mar : /cntrl_4826_1_970418455
-rw-rw---- oracle asmadmin Mar : /al_4824_1_970418378
-rw-rw---- oracle asmadmin Mar : /al_4825_1_970418378
-rw-rw---- oracle asmadmin Mar : /cntrl_4821_1_970403640
-rw-rw---- oracle asmadmin Mar : /al_4820_1_970403613
-rw-rw---- oracle asmadmin Mar : /al_4819_1_970403612
-rw-rw---- oracle asmadmin Mar : /cntrl_4818_1_970369482
-rw-rw---- oracle asmadmin Mar : /al_4817_1_970369415
-rw-rw---- oracle asmadmin Mar : /al_4816_1_970369415
二、.首先自己新建pfile文件或直接从原数据库服务器拷贝参数文件并修改相关路劲和参数,
三、
rman target /
startup nomount;
run{
allocate channel ch00 type 'SBT_TAPE';
send 'nb_ora_serv=nbumaster01';
send 'nb_ora_client=oracle-db1';
restore controlfile from 'cntrl_4852_1_970455842';
release channel ch00;
}
四、
alter database mount;
run{
allocate channel ch00 type 'SBT_TAPE';
allocate channel ch01 type 'SBT_TAPE';
send 'nb_ora_serv=nbumaster01';
send 'nb_ora_client=oracle-db1';
set newname for datafile 1 to '+DATA2/RACDB/DATAFILE/system.260.935591737';
set newname for datafile 2 to '+DATA2/RACDB/DATAFILE/sysaux.267.935591737';
set newname for datafile 3 to '+DATA2/RACDB/DATAFILE/undotbs1.263.935591737';
set newname for datafile 4 to '+DATA2/RACDB/DATAFILE/users.266.935591737';
set newname for datafile 5 to '+DATA2/RACDB/DATAFILE/undotbs2.262.935591889';
set newname for datafile 6 to '+DATA2/RACDB/DATAFILE/siebeldata.264.935672143';
set newname for datafile 7 to '+DATA2/RACDB/DATAFILE/siebelindex.259.935672375';
set newname for datafile 8 to '+DATA2/RACDB/DATAFILE/prod_mds.258.946840155';
set newname for datafile 9 to '+DATA2/RACDB/DATAFILE/prod_biplatform.257.946840155';
set newname for datafile 10 to '+DATA2/RACDB/DATAFILE/dev_mds.288.953377671';
set newname for datafile 11 to '+DATA2/RACDB/DATAFILE/dev_biplatform.290.953377671';
set newname for tempfile 1 to '+DATA2/RACDB/tempfile/temp.270.935591821';
set newname for tempfile 2 to '+DATA2/RACDB/tempfile/prod_ias_temp.256.946840157';
set newname for tempfile 3 to '+DATA2/RACDB/tempfile/dev_ias_temp.289.953377671';
restore database until time "to_date('2018/03/11 03:00:00','yyyy/mm/dd hh24:mi:ss')";
switch datafile all;
switch tempfile all;
release channel ch00;
release channel ch01;
}
http://www.cnblogs.com/guipeng/p/7141026.html