OGG-01172 OGG-01668 Discard file Exceeded max bytes (500000000) PROCESS ABENDING

Hi,

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

 

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.

 

 

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.

Mehmet Salih Deveci

I am Founder of IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress mehmetsalih.deveci@outlook.com.-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Leave a Reply

Your email address will not be published. Required fields are marked *