RMAN-08591: WARNING: invalid archived log deletion policy

advertisements

_____________________________________________________________________________________________________________________

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

_____________________________________________________________________________________________________________________

Website Stats