当前位置:Gxlcms > mysql > RMAN异机恢复(不同系统)

RMAN异机恢复(不同系统)

时间:2021-07-01 10:21:17 帮助过:29人阅读

RMAN异机恢复(不同系统),源环境:系统LINUX-32 ORACLE:10.2.0.4,目标环境:系统LINUX-64 ORACLE:10.2.0.4,准备工作:COPY co

环境:

源环境:系统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; --修改控制文件的路劲

}

linux

人气教程排行