backup命令中的keepforever关键字会屏蔽rman的retentionpolicy(二)
。
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination /home/oracle/arch
Oldest online log sequence 30
Next log sequence to archive 33
Current log sequence 33
SQL> ----------------------------------------------------->此时的日志序列号是33
RMAN> backup archivelog all format '/home/oracle/arc_back_after_keep_%U' delete all input;
Starting backup at 15-DEC-14
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=21 recid=16 stamp=865127168
input archive log thread=1 sequence=22 recid=17 stamp=866409290
input archive log thread=1 sequence=23 recid=18 stamp=866410210
input archive log thread=1 sequence=24 recid=19 stamp=866410212
input archive log thread=1 sequence=25 recid=20 stamp=866410213
input archive log thread=1 sequence=26 recid=21 stamp=866410218
input archive log thread=1 sequence=27 recid=22 stamp=866410218
input archive log thread=1 sequence=28 recid=23 stamp=866410220
input archive log thread=1 sequence=29 recid=24 stamp=866410221
input archive log thread=1 sequence=30 recid=25 stamp=866410222
input archive log thread=1 sequence=31 recid=26 stamp=866410224
input archive log thread=1 sequence=32 recid=27 stamp=866410224
input archive log thread=1 sequence=33 recid=28 stamp=866410311
channel ORA_DISK_1: starting piece 1 at 15-DEC-14
channel ORA_DISK_1: finished piece 1 at 15-DEC-14
piece handle=/home/oracle/arc_back_after_keep_0upq8nq9_1_1 tag=TAG20141215T213153 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=/home/oracle/arch/1_21_864082022.dbf recid=16 stamp=865127168
archive log filename=/home/oracle/arch/1_22_864082022.dbf recid=17 stamp=866409290
archive log filename=/home/oracle/arch/1_23_864082022.dbf recid=18 stamp=866410210
archive log filename=/home/oracle/arch/1_24_864082022.dbf recid=19 stamp=866410212
archive log filename=/home/oracle/arch/1_25_864082022.dbf recid=20 stamp=866410213
archive log filename=/home/oracle/arch/1_26_864082022.dbf recid=21 stamp=866410218
archive log filename=/home/oracle/arch/1_27_864082022.dbf recid=22 stamp=866410218
archive log filename=/home/oracle/arch/1_28_864082022.dbf recid=23 stamp=866410220
archive log filename=/home/oracle/arch/1_29_864082022.dbf recid=24 stamp=866410221
archive log filename=/home/oracle/arch/1_30_864082022.dbf recid=25 stamp=866410222
archive log filename=/home/oracle/arch/1_31_864082022.dbf recid=26 stamp=866410224
archive log filename=/home/oracle/arch/1_32_864082022.dbf recid=27 stamp=866410224
archive log filename=/home/oracle/arch/1_33_864082022.dbf recid=28 stamp=866410311
Finished backup at 15-DEC-14
Starting Control File and SPFILE Autobackup at 15-DEC-14
piece handle=/home/oracle/backup/control/c-275920358-20141215-01 comment=NONE
Finished Control File and SPFILE Autobackup at 15-DEC-14
RMAN>
RMAN> list backupset;
List of Backup Sets
===================
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -----------