A tape-based RMAN backup for a 12c (12.1.0.2) database reports a warning related to archive log deletion policy.
RMAN-08591: WARNING: invalid archived log deletion policy
This database was a physical standby in the past and got converted to a primary. After checking the deletion policy, I updated the setting as follows:
RMAN> show ARCHIVELOG DELETION POLICY ;
RMAN configuration parameters for database with db_unique_name db1 are:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO 'SBT_TAPE';
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY clear;
old RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY BACKED UP 1 TIMES TO 'SBT_TAPE';
RMAN configuration parameters are successfully reset to default value
starting full resync of recovery catalog
full resync complete
RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
I also executed 'resync catalog' after the change. When I ran backup after taking care of above change, backup completed successfully without any warning related to archivelog deletion policy. A day later RMAN backup log started throwing same warning message again. And when I verified deletion policy, it was changed back to the previous setting automatically. I tried to remove all dataguard related parameters as per Metalink doc 733794.1
How can I overcome this issue?
Thanks,
mlrrr