My Oracle Support Banner

RMAN Able To Delete Archive Logs Which Are Still Not Read By Integrated Extract (Doc ID 2137576.1)

Last updated on JULY 18, 2023

Applies to:

Oracle GoldenGate - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

 RMAN does not retain the archivelogs required by the IE process.  The archivelogs could get purged even if they are not read by the IE process. This happens when  OGG 12.1 and above is used along with deletion policy is set to NONE.

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;

In Earlier versions, OGG would not allow to delete the archivelog by giving the below warning.

RMAN-08137: WARNING: archived log not deleted, needed for standby or upstream capture process
archived log file name=/app/oracle/product/12.1.0/dbs/arch1_29_910462923.dbf thread=1 sequence=29

 

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
  
Cause
 The cause of the issue is described in the below bug
 Bug 20554364 - RMAN DELETES ARCHIVELOGS STILL NECESSARIES BY OGG EXTRACT 12.1.2.0
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.