rman异机恢复

DBID

----------

1754589357

--源端备份

RUN {

CONFIGURE CONTROLFILE AUTOBACKUP ON;

allocate channel c1 type disk;

allocate channel c2 type disk;

BACKUP FORMAT '/u01/back/oracle_%U_%T' skip inaccessible filesperset 5 DATABASE TAG oracle_hot_db_bk;

sql 'alter system archive log current';                                        

BACKUP FORMAT '/u01/back/arch_%U_%T' skip inaccessible filesperset 5 ARCHIVELOG ALL DELETE INPUT;

backup current controlfile tag='bak_ctlfile' format='/u01/back/ctl_file_%U_%T';

backup spfile tag='spfile' format='/u01/back/oracle_spfile_%U_%T';

release channel c2;

release channel c1;

}

--目标端还原

--创建目录

mkdir /u01/back

scp -rp 192.168.56.3:/u01/back/* /u01/back/

mkdir -p /u01/app/oracle/admin/oracle/{adump,bdump,cdump,dpdump,udump,pfile}  

mkdir -p /u01/app/oracle/oradata/oracle  

mkdir -p /u01/app/oracle/flash_recover_area/ORACLE

--创建参数文件

echo 'db_name=orcl' > $ORACLE_HOME/dbs/initoracle.ora

export ORACLE_SID=oracle

rman target /

--设置dbid

set dbid 1754589357;

startup nomount;

--恢复参数文件

restore spfile from '/u01/back/oracle_spfile_0sqaupvf_1_1_20150701';

--强制重新启动到nomount状态

startup nomount force;

--恢复控制文件

restore controlfile from '/u01/back/ctl_file_0rqaupvd_1_1_20150701';

--启动到mount状态

alter database mount;

--还原数据文件

restore database;

switch datafile all;

--恢复数据文件

recover database;

--在sqlplus中对数据库进行until cancel操作

sqlplus /nolog

conn /as sysdba

recover database using backup controlfile until cancel;

--以resetlogs方式打开

alter database open resetlogs;

--正常关闭数据库，做全备

--正常开启数据库

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/24626757/viewspace-2121275/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/24626757/viewspace-2121275/