This article is about RMAN-08137. We are going to learn how do we can solve this issue. Let’s have look at the steps to solve this issue. RMAN does not delete ArchiveLogs on Primary Database when the State of the Archive Destination to the Standby Database is set to ‘defer’. When trying to delete ArchiveLogs, this Error is raised:

 

 

 

 

Error

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

If we defer an Archive Destination to a Standby Database, the Primary Database will still consider the Standby Database as existing but temporary unavailable eg. for Maintenance. This can happen if you stop Log Transport Services from the Data Guard Broker or manually defer the State for the Archive Destination.

Cause

This is causing the archive log file system to be filled up. Appears that one of the orphan Capture processes is holding up archives.

SOLUTION:
——————
SQL> alter system set “_deferred_log_dest_is_valid” = FALSE scope=both

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

Stay tuned for More articles on Oracle RAC

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us the Invitation or Follow us:

Telegram Channel : https://t.me/helporacle

Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply