About the Oracle Rman Archive removal policy

Rman> Show All;

CONFIGURE ARCHIVELOG deletion POLICY to NONE;

The archive deletion policy in oracle10g 11g is not configured by default;

So what happens when you delete an archive log that you haven't applied to:

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 throws alarms; Warning archive logs are not deleted, archive logs need to be used as standby or stream capture process

About this configuration policy in Rman:

CONFIGURE ARCHIVELOG deletion POLICY to applied on STANDBY

The archive is not deleted automatically. Instead, the confirmation archive has been applied by the data GUARD and the streaming environment. The purpose of this feature is to avoid the archive logs required to remove other features.

If you configure the archive deletion policy:

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

To attempt to delete an archive log:
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 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




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

[[email protected] ~]$ 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 and 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.

About the Oracle Rman Archive removal policy