Oracle ORA-08591 Alarms

Source: Internet
Author: User

Archive recovery when the database reported the following error:

Rman-08591:warning:invalid Archived Log Deletion policy

To view the Ora error explanation:

[[email protected] ~]$ oerr rman 85918591,  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. 

The

Indicates that this is because the repository is a log archive obtained from the main library, not an archive, so the policy department conforms to the role of the library and enters the Rman tool:

[[email protected] ~]$ rman target /recovery manager: release  11.2.0.1.0 - production on mon feb 2 13:59:10 2015copyright  (c)  1982, 2009, Oracle and/or its affiliates.  All rights  reserved.connected to target database: orcl  (dbid=1394247230) RMAN> show  All;using target database control file instead of recovery catalogrman  configuration parameters for database with db_unique_name orcl are: Configure retention policy to redundancy 1; # defaultconfigure backup  optimization off; # defaultconfigure default device type to disk ; # defaultconfigure controlfile autobackup on; Configure controlfile autobackup format for device type disk to  '/DBBK/ORACLE/BACKUP/CONTROL%F.BKP '; Configure device type disk parallelism 1 backup type to backupset ;  # defaultconfigure datafile backup copies for device type disk  to 1; # defaultconfigure archivelog backup copies for device  TYPE DISK TO 1; # defaultCONFIGURE MAXSETSIZE TO UNLIMITED;  # defaultconfigure encryption for database off; # defaultconfigure  ENCRYPTION ALGORITHM  ' AES128 ';  # defaultconfigure compression algorithm   ' BASIC '  AS OF RELEASE  ' DEFAULT '  OPTIMIZE FOR LOAD TRUE ;  # defaultCONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO  Standby; # defaultconfigure snapshot controlfile name to  '/DBBK/ORACLE/PRODUCT/11.2.0.1.0/DBS/SNAPCF_ORCL.F ';  # default 

Modifying the Rman configuration

Rman> Configure ARCHIVELOG deletion POLICY clear;

This article is from the "linuxoracle" blog, make sure to keep this source http://onlinekof2001.blog.51cto.com/3106724/1610662

Oracle ORA-08591 Alarms

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.