Test by bo yuan on 2013.05.17
<1> 0级备份
dbid: 2111914201
上图：启用0级差异增量备份
RMAN>
run{
allocate channel ch1 type disk;
backup incremental level 0 database
format'/home/oracle/backup/db_%d_%U'
tag=db_inc_0;
release channel ch1;
}
新增一笔数据
<2> 1级差异增量备份,如下图
run{
allocate channel ch1 type disk;
backup incremental level 1 database
format'/home/oracle/backup/db1_%d_%U'
tag=db_inc_1;
release channel ch1;
}
再新增一笔资料
<3> 再做一次1级差异增量备份
<4>. 补备份一下pfile和ctrol file
Run{
SQL "create pfile=''/home/oracle/backup/pfile.ora'' from spfile";
backup as copy current controlfile format '/home/oracle/backup/control01.ctl';
}
====下面开始做恢复测试：===========
1. 把备份集文件从10.253.32.106复制到192.168.20.211上
2. 恢复
备库 (同库名，不同目录结构）
-------------------------------------------------------------------------------------
1.
rman>
打开复制过来的pfile，并更改里面的路径。并创建里面指定的目录
2.
startup force nomount pfile='/home/orar3p/backup/pfile.ora';
3.
restore controlfile from '/home/orar3p/backup/control01.ctl';
4.
alter database mount;
catalog start with '/home/orar3p/backup';
list backup;
5.
run{
restore database;
Switch datafile all;
recover database until SCN 2598979;
}
6.
sql>
create spfile from pfile='/home/orar3p/backup/pfile.ora';
7. 检验恢复的结果:
-----------------The End -------------------------
