RMAN-08591: WARNING: invalid archived log deletion policy

Warning Description:
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete

RMAN-08591: WARNING: invalid archived log deletion policy

Solution Description
Solution 1. For Standby database
Connect to Data Guard - dgmgrl

DGMGRL>  connect /
Connected as SYSDG.
DGMGRL> show configuration

Configuration - dg_prodx01

  Protection Mode: MaxPerformance
  Members:
  prodx01   - Primary database
    prodx01dr - Physical standby database

Check the value for the binding for the DR database.

DGMGRL> show database verbose prodx01dr

Database - prodx01dr

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      (unknown)
  Apply Lag:          (unknown)
  Average Apply Rate: (unknown)
  Active Apply Rate:  (unknown)
  Maximum Apply Rate: (unknown)
  Real Time Query:    OFF
  Instance(s):
    prodx01

  Properties:
    DGConnectIdentifier             = 'prodx01dr'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
Binding                         = 'optional'
    MaxFailure                      = '0'
    MaxConnections                  = '1'
    ReopenSecs                      = '300'

Change the value of the binding to mandatory. There are 2 options-you can use dgmgrl or sqlplus to reset it.

DGMGRL>edit database prodx01dr set property Binding='mandatory';
Property "binding" updated

DGMGRL> show database verbose prodx01dr

Database - prodx01dr

  Role:               PHYSICAL STANDBY
  Intended State:     APPLY-ON
  Transport Lag:      0 seconds (computed 4 seconds ago)
  Apply Lag:          0 seconds (computed 4 seconds ago)
  Average Apply Rate: 25.00 KByte/s
  Active Apply Rate:  86.00 KByte/s
  Maximum Apply Rate: (unknown)
  Real Time Query:    ON
  Instance(s):
    prodx01

  Properties:
    DGConnectIdentifier             = 'prodx01dr'
    ObserverConnectIdentifier       = ''
    LogXptMode                      = 'ASYNC'
    RedoRoutes                      = ''
    DelayMins                       = '0'
Binding                         = 'mandatory'

Now the warning is fixed.

Or second option to reset the value for binding
Sqlplus / as sysdba
SQL>alter system set log_archive_dest_1='location=USE_DB_RECOVERY_FILE_DEST mandatory';

System altered.


RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
Solution 2. For non-Standby Database
If you are getting the same error message(RMAN-08591) in non-standby database you can apply this solution. You might have configured wrongly the deletion policy with the database. See below.

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
RMAN-08591: WARNING: invalid archived log deletion policy

Show the archive deleteion policy. In that, I have wrongly mentioned the “applied on statndby”clause which is not relevant for the non-standby database. Because of that it is giving the error. You will have to clear/reset the archivelog deletion policy to default.

RMAN> show ARCHIVELOG DELETION POLICY ;

RMAN configuration parameters for database with db_unique_name PRODDB01 are:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;

Reset the value using configure with clear option.
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY clear;

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY;
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete

RMAN>show ARCHIVELOG DELETION POLICY;

RMAN configuration parameters for database with db_unique_name PRODDB01 are:

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google