Tuesday, March 13, 2018

Goldengate Trail files not deleting using PURGEOLDEXTRACTS OGG12.2

Trail files not deleting automatically for all extracts specified as expected

DB version : 12.1.0.2.0
GG Version : 12.2.0.1.1


oradev01:NOTSET:/goldengate/home $ GG

Oracle GoldenGate Command Interpreter for Oracle
Version 12.2.0.1.1 OGGCORE_12.2.0.1.0_PLATFORMS_151211.1401_FBO
Linux, x64, 64bit (optimized), Oracle 12c on Dec 12 2015 02:56:48
Operating system character set identified as UTF-8.

Copyright (C) 1995, 2015, Oracle and/or its affiliates. All rights reserved.



GGSCI (oradev01) 1> info all

Program     Status      Group       Lag at Chkpt  Time Since Chkpt

MANAGER     RUNNING
EXTRACT     RUNNING     EDEV1D    00:00:05      00:00:05
EXTRACT     RUNNING     EDEV3D    00:00:05      00:00:09
EXTRACT     RUNNING     EDEV4D    00:00:04      00:00:08
EXTRACT     RUNNING     EDEV2D    00:00:02      00:00:02
EXTRACT     RUNNING     EDEV5D      00:00:10      00:00:04
EXTRACT     RUNNING     PDEV1D    00:00:00      00:00:05
EXTRACT     RUNNING     PDEV3D    00:00:00      00:00:00
EXTRACT     RUNNING     PDEV4D    00:00:00      00:00:03
EXTRACT     RUNNING     PDEV2D    00:00:04      00:00:08
EXTRACT     RUNNING     PDEV5D      00:00:00      00:00:09

GGSCI (oradev01) 2> view params mgr

PORT 7809
AUTOSTART ER *
AUTORESTART ER *,RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
--dblogin useridalias ggadmin
ACCESSRULE, PROG *, IPADDR 10.49.66.99, ALLOW
--node4 below
ACCESSRULE, PROG *, IPADDR 10.49.66.120, ALLOW
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/dev03/st*, USECHECKPOINTS, MINKEEPFILES 100
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/dev04/st*, USECHECKPOINTS, MINKEEPFILES 20
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/dev01/st*, USECHECKPOINTS, MINKEEPFILES 20
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/dev05/st*,   USECHECKPOINTS, MINKEEPFILES 20
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/dev02/st*, USECHECKPOINTS, MINKEEPFILES 20



GGSCI (oradev01) 1> SEND MANAGER GETPURGEOLDEXTRACTS

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules
Fileset                              MinHours MaxHours MinFiles MaxFiles UseCP
/goldengate/home/dirdat/Source/dev03/s       0        0       20        0   Y
OK
Extract Trails
Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCommit
/goldengate/home/dirdat/Source/dev02/st       80
/goldengate/home/dirdat/Source/dev01/st    4165
/goldengate/home/dirdat/Source/dev04/st     7275
/goldengate/home/dirdat/Source/dev03/st   180746
/goldengate/home/dirdat/Source/dev05/st      599


SYNTAX:

SEND MANAGER
[CHILDSTATUS [DEBUG]]
[GETPORTINFO [DETAIL]
[GETPURGEOLDEXTRACTS]

From the above output we see only DEV03 database which is FIRST line in mgr param file

Now, Lets try to Refresh manager using below command and see if it changes……….

GGSCI (oradev01) 7> refresh mgr

Sending REFRESH request to MANAGER ...
Mgr Params Updated

NOTE:   DO NOT Rely on above refresh mgr command as it has only LIMITED purpose and Functionality. so better STOP and START manager but careful this will bring down EXT and REPLICATS running associated with this Manager.


GGSCI (oradev01) 9> SEND MANAGER GETPURGEOLDEXTRACTS

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules
Fileset                                                 MinHours MaxHours MinFiles MaxFiles UseCP
/goldengate/home/dirdat/Source/d        0            0          20          0           Y
OK
Extract Trails
Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCommit
/goldengate/home/dirdat/Source/dev02/st       80
/goldengate/home/dirdat/Source/dev01/st    4167
/goldengate/home/dirdat/Source/dev04/st     7282
/goldengate/home/dirdat/Source/dev03/st   180854
/goldengate/home/dirdat/Source/dev05/st      602

No Changes happened………….From the above output we can see that though I have specified multiple lines in the manager param file for deleting trail files using PURGEOLDEXTARCTS using checkpoints it still takes ONLY the first line in the manager param file and this behavior is concluded as a BUG # 22912874 in 12.2 and the fix is in 12.3 version.

According to the (Doc ID 2149579.1) the Work around is to use the Parent directory instead of multiple directories 

Workaround :


GGSCI (oradev01) 10> EDIT params mgr

GGSCI (oradev01) 11> view params mgr

PORT 7809
AUTOSTART ER *
AUTORESTART ER *,RETRIES 3, WAITMINUTES 5, RESETMINUTES 60
--dblogin useridalias ggadmin
ACCESSRULE, PROG *, IPADDR 10.49.66.99, ALLOW
--node4 below
ACCESSRULE, PROG *, IPADDR 10.49.66.120, ALLOW
PURGEOLDEXTRACTS /goldengate/home/dirdat/Source/*, USECHECKPOINTS, MINKEEPFILES 50

GGSCI (oradev01) 12> refresh mgr

Sending REFRESH request to MANAGER ...
Mgr Params Updated

GGSCI (oradev01) 13> SEND MANAGER GETPURGEOLDEXTRACTS

Sending GETPURGEOLDEXTRACTS request to MANAGER ...

PurgeOldExtracts Rules
Fileset                                                 MinHours MaxHours MinFiles MaxFiles UseCP
/goldengate/home/dirdat/Source/*        0            0          50          0           Y
OK
Extract Trails
Filename                        Oldest_Chkpt_Seqno  IsTable  IsVamTwoPhaseCommit
/goldengate/home/dirdat/Source/dev02/st       80
/goldengate/home/dirdat/Source/dev01/st    4167
/goldengate/home/dirdat/Source/dev04/st     7282
/goldengate/home/dirdat/Source/dev03/st   180854
/goldengate/home/dirdat/Source/dev05/st      602

WAIT for around 5 to 10 mins and it will Work as expected for all the directories ...........


GoldenGate Manager (MGR) Not Cleaning Up Trail Files When PURGEOLDEXTRACTS Defined Twice Or More (Doc ID 2149579.1)

1 comments:

Post a Comment

Auto Scroll Stop Scroll