㈠ 作用 束缚 Redo 的运用量、然后降低恢复时辰 ㈡ 原理 创建数据文件的镜像仿制、随后用增量备份集更新镜像仿制 即：把 1 级增量备份集并入已存在的镜像仿制中 ㈢ 检验 ① 脚本 RMAN> run {
2> http://www.haokk123.info recover copy of database with tag 'ICIU1';
3> backup
4> incremental level 1 tag 'ICIU1'
5> for recover of copy with tag 'ICIU1'
6> database plus archivelog delete input;
7> } 其间、for recover of copy with tag、这告诉 RMAN、所创建的增量备份集将用于镜像仿制 ② 注释 该脚本可以每天工作、每一天工作： Ⅰ recover copy 指令用前一天的 1 级增量备份更新每个数据文件的镜像仿制 如果找不到镜像仿制去更新或许 1 级增量备份去运用 recover copy 指令只是简略地宣告一条消息、但不报错 Ⅱ backup 指令创建一个 1 级增量备份集、可是、 如果一个 0 级镜像仿制不存在、那么、首要、backup 指令会先创建一个 0 级镜像 因此、在任何时候、你有可用于恢复的： ⑴ 最多 48 小时的镜像仿制 ⑵ 最多 24 小时的 1 级增量备份集 ⑶ 在线和归档日志去支撑完全恢复或许依据时辰点的恢复 运用这个战略、去做一次完全恢复、你将不会运用逾越 24 小时的归档日志 recover copy 指令会运用全部 1 级增量备份集到带有'ICIU1'标签的镜像仿制上 注重、2 条指令里的 tag 是有必要的 ③ 第一次工作【创建 0 级镜像仿制】 第一次工作 ICIU 脚本： ● recover copy 找不到可更新的镜像仿制、所以、RMAN 回来了"no copy of datafile 1 found to recover" ● backup 指令意识到这里没有 0 级镜像仿制(参看回来消息"no parent backup or copy of datafile 1 found") 因此、RMAN 会为每个数据文件创建一份 0 级镜像仿制 RMAN> run{
2> recover copy of database with tag 'ICIU007';
3> backup
4> incremental level 1 tag 'ICIU007'
5> for recover of copy with tag 'ICIU007'
6> database plus archivelog delete input;
7> }
Starting recover at 06-APR-13
using channel ORA_DISK_1
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
Finished recover at 06-APR-13
......
......
此处省掉 N 个字
......
Starting backup at 06-APR-13
using channel ORA_DISK_1
no parent backup or copy of datafile 1 found
no parent backup or copy of datafile 3 found
no parent backup or copy of datafile 2 found
no parent backup or copy of datafile 4 found
channel ORA_DISK_1: starting datafile copy
input datafile fno=00001 name=/u01/app/oracle/oradata/oracle10/system01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_system_8p06t0nt_.dbf tag=ICIU007 recid=3 stamp=812062572
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:46
channel ORA_DISK_1: starting datafile copy
input datafile fno=00003 name=/u01/app/oracle/oradata/oracle10/sysaux01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_sysaux_8p06vgsb_.dbf tag=ICIU007 recid=4 stamp=812062601
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:27
channel ORA_DISK_1: starting datafile copy
input datafile fno=00002 name=/u01/app/oracle/oradata/oracle10/undotbs01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_undotbs1_8p06wb6c_.dbf tag=ICIU007 recid=5 stamp=812062604
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile fno=00004 name=/u01/app/oracle/oradata/oracle10/users01.dbf
output filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_users_8p06wffr_.dbf tag=ICIU007 recid=6 stamp=812062605
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
......
......
④ 第2次工作【创建 1 级增量备份集】 第2次工作 ICIU 脚本： ● backup 指令创建 1 级增量备份 ● recover copy 指令仍然没有起作用、因为、虽然第一次工作时现已创建了 0 级镜像仿制 但、仍然没有 1 级增量备份 可是、"no copy of datafile 1 found to recover"这消息提示多少有些误导人了 RMAN> run{
2> recover copy of database with tag 'ICIU007';
3> backup
4> incremental level 1 tag 'ICIU007'
5> for recover of copy with tag 'ICIU007'
6> database plus archivelog delete input;
7> }
Starting recover at 07-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
Finished recover at 07-APR-13
Starting backup at 07-APR-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=11 recid=9 stamp=812149977
channel ORA_DISK_1: starting piece 1 at 07-APR-13
channel ORA_DISK_1: finished piece 1 at 07-APR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/o1_mf_annnn_ICIU007_8p2w6tv2_.bkp tag=ICIU007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/archivelog/2013_04_07/o1_mf_1_11_8p2w6sbt_.arc recid=9 stamp=812149977
Finished backup at 07-APR-13
Starting backup at 07-APR-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/oracle10/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/oracle10/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/oracle10/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/oracle10/users01.dbf
channel ORA_DISK_1: starting piece 1 at 07-APR-13
channel ORA_DISK_1: finished piece 1 at 07-APR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/o1_mf_nnnd1_ICIU007_8p2w6y6y_.bkp tag=ICIU007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
......
...... ⑤ 第三次工作 第三次工作 ICIU 脚本： ● recover copy 指令运用前一天创建的增量 1 集备份集到数据文件镜像仿制 ● backup 指令创建一个新的 1 级增量备份集 RMAN> run{
2> recover copy of database with tag 'ICIU007';
3> backup
4> incremental level 1 tag 'ICIU007'
5> for recover of copy with tag 'ICIU007'
6> database plus archivelog delete input;
7> }
Starting recover at 08-APR-13
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=139 devtype=DISK
channel ORA_DISK_1: starting incremental datafile backupset restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy fno=00001 name=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_system_8p06t0nt_.dbf
recovering datafile copy fno=00002 name=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_undotbs1_8p06wb6c_.dbf
recovering datafile copy fno=00003 name=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_sysaux_8p06vgsb_.dbf
recovering datafile copy fno=00004 name=/u01/app/oracle/flash_recovery_area/ORACLE10G/datafile/o1_mf_users_8p06wffr_.dbf
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/o1_mf_nnnd1_ICIU007_8p2w6y6y_.bkp
channel ORA_DISK_1: restored backup piece 1
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_07/o1_mf_nnnd1_ICIU007_8p2w6y6y_.bkp tag=ICIU007
channel ORA_DISK_1: restore complete, elapsed time: 00:00:03
Finished recover at 08-APR-13
Starting backup at 08-APR-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=13 recid=11 stamp=812239310
channel ORA_DISK_1: starting piece 1 at 08-APR-13
channel ORA_DISK_1: finished piece 1 at 08-APR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_annnn_ICIU007_8p5mgj9t_.bkp tag=ICIU007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
channel ORA_DISK_1: deleting archive log(s)
archive log filename=/u01/app/oracle/flash_recovery_area/ORACLE10G/archivelog/2013_04_08/o1_mf_1_13_8p5mggh0_.arc recid=11 stamp=812239310
Finished backup at 08-APR-13
Starting backup at 08-APR-13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/oracle10/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/oracle10/sysaux01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/oracle10/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/oracle10/users01.dbf
channel ORA_DISK_1: starting piece 1 at 08-APR-13
channel ORA_DISK_1: finished piece 1 at 08-APR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_nnnd1_ICIU007_8p5mgofk_.bkp tag=ICIU007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
channel ORA_DISK_1: starting incremental level 1 datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
including current SPFILE in backupset
channel ORA_DISK_1: starting piece 1 at 08-APR-13
channel ORA_DISK_1: finished piece 1 at 08-APR-13
piece handle=/u01/app/oracle/flash_recovery_area/ORACLE10G/backupset/2013_04_08/o1_mf_ncsn1_ICIU007_8p5mgskg_.bkp tag=ICIU007 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-APR-13
.....
..... http://www.fpzhangsha.com
