226
💡 RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
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
Solution:
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;