关于Oracle RMAN 归档删除策略

RMAN> show all;CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;在Oracle10g 11g 中归档删除策略缺省是没有配置的；那么这时去删除未应用过的的归档日志会是怎么一种情况：RMAN> delete archivelog all;released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=60 device type=DISK
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=/u01/app/ora11/flash_recovery_area/1_2019_822927217.dbf thread=1 sequence=2019
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processarchived log file name=/u01/app/ora11/flash_recovery_area/1_2023_822927217.dbf thread=1 sequence=2023
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture processOracle 抛出报警；warning 归档日志没有删除，归档日志需要用作standby 或者 stream 捕获进程使用关于rman中这个配置策略：CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY不是自动删除归档。而是删除的时候确认归档已经被DATA GUARD、流环境所应用。这个功能的目的是避免删除其他功能所需要的归档日志。如果配置归档删除策略：CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO "/u01/app/oracle/product/11.2.0/db_home/dbs/snapcf_oradb1.f"; # default尝试删除归档日志：
RMAN> delete archivelog all;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=27 instance=oradb1 device type=DISK
List of Archived Log Copies for database with db_unique_name ORADB
=====================================================================Key Thrd Seq S Low Time
------- ---- ------- - --------------------
2526 2 350 A 22-NOV-2014 02:01:04
Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143
2527 2 351 A 23-NOV-2014 13:01:27
Name: +FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173
2531 2 352 A 24-NOV-2014 10:29:04
Name: +FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011Do you really want to delete the above objects （enter YES or NO）？ yes
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_350.600.864470143 RECID=2526 STAMP=864470171
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_24/thread_2_seq_351.620.864470173 RECID=2527 STAMP=864470193
deleted archived log
archived log file name=+FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011 RECID=2531 STAMP=864634090
Deleted 3 objectsRMAN-08591: WARNING: invalid archived log deletion policy[oracle@vmrac1 ~]$ oerr rman 8591
8591, 3, "WARNING: invalid archived log deletion policy"
// *Cause: An invalid ARCHIVELOG DELETION POLICY was supplied. The archived
// log deletion policy was APPLIED but there was no mandatory
// archived log destinations.
// *Action: One of the following:
// 1） Change archived log deletion policy using CONFIGURE command
// 2） Make one or more of standby destination as MANDATORY.--------------------------------------推荐阅读 --------------------------------------RMAN 配置归档日志删除策略 http://www.linuxidc.com/Linux/2013-11/92670.htmOracle基础教程之通过RMAN复制数据库 http://www.linuxidc.com/Linux/2013-07/87072.htmRMAN备份策略制定参考内容 http://www.linuxidc.com/Linux/2013-03/81695.htmRMAN备份学习笔记 http://www.linuxidc.com/Linux/2013-03/81892.htmOracle数据库备份加密 RMAN加密 http://www.linuxidc.com/Linux/2013-03/80729.htm--------------------------------------分割线 --------------------------------------更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址