注意:备份过两次的日志,没有出现在RMAN自动备份的列表中。这里我们定义到了删除策略的一个行为:当满足删除条件的时候,归档日志是不会进入备份集合列表的。
归档日志信息:
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 YES 2
13 101 YES YES 2
14 102 YES YES 2
15 103 YES YES 2
16 104 YES YES 2
17 105 YES YES 2
18 106 YES YES 2
19 107 YES YES 2
20 108 YES YES 2
21 109 YES YES 2
22 110 YES YES 2
23 111 YES YES 2
24 112 YES YES 2
25 113 YES YES 2
26 114 YES NO 2
27 115 YES NO 2
28 116 YES NO 2
17 rows selected
注意:一部分归档日志被删除,但是并没有所有上次备份过两次的日志都删除掉了,比如recid=26的日志。此时,备份fast recovery area空间情况发生了变化。
[oracle@Databaseintrawebpro fast_recovery_area]$ du -h
29M ./XXXXDB/autobackup/2015_09_21
4.0K ./XXXXDB/autobackup/2015_09_17
29M ./XXXXDB/autobackup
151M ./XXXXDB/onlinelog
5.5G ./XXXXDB/backupset/2015_09_21
4.0K ./XXXXDB/backupset/2015_09_17
5.5G ./XXXXDB/backupset
4.0K ./XXXXDB/archivelog/2015_09_19
2.5M ./XXXXDB/archivelog/2015_09_21
4.0K ./XXXXDB/archivelog/2015_09_15
4.0K ./XXXXDB/archivelog/2015_09_18
4.0K ./XXXXDB/archivelog/2015_09_20
4.0K ./XXXXDB/archivelog/2015_09_16
4.0K ./XXXXDB/archivelog/2015_09_17
2.6M ./XXXXDB/archivelog
9.4M ./XXXXDB/controlfile
5.7G ./XXXXDB
5.7G .
在alert log中,我们看到了Oracle自动删除的动作。
Mon Sep 21 09:24:27 2015
Expanded controlfile section 11 from 28 to 56 records
Requested to grow by 28 records; added 1 blocks of records
Archived Log entry 29 added for thread 1 sequence 117 ID 0x774e158c dest 1:
Mon Sep 21 10:05:28 2015
ALTER SYSTEM ARCHIVE LOG
Mon Sep 21 10:05:28 2015
Thread 1 advanced to log sequence 119 (LGWR switch)
Current log# 2 seq# 119 mem# 0: /u01/app/oracle/oradata/XXXXDB/onlinelog/o1_mf_2_bxzzjj5w_.log
Current log# 2 seq# 119 mem# 1: /u01/app/oracle/fast_recovery_area/XXXXDB/onlinelog/o1_mf_2_bxzzjj80_.log
Archived Log entry 30 added for thread 1 sequence 118 ID 0x774e158c dest 1:
Mon Sep 21 10:05:47 2015
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/backupset/2015_09_17/o1_mf_annnn_TAG20150917T195557_bzoblfck_.bkp
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_17/o1_mf_1_100_bzokvqj0_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/autobackup/2015_09_17/o1_mf_s_890682958_bzoblglw_.bkp
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_18/o1_mf_1_101_bzp6zx31_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_18/o1_mf_1_102_bzpp9nln_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_18/o1_mf_1_103_bzr67h1h_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_18/o1_mf_1_104_bzr6812s_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_19/o1_mf_1_105_bzs2cj5y_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_19/o1_mf_1_106_bzsbq54p_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_19/o1_mf_1_107_bzsjm99v_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_19/o1_mf_1_108_bztq3f2v_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_20/o1_mf_1_109_bzvprgf1_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_20/o1_mf_1_110_bzvz4rj7_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_20/o1_mf_1_111_bzw50zmb_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_20/o1_mf_1_112_bzx7yj9g_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/archivelog/2015_09_21/o1_mf_1_113_bzypmw8c_.arc
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/backupset/2015_09_21/o1_mf_annnn_TAG20150921T091644_bzypmwty_.bkp
Mon Sep 21 10:05:58 2015
Deleted Oracle managed file /u01/app/oracle/fast_recovery_area/XXXXDB/backupset/2015_09_21/o1_mf_nnndf_TAG20150921T091647_bzypn055_.bkp
Mon Sep 21 10:06:15 2015
ALTER SYSTEM ARCHIVE LOG
Mon Sep 21 10:06:15 2015
Thread 1 advanced to log sequence 120 (LGWR switch)
Current log# 3 seq# 120 mem# 0: /u01/app/oracle/oradata/XXXXDB/onlinelog/o1_mf_3_bxzzjl0z_.log
Current log# 3 seq# 120 mem# 1: /u01/app/oracle/fast_recovery_area/XXXXDB/onlinelog/o1_mf_3_bxzzjl35_.log
Archived Log entry 31 added for thread 1 sequence 119 ID 0x774e158c dest 1: