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