How to purge golden gate Trail Files
As archive log,clean,reco,Fra clean up Dba should also think about purging golden gate trail files to purge them.
Current usage:
oracle@Shamstech:/home/oracle>df -hP
Filesystem Size Used Avail Use% Mounted on
/data/GG_data 954G 729G 225G 77% /u03
step1:
oracle@Shamstech:>ggsci
Oracle GoldenGate Command Interpreter for Oracle
Operating system character set identified as UTF-8.
Copyright (C) 1995, 2019, Oracle and/or its affiliates. All rights reserved.
GGSCI (oracle@Shamstech) 1> info all
Program Status Group Lag at Chkpt Time Since Chkpt
MANAGER RUNNING
EXTRACT RUNNING EXTRCT1 00:00:06 00:00:08
EXTRACT RUNNING EXTRCT2 00:00:00 00:00:00
Note: Here there is no lag in GG and GG is in sync
step2:Change the MINKEEPHOURS from 96 yo 48
oracle@Shamstech:>cat mgr.prm
PORT 7809
-- Purge old extract entries.
PURGEOLDEXTRACTS /data/GG_data/dirdat/EXTRCT1/in*, USECHECKPOINTS, MINKEEPHOURS 96
oracle@Shamstech:>ggsci
Oracle GoldenGate Command Interpreter for Oracle
step3:
GGSCI (oracle@Shamstech) 1> refresh mgr
Sending REFRESH request to MANAGER ...
Mgr Params Updated
step4:
GGSCI (oracle@Shamstech) 2> send manager getpurgeoldextracts
Sending GETPURGEOLDEXTRACTS request to MANAGER ...
PurgeOldExtracts Rules
Fileset MinHours MinFiles UseCP
/u02/ggdata/dirdat/EXTRCT1/i 48 1 Y
OK
Extract Trails
Filename Oldest_Chkpt_Seqno
/u02/ggdata/dirdat/EXTRCT1/in 143864
step5:
GGSCI (oracle@Shamstech) 3> send manager purgeoldextracts
step6: Change the MINKEEPHOURS from 48 to 96
oracle@Shamstech:>cat mgr.prm
PORT 7809
-- Purge old extract entries.
PURGEOLDEXTRACTS /data/GG_data/dirdat/EXTRCT1/in*, USECHECKPOINTS, MINKEEPHOURS 96
After usage:
oracle@Shamstech:>df -hP
Filesystem Size Used Avail Use% Mounted on
/data/GG_data 954G 96G 859G 10% /u03
Note: The space cleared from /u03 file system after 10mins......
oracle@Shamstech:>ggsci
GGSCI (oracle@Shamstech) 1> refresh MGR
Sending REFRESH request to MANAGER ...
Mgr Params Updated
Enjoy the work and do like me if you like this article!!!
