RMAN备份和delete input，CONFIGURE BACKUP OPTIMIZATION on的关系

RMAN> BACKUP  
2> FORMAT '/backup/arch_%T_%s_%p'
3> SKIP INACCESSIBLE
4> ARCHIVELOG ALL;

Starting backup at 08-JAN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=67 RECID=1 STAMP=804194038
input archived log thread=1 sequence=68 RECID=2 STAMP=804194161
input archived log thread=1 sequence=69 RECID=3 STAMP=804194208
input archived log thread=1 sequence=70 RECID=4 STAMP=804194396
channel ORA_DISK_1: starting piece 1 at 08-JAN-13
channel ORA_DISK_1: finished piece 1 at 08-JAN-13
piece handle=/backup/arch_20130108_3_1 tag=TAG20130108T191956 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-JAN-13

RMAN> BACKUP
2> FORMAT '/backup/arch_%T_%s_%p'
3> SKIP INACCESSIBLE
4> ARCHIVELOG ALL;

Starting backup at 08-JAN-13
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=67 RECID=1 STAMP=804194038
input archived log thread=1 sequence=68 RECID=2 STAMP=804194161
input archived log thread=1 sequence=69 RECID=3 STAMP=804194208
input archived log thread=1 sequence=70 RECID=4 STAMP=804194396
input archived log thread=1 sequence=71 RECID=5 STAMP=804194410
channel ORA_DISK_1: starting piece 1 at 08-JAN-13
channel ORA_DISK_1: finished piece 1 at 08-JAN-13
piece handle=/backup/arch_20130108_4_1 tag=TAG20130108T192010 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 08-JAN-13

RMAN>

从上可以看到备过的归档如果不加delete input的话，下次备份的时候会重复备份

但CONFIGURE BACKUP OPTIMIZATION on可以让下次备份归档的时候跳过已经备过的
RMAN> run{
2> BACKUP
3> FORMAT '/backup/arch_%T_%s_%p'
4> SKIP INACCESSIBLE
5> ARCHIVELOG ALL;
6> }

Starting backup at 19-JAN-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=78 recid=89 stamp=805144989
input archive log thread=1 sequence=79 recid=90 stamp=805145189
input archive log thread=1 sequence=80 recid=91 stamp=805145192
input archive log thread=1 sequence=81 recid=92 stamp=805145207
channel ORA_DISK_1: starting piece 1 at 19-JAN-13
channel ORA_DISK_1: finished piece 1 at 19-JAN-13
piece handle=/backup/arch_20130119_118_1 tag=TAG20130119T192647 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 19-JAN-13

RMAN> run{
2> BACKUP
3> FORMAT '/backup/arch_%T_%s_%p'
4> SKIP INACCESSIBLE
5> ARCHIVELOG ALL;
6> }

Starting backup at 19-JAN-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=78 recid=89 stamp=805144989
input archive log thread=1 sequence=79 recid=90 stamp=805145189
input archive log thread=1 sequence=80 recid=91 stamp=805145192
input archive log thread=1 sequence=81 recid=92 stamp=805145207
input archive log thread=1 sequence=82 recid=93 stamp=805145238
channel ORA_DISK_1: starting piece 1 at 19-JAN-13
channel ORA_DISK_1: finished piece 1 at 19-JAN-13
piece handle=/backup/arch_20130119_119_1 tag=TAG20130119T192718 comment=NONE
channel O