My Oracle Support Banner

Golden Gate Configuration, How To Delete Archive Logs From Downstream Database (Doc ID 2011174.1)

Last updated on NOVEMBER 02, 2018

Applies to:

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

Goal

GG version - 12.1.0.2.0
Downstream database version - 12.1.0.2.0


Settings for archive destination in source database:

log_archive_dest_6 string SERVICE="dmdstage", ASYNC NORE
  GISTER REOPEN=300 DB_UNIQUE_NA
  ME="dmdstage", VALID_FOR=(ONLI
  NE_LOGFILES,PRIMARY_ROLE)


Have a problem with the archive logs, which are received on the downstreams database. They are currently not being deleted automatically and this has to be done manually on some intervals. Oracle does not see them and cannot be managed from RMAN.

Is there any solution out there, which will help to create some kind of housekeeping job for these archive logs. May be to register them somehow with the downstreams database and therefore to be managed by backup jobs or something else.
 

Solution

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
Goal
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.