DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Tuesday, April 4, 2017

RMAN-08591: WARNING: invalid archived log deletion policy

Please follow the below steps to fix the issue and to remove  the applied archive logs in primary.



STEPS DONE :

------------------

 

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON STANDBY; - IN BOTH PRIMARY AND STANDBY

 

ADDED IN RMAN ARCHIVE SCRIPT LIKE BELOW:

----------------------------------------------------------------------

 

backup archivelog all delete input;

 

 

After the backup it is deleting the archive log files blindly without checking in standby.

 

ERROR:

----------

 

 RMAN-08591: WARNING: invalid archived log deletion policy




 


Please do the below in standby site:
 ---------------------------------------------------


 [oracle@database13]$ DGMGRL


 DGMGRL for Linux: Version 12.1.0.2.0 - 64bit Production

Copyright (c) 2000, 2013, Oracle. All rights reserved.

Welcome to DGMGRL, type "help" for information.


 DGMGRL> connect /
 Connected as SYSDG.

 

DGMGRL> show database verbose data_dgs

Database - data_dgs

 

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


Then it should work fine.

 

No comments: