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