（篇幅原因，省略部分……）

Finished Control File and SPFILE Autobackup at 21-SEP-15

此时，归档日志被备份，并且没有删除。

--多出来的两个是由于进行备份时候自动会有switch log

SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO';

? COUNT(*)

----------

? ? ? ? 15

下面进行第二次实验。

RMAN> backup database plus archivelog;

Starting backup at 21-SEP-15

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=100 RECID=12 STAMP=890690423

input archived log thread=1 sequence=101 RECID=13 STAMP=890712061

input archived log thread=1 sequence=102 RECID=14 STAMP=890727732

input archived log thread=1 sequence=103 RECID=15 STAMP=890776815

input archived log thread=1 sequence=104 RECID=16 STAMP=890776833

input archived log thread=1 sequence=105 RECID=17 STAMP=890805616

input archived log thread=1 sequence=106 RECID=18 STAMP=890814181

input archived log thread=1 sequence=107 RECID=19 STAMP=890820201

input archived log thread=1 sequence=108 RECID=20 STAMP=890859629

input archived log thread=1 sequence=109 RECID=21 STAMP=890892046

input archived log thread=1 sequence=110 RECID=22 STAMP=890900632

input archived log thread=1 sequence=111 RECID=23 STAMP=890906655

input archived log thread=1 sequence=112 RECID=24 STAMP=890942416

input archived log thread=1 sequence=113 RECID=25 STAMP=890990204

input archived log thread=1 sequence=114 RECID=26 STAMP=890990263

input archived log thread=1 sequence=115 RECID=27 STAMP=890990391

channel ORA_DISK_1: starting piece 1 at 21-SEP-15

channel ORA_DISK_1: finished piece 1 at 21-SEP-15

piece handle=/u01/app/oracle/fast_recovery_area/XXXXDB/backupset/2015_09_21/o1_mf_annnn_TAG20150921T091951_bzypsqj3_.bkp tag=TAG20150921T091951?

（篇幅原因，有省略……）

Finished Control File and SPFILE Autobackup at 21-SEP-15

第二次备份，之前备份过的日志还出现在自动备份的列表中。但是，在第二次备份的时候，已经备份过两次（deletion policy）的日志并没有自动删除。

SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO';

? COUNT(*)

----------

? ? ? ? 17

归档日志还在fast recovery area中。

[oracle@Databaseintrawebpro fast_recovery_area]$ du -h

19M? ? ./XXXXDB/autobackup/2015_09_21

9.4M? ? ./XXXXDB/autobackup/2015_09_17

29M? ? ./XXXXDB/autobackup

151M? ? ./XXXXDB/onlinelog

6.0G? ? ./XXXXDB/backupset/2015_09_21

108K? ? ./XXXXDB/backupset/2015_09_17

6.0G? ? ./XXXXDB/backupset

125M? ? ./XXXXDB/archivelog/2015_09_19

27M? ? ./XXXXDB/archivelog/2015_09_21

4.0K? ? ./XXXXDB/archivelog/2015_09_15

127M? ? ./XXXXDB/archivelog/2015_09_18

121M? ? ./XXXXDB/archivelog/2015_09_20

4.0K? ? ./XXXXDB/archivelog/2015_09_16

32M? ? ./XXXXDB/archivelog/2015_09_17

431M? ? ./XXXXDB/archivelog

9.4M? ? ./XXXXDB/controlfile

6.6G? ? ./XXXXDB

6.6G? ? .

此时，归档日志和备份次数，在v$archived_log中可以方便的找出来。

SQL> alter system switch logfile;

System altered

SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO';

? COUNT(*)

----------

? ? ? ? 18

--注意这些已经备份过两次的recid编号

SQL> select recid, sequence#, archived, deleted, backup_count from v$archived_log where backup_count>1;

? ? RECID? SEQUENCE# ARCHIVED DELETED BACKUP_COUNT

---------- ---------- -------- ------- ------------

? ? ? ? 12? ? ? ? 100 YES? ? ? NO? ? ? ? ? ? ? ? 2

? ? ? ? 13? ? ? ? 101 YES? ? ? NO? ? ? ? ? ? ? ? 2

? ? ? ? 14? ? ? ? 102 YES? ? ? NO? ? ? ? ? ? ? ? 2