关于Oracle RMAN 归档删除策略

RMANgt; show all; CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; 在Oracle10g 11g 中 归档删除策略 缺省是没有配置的； 那么

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.

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

RMAN 配置归档日志删除策略

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密

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

本文永久更新链接地址：