Shulou(Shulou.com)06/01 Report--

The database reports the following error during archive recovery:

RMAN-08591: WARNING: invalid archived log deletion policy

View the ORA error explanation:

[oracle@021Y-SH-BKAP] $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.

This indicates that this is because the slave database is a log archive obtained from the master database, not the carrier of the archive, so the policy department accords with the role of the library and enters the rman tool:

[oracle@021Y-SH-BKAP] $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

Modify RMAN configuration

RMAN > configure ARCHIVELOG DELETION POLICY clear

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.