欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

RMAN异机恢复(不同系统)

程序员文章站 2022-04-09 13:12:58
...

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; --修改控制文件的路劲

}

RMAN异机恢复(不同系统)