RMAN-08137: WARNING: archived log not deleted

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

Comments

  1. zulalinho7 September 2021 at 16:53

    Hi Dinesh
    I could not find any contact address , so I am posting here.
    I assume that you commented on Mike's blog about Error: UPG-1401. I am getting same error. I am using latest autoupgrade.jar (2021 july version) .
    The upgrade process is from 19c to 21c.

    https://mikedietrichde.com/2019/04/29/the-new-autoupgrade-utility-in-oracle-19c/

    Could you please clarify the steps how did you start your database with newly created spfile while autoupgrade job is running.
    Thanks

    ReplyDelete

Post a Comment

Popular posts from this blog

ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_346"

-
Error: Errors in file /oracle/app/oracle/diag/rdbms/crrmprd/crrmprd/trace/crrmprd_j000_8759.trc: ORA-12012: error on auto execute of job "SYS"."ORA$AT_OS_OPT_SY_346" ORA-20001: Statistics Advisor: Invalid task name for the current user ORA-06512: at "SYS.DBMS_STATS", line 47214 ORA-06512: at "SYS.DBMS_STATS_ADVISOR", line 882 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 20059 ORA-06512: at "SYS.DBMS_STATS_INTERNAL", line 22201 ORA-06512: at "SYS.DBMS_STATS", line 47204 2019-05-09 00:41:46.984000 +05:30 cause:  Seed database was most likely not created right by package dbms_stats.init_package not being ran.  Dbms_stats.init_package creates statistics advisor. This procedure is executed during database creation. If something went wrong during database creation,(for example, init_package is not called for some reason),  this kind of errors may be seen in alert log when auto job tries to execute. 
Read more

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 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.
Read more