RMAN异机恢复(不同系统)(一)

2014-11-24 18:30:45 · 作者: · 浏览: 0

环境:


目标环境:系统LINUX-64 ORACLE:10.2.0.4


准备工作:COPY controlfile,spfile备份集。全库备份集。Archivelog备份集。


一:restore SPFILE


使用RMAN进入其他instance,才可以恢复出spfile


RMAN> restore spfile to '/u01/MICSPROD.spfile' from '/u01/MICSPRODBAK/2012_09_06/o1_mf_s_793317938_84kcflvf_.bkp';


根据恢复的SPFILE,用LINUX下strings命令打开,复制到vi下,把controlfile注释掉,编辑成PFILE。


SQL> startup nomount pfile='/u01/MICSPROD.pfile';


SQL> create spfile from pfile='/u01/MICSPROD.pfile';


SQL> shutdown immediate


SQL> startup nomount


二:restore controlfile


[oracle@micsgmm ~]$ rman target /


RMAN> restore controlfile from '/u01/MICSPRODBAK/2012_09_06/o1_mf_s_793317938_84kcflvf_.bkp';


SQL> alter database mount;


SQL> show parameter control


NAME TYPE VALUE


------------------------------------ ----------- ------------------------------


control_file_record_keep_time integer 7


control_files string /u01/app/oracle/oradata/MICSPR


OD/controlfile/o1_mf_85lf9xxp_


.ctl, /u01/app/oracle/flash_re


covery_area/MICSPROD/controlfi


le/o1_mf_85lf9yjz_.ctl



三:restore datafiles


由于备份集和目标路劲不同,所以要注册备份集和指定恢复后的路劲


RMAN> catalog start with '/u01/MICSPRODBAK/2012_09_06_1/o1_mf_nnnd0_LEVEL0_060912_84k09py2_.bkp'; (注册备份集)


(指定恢复后的路劲)


RUN


{ set newname for datafile 1 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_system_4s1qt2g2_.dbf';


set newname for datafile 2 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_undotbs1_4s1qt2jf_.dbf';


set newname for datafile 3 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_sysaux_4s1qt2g7_.dbf';


set newname for datafile 4 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_users_4s1qt2jn_.dbf';


set newname for datafile 5 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_emp_4swx1w4s_.dbf';


set newname for datafile 6 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_ttk_4swx1wp0_.dbf';


set newname for datafile 7 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_pre_4swx1xh0_.dbf';


set newname for datafile 8 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_enr_4swx1yk8_.dbf';


set newname for datafile 9 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_cla_4swx1zcf_.dbf';


set newname for datafile 10 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_fin_4swx212s_.dbf';


set newname for datafile 11 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_sta_4swx21vr_.dbf';


set newname for datafile 12 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_cla_4swx2305_.dbf';


set newname for datafile 13 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_ind_4swx24gn_.dbf';


set newname for datafile 14 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_cal_4swx25q9_.dbf';


set newname for datafile 15 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_xml_4swx29t3_.dbf';


set newname for datafile 16 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_ttk_4swx2bxy_.dbf';


set newname for datafile 17 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_med_4swx2d7r_.dbf';


set newname for datafile 18 to '/u01/app/oracle/oradata/MICSPROD/datafile/o1_mf_tbsp_mic_56tddh