About the Oracle Rman Archive removal policy

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.