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;
Comments
Tags: ARCHIVELOG DELETION POLICY, controlfile, controlfile or catalog, DBA Oracle, error identifying, error identifying file, error rman, No such file or directory, O/S-Error, O/S-Error: (OS 2) The system cannot find the file specified, Ora Error, ORA-19625, ORA-27037, ORA-27041, ORA-27041: unable to open file, Oracle Application DBA, oracle archive log error in rman, Oracle Database, Oracle DBA, oracle error, OSD-04002, OSD-04002: unable to open file, RMAN, rman archive error, rman archive log error, rman backup error, RMAN Error, rman oracle archive log error, RMAN repository, RMAN WARNING, RMAN-03002, RMAN-06059, RMAN-08137, RMAN-08137: WARNING, VR4 Error: 2: No such file or directory