源DB: 192.168.100.8
目标DB: 192.168.100.2
SID: UDB
RMAN异机恢复步骤:
【源DB】:
(1)备份: 利用RMAN备份控制文件,全库和归档日志;
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
crosscheck backup;
crosscheck archivelog all;
sql 'alter system archive log current';
backup full database format '/backup/rman/dbf/full__%d_%s_%p_%u.bak';
sql 'alter system archive log current';
backup current controlfile format '/backup/rman/control/control_%s_%p_%t';
crosscheck backup;
delete noprompt expired backup;
delete obsolete;
configure retention policy TO REDUNDANCY 4;
release channel d4;
release channel d3;
release channel d2;
release channel d1;
}
run{
allocate channel d1 type disk;
allocate channel d2 type disk;
sql 'alter system archive log current';
backup archivelog all format '/backup/rman/archivelog/archive_%t_%s' delete all input;
crosscheck archivelog all;
release channel d1;
release channel d2;
}
(2)检查: 检查备份的控制文件,数据文件和归档日志是否有效，时间上保持一致;
ls -lt full.* control.* archive.* 查看时间
(3)拷贝: 将备份集拷贝到目标DB目录
scp * oracle@192.168.100.2:/orashare/rman/
【目标DB】:
(1)创建目录: 根据源DB的目录结构,建立相关目录.
$ORACLE_BASE/admin/$ORACLE_SID/{adump,dpdump,pfile}
$ORACLE_BASE/oradata
$ORACLE_BASE/diag
RMAN备份的恢复目录
(2)注册备份集: 将拷贝过来的RMAN备份集注册到本机的控制文件里面去
RMAN> catalog backuppiece ''/backup/demo_40.dbf'' 注册备份片;
RMAN> catalog start with ''/bak'' 注册特定目录的所有备份文件;
(3)创建密码文件: 认证的密码文件
cd $ORACLE_HOME/bin
orapwd file=$ORACLE_HOME/dbs/orapworcl password=oracle entries=8
cd $ORACLE_HOME/dbs
(4)恢复参数文件: 设置ORACLE_SID环境变量,设置DBID,在nomount状态下,恢复参数文件
startup nomount;
export ORACLE_SID=udb
set dbid=123456789
restore spfile to pfile '/u01/app/oracle/product/11.2.0/dbhome_1/dbs/initdave2.ora' from '/u01/backup/dave_spfile_16m6qtde_1_1_20110309';
(5)恢复控制文件: 设置ORACLE_SID环境变量,设置DBID,在nomount状态下,恢复控制文件
startup nomount;
export ORACLE_SID=udb
set dbid=123456789
restore controlfile from '/u01/backup/ctl_file_15m6qtdc_1_1_20110309';
(6)恢复数据文件: 设置ORACLE_SID环境变量,设置DBID,在mount 状态下,恢复数据文件;
alter database mount;
restore database;
recover database;
(7)打开数据库: 打开数据库修改实例名和DBID
(8)检查数据是否恢复正常