RMAN DELETE INPUT和DELETE ALL INPUT的区别

1.首先检查一下归档的路径

SYS@prod2 > show parameter archive

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
archive_lag_target                   integer     0
log_archive_config                   string
log_archive_dest                     string
log_archive_dest_1                   string      location=/home/oracle/app/arch
                                                 ive
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string
log_archive_dest_19                  string
log_archive_dest_2                   string      location=/home/oracle/app/fast
                                                 _recovery_area/prod2

有两个归档路径log_archive_dest_1，log_archive_dest_2

2.使用rman列出目标库的归档日志

RMAN> list archivelog all;

397     1    48      A 25-OCT-15
        Name: /home/oracle/app/archive/1_48_892652515.dbf

398     1    49      A 26-OCT-15
        Name: /home/oracle/app/archive/1_49_892652515.dbf

399     1    50      A 26-OCT-15
        Name: /home/oracle/app/archive/1_50_892652515.dbf

400     1    51      A 27-OCT-15
        Name: /home/oracle/app/archive/1_51_892652515.dbf

401     1    52      A 27-OCT-15
        Name: /home/oracle/app/archive/1_52_892652515.dbf

402     1    53      A 28-OCT-15
        Name: /home/oracle/app/archive/1_53_892652515.dbf

403     1    53      A 28-OCT-15
        Name: /home/oracle/app/fast_recovery_area/prod2/1_53_892652515.dbf

404     1    54      A 28-OCT-15
        Name: /home/oracle/app/archive/1_54_892652515.dbf

405     1    54      A 28-OCT-15
        Name: /home/oracle/app/fast_recovery_area/prod2/1_54_892652515.dbf

406     1    55      A 28-OCT-15
        Name: /home/oracle/app/archive/1_55_892652515.dbf

407     1    55      A 28-OCT-15
        Name: /home/oracle/app/fast_recovery_area/prod2/1_55_892652515.dbf

408     1    56      A 28-OCT-15
        Name: /home/oracle/app/archive/1_56_892652515.dbf

409     1    56      A 28-OCT-15
        Name: /home/oracle/app/fast_recovery_area/prod2/1_56_892652515.dbf

410     1    57      A 28-OCT-15
        Name: /home/oracle/app/archive/1_57_892652515.dbf

411     1    57      A 28-OCT-15
        Name: /home/oracle/app/fast_recovery_area/prod2/1_57_892652515.dbf

可以看到53之前的日志只有一个归档路径，之后的有两个归档路径

3.我们使用delete input看一下结果

RMAN> backup archivelog all delete input;

Starting backup at 28-OCT-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=267 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=16 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=98 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=182 device type=DISK
channel ORA_DISK_1: starting compressed archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=3 RECID=352 STAMP=892677675
input archived log thread=1 sequence=4 RECID=353 STAMP=892678596
input archived log thread=1 sequence=5 RECID=354 STAMP=892687714
input archived log thread=1 sequence=6 RECID=355 STAMP=892708411
input archived log thread=1 sequence=7 RECID=356 STAMP=892718054
input archived log thread=1 sequence=8 RECID=357 STAMP=892718173
input archived log thread=1 sequence=9 RECID=358 STAMP=892718473
input archived