oracle 取消rman,关于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 process

archived 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 process

archived 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 process

Oracle 抛出报警；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.864634011

Do 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 objects

RMAN-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.

--------------------------------------推荐阅读 --------------------------------------

--------------------------------------分割线 --------------------------------------