环境:
源环境:系统linux-32 oracle:10.2.0.4
目标环境:系统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_56tddh9m_.dbf';
restore database;
switch datafile all; --修改控制文件的路劲
}
