Home » Server Options » Replication » Remove Archivelog from Staging Server (GoldenGate 11g)
Remove Archivelog from Staging Server [message #618196] Wed, 09 July 2014 04:29 Go to next message
pokhraj_d
Messages: 117
Registered: December 2007
Senior Member
Hi All,

I have one staging server where all the archivelogs are being transferred from PROD for Goldengate.
From the downstream server GG reads and replicat the changes to the target instance.

Here the problem is the archive destination is getting full very fast and we have to manually delete the archivelog files.
Each time we have to go to ggsci prompt and to check the lowest sequence number, and then we are removing the files.

Is there is any way we can remove the files automatically based on the owest sequence number?
Re: Remove Archivelog from Staging Server [message #618447 is a reply to message #618196] Fri, 11 July 2014 15:58 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

I assume if you have RMAN archive job in production database then you should register extract in goldengate and then set RMAN below.

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY



Quote:
REGISTER EXTRACT
Use REGISTER EXTRACT to register a primary Extract group with an Oracle database to:
● Enable integrated capture mode.
● Enable Extract in classic capture mode to work with Oracle Recovery Manager to
retain the archive logs needed for recovery.
REGISTER EXTRACT is not valid for a data pump Extract.
To unregister en Extract group from the database, use the UNREGISTER EXTRACT command
(see page 52).
Syntax REGISTER EXTRACT <group name>


- Babu
Previous Topic: Is it possible to use pump process during initial load in Golden Gate?
Next Topic: Is it possible to parallelise Initial Load in Golden Gate?
Goto Forum:
  


Current Time: Mon Sep 28 03:35:46 CDT 2020