Oracle rman archive deletion policy, oraclerman
RMAN> show all;
Configure archivelog deletion policy to none;
By default, the archive deletion policy is not configured in oracle10g 11g;
In this case, how does one Delete archive logs that have not been applied:
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/4102023_822927217.dbf thread = 1 sequence = 2023
RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
Oracle throws an alert; warning archived logs are not deleted, and archive logs must be used as standby or stream capture processes.
About the Configuration Policy in rman:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY
The archive is not automatically deleted. Instead, confirm that the archive has been applied by data guard and the stream environment during deletion. The purpose of this function is to avoid deleting the archive logs required by other functions.
If you configure an 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
Try to delete the 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 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.6379864470173
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.6379864470173 RECID = 2527 STAMP = 864470193
Deleted archived log
Archived log file name = + FLASH/oradb/archivelog/2014_11_26/thread_2_seq_352.554.864634011 reci= 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.