RMAN异机恢复（不同系统）

环境：源环境：系统LINUX-32 Oracle:10.2.0.4目标环境：系统LINUX-64 ORACLE:10.2.0.4准备工作：COPY controlfile,spfile备份集。全库备份集。Archivelog备份集。一：restore SPFILE使用RMAN进入其他instance，才可以恢复出spfileRMAN> 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 immediateSQL> 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 controlNAME TYPE VALUE------------------------------------ ----------- ------------------------------control_file_record_keep_time integer 7control_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; --修改控制文件的路劲}

RAC下丢失inactive logfile的恢复Oracle杀掉会话或process相关资讯 RMAN

RMAN故障一例（归档的备份，从不（今 20:42）
RMAN的FORMATA格式说明（03月10日）
Oracle 11g RMAN复制数据库的测试（01月19日）

RMAN数据库迁移（05月22日）
使用RMAN复制恢复开发库环境（02月17日）
Oracle 11g RMAN跨平台传输表空间（01月19日）

本文评论查看全部评论（0）