RMAN是Oracle推出的官方備份還原工具。經過幾個大版本的發展，RMAN已經支持多種備份介質和恢復策略的主要工具，也是業界普遍認可
RMAN是Oracle推出的官方備份還原工具。經過幾個大版本的發展，RMAN已經支持多種備份介質和恢復策略的主要工具，也是業界普遍認可是Oracle備份還原官方策略。
Archivelog是Oracle備份還原策略的重要組成元素，不完全備份+連續的歸檔日志可以讓我們將數據庫恢復到發生故障點，實現數據的無損失恢復。但是，現實生活中archive log給沒有經驗的運維人員也帶來了不少的問題，歸檔空間占滿引起Hang住、瞬間歸檔日志過多生成引起問題等。一些前輩也在不斷強調“歸檔模式不美好”。
在RMAN工作參數中，針對archive log，是可以設置專門的刪除策略（Deletion）。在實踐領域中，已經備份過或者確保安全傳輸的歸檔日志，其實就可以刪除了，特別是在有限的Fast Recovery Area管理模式下。對于自動刪除archive log的策略，比較常見的是applied to standby和shipped to standby，也就是Data Guard場景下。
本篇介紹簡單的backed up參數使用情況，并通過一系列實驗去研究該參數影響下Oracle和RMAN的工作行為特性。
1、基本參數和實驗環境
筆者使用Oracle 11gR2進行測試，具體版本編號為11.2.0.4。
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 – Production
默認情況下，archivelog deletion policy參數為NONE。
RMAN> show all;
RMAN configuration parameters for database with db_unique_name XXXXDB are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
（篇幅原因，有省略……）
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
該參數常見的集中取值如下：
configure archivelog deletion policy to backed up 2 times to sbt;
configure archivelog deletion policy to backed up 1 times to device type disk;
configure archivelog deletion policy to applied on standby; --DG專用
configure archivelog deletion policy to shipped on standby; --DG專用
configure archivelog deletion policy clear;
研究archivelog行為最好的工具視圖是v$archived_log。很多DBA喜歡從操作系統層面刪除歸檔日志，但是這種方式是不會直接被Oracle控制文件認可，所以建議使用RMAN或者官方工具來做。
--已歸檔未刪除日志
SQL> select count(*) from v$archived_log where archived='YES' and deleted='NO';
COUNT(*)
----------
13
2、第一輪備份測試實驗
首先我們修改archivelog deletion policy參數，設置為“兩次備份后即可以刪除”。
RMAN> configure archivelog deletion policy to backed up 2 times to device type disk;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 2 TIMES TO DISK;
new RMAN configuration parameters are successfully stored
手工備份數據庫和歸檔日志，不進行刪除動作。
RMAN> backup database plus archivelog;
Starting backup at 21-SEP-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=16 device type=DISK
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
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_TAG20150921T091644_bzypmwty_.bkp tag=TAG20150921T091644
（篇幅原因，省略部分……）
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
15 103 YES NO 2
16 104 YES NO 2
17 105 YES NO 2
18 106 YES NO 2
19 107 YES NO 2
20 108 YES NO 2
21 109 YES NO 2
22 110 YES NO 2
23 111 YES NO 2
24 112 YES NO 2
25 113 YES NO 2
26 114 YES NO 2
15 rows selected
進行第三次備份。
RMAN> backup database plus archivelog;
Starting backup at 21-SEP-15
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=498 device type=DISK
skipping archived logs of thread 1 from sequence 100 to 114; already backed up
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=115 RECID=27 STAMP=890990391
input archived log thread=1 sequence=116 RECID=28 STAMP=890990481
input archived log thread=1 sequence=117 RECID=29 STAMP=890990667
input archived log thread=1 sequence=118 RECID=30 STAMP=890993128
channel ORA_DISK_1: starting piece 1 at 21-SEP-15
channel ORA_DISK_1: finished piece 1 at 21-SEP-15
piece
（篇幅原因，有省略…….）
Finished Control File and SPFILE Autobackup at 21-SEP-15
注意：備份過兩次的日志，沒有出現在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:
聲明：本網頁內容旨在傳播知識，若有侵權等問題請及時與本網聯系，我們將在第一時間刪除處理。TEL:177 7030 7066 E-MAIL:11247931@qq.com
Copyright ? 2019-2025 www.polareal.com 版權所有
違法及侵權請聯系：TEL:177 7030 7066 E-MAIL:11247931@qq.com 本站由北京市萬商天勤律師事務所王興未律師提供法律服務
