Hi,

You can get ” OGG-01172 Discard file (/data/Goldengate/discard/REP01_discard.txt) exceeded max bytes (500000000) ” error while Replicat is running.

 

OGG-01172 Discard file Exceeded max bytes

When I check report file of Goldengate Replicat Process, I saw OGG-01172, OGG-01668 errors like following.

 

GGSCI (MehmetSalih) 27> view report REP01

........................

..................

discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 500

Source Context :
SourceModule : [er.main]
SourceID : [/scratch/angorant/view_storage/angorant_ogg_12978807_x64/oggcore/OpenSys/src/app/er/rep.c]
SourceFunction : [output_discard_info]
SourceLine : [14056]
ThreadBacktrace : [9] elements
: [/lib64/libc.so.6(__libc_start_main+0xf4) [0x31f261d9c4]]
: [/data1/Goldengate/replicat(__gxx_personality_v0+0x1da) [0x4e43ca]]

2019-05-16 13:38:04 ERROR OGG-01172 Discard file (/data/Goldengate/discard/REP01_discard.txt) exceeded max bytes (500000000).

2019-05-16 13:38:04 ERROR OGG-01668 PROCESS ABENDING.

 

OGG-01668 PROCESS ABENDING

To solve OGG-01172 error, increase discardfile size parameter in the replicat parameter file like following. Change following line from 500mb to 5000 or more MB, it will be solved.

discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 5000

 

 

GGSCI (MehmetSalih) 27> edit params REP01

discardfile /data/Goldengate/discard/REP01_discard.txt, append, megabytes 5000

 

 

 

 

 

Start Goldengate Replicat process and monitor it.

GGSCI (MehmetSalih) 28> start REP01

Sending START request to MANAGER ...
REPLICAT REP01 starting


GGSCI (MehmetSalih) 29>

GGSCI (MehmetSalih) 29> info REP01

REPLICAT   REP01      Last Started 2019-05-16 13:40   Status RUNNING
Checkpoint Lag       00:32:59 (updated 00:00:00 ago)
Log Read Checkpoint  File /data/Goldengate/dirdat/rt061069
                     2019-05-16 13:07:27.412499  RBA 19983356


GGSCI (MehmetSalih) 30> !
info REP01

REPLICAT   REP01      Last Started 2019-05-16 13:40   Status RUNNING
Checkpoint Lag       00:09:35 (updated 00:00:00 ago)
Log Read Checkpoint  File /data/Goldengate/dirdat/rt061070
                     2019-05-16 13:30:55.411576  RBA 20215450


GGSCI (MehmetSalih) 31> !
info REP01

REPLICAT   REP01      Last Started 2019-05-16 13:40   Status RUNNING
Checkpoint Lag       00:00:00 (updated 00:00:00 ago)
Log Read Checkpoint  File /data/Goldengate/dirdat/rt061070
                     2019-05-16 13:40:04.412345  RBA 38380842

OGG-01172, OGG-01668 errors has been solved.

 

 

Do you want to learn Oracle Goldengate, then read the following articles.

Oracle Goldengate Tutorials for Beginners