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
SOLUTION:
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;