RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

When we are taking archive log backup with delete then got an error.

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/pac/lci9t1/arch/redo_1_16470_842608348.arc thread=1 sequence=16470

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

archived log file name=/pac/lci9t1/arch/redo_1_16471_842608348.arc thread=1 sequence=16471

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process

 

SOLUATION:

Cause: The archive logs seems that it is not yet applied in the standby database.

                        Select sequence# , applied from v$archived_log;

 

Action: Check the standby database and apply the logs manually and the start the deletion process.

              I can delete the archive logs by force using the below command.

      RMAN > delete noprompt force archivelog all;

 

But I don't want to delete the archives which are not applied in standby  so i'm changing the configuration

              

RMAN> show all;

Old configuration:

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

 

Change as Below:

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

 

new RMAN configuration parameters:

 

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

 

new RMAN configuration parameters are successfully stored

 

RMAN-08591: WARNING: invalid archived log deletion policy


Now check the configuration

 

RMAN> show all;

 

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO STANDBY;

 

 

Now I am able to delete those archivelogs now.

 

 

RMAN> delete noprompt archivelog all;

 

RMAN> crosscheck archivelog all;

 

Once I deleted those logs, I changed the rman configuration by the default one.

 

 

RMAN> CONFIGURE ARCHIVELOG DELETION POLICY CLEAR;

RMAN> Show all;