Monday, 6 July 2020

OGG-01172 Oracle GoldenGate Delivery for Oracle exceeded max bytes (50000000)

Goldengate replicat abended with   2020-03-28T22:02:39.377-0700  ERROR   OGG-01172  Oracle GoldenGate Delivery for Oracle, repusr1.prm:  Discard file (/ogg/dirrpt/repusr1.dsc) exceeded max bytes (50000000).

Cause: 
Discard file exceeded default size 50M, we need to update max bytes more than default size 50M manually in replicat to overcome this error 

Solution:
in 19c goldengate discard file size should be in between 1 - 4096 megabytes 

add parameter to replicat and restart replicat 
DISCARDFILE dirrpt/repusr1.dsc, APPEND, MEGABYTES 4096 


if we add more than 4096 MEGABYTES it will through error like "2020-03-28T22:11:10.164-0700  ERROR   OGG-10103  Oracle GoldenGate Delivery for Oracle, repusr1.prm:  (repusr1.prm) line 6: Parsing error, value "10000" is out of legal range (1 - 4096) for [megabytes]"

No comments:

Post a Comment