We have a cron job set up to monitor errors in the GoldenGate ggserr.log. This monrining, in a target database, we recieved:
< 2013-06-17 02:58:17 ERROR OGG-01172 Oracle GoldenGate Delivery for Oracle, rvasip.prm: Discard file (./dirrpt/RVASIP.dsc) exceeded max bytes (1000000).
< 2013-06-17 02:58:17 ERROR OGG-01668 Oracle GoldenGate Delivery for Oracle, rvasip.prm: PROCESS ABENDING.
It appeared that Replicat process abended due to Discard file exceeded max bytes.
Discard file is used by GoldenGate to log records it cannot proccess. The maximum size of the discard file can be specified by MAXBYTES or MEGABYSTS options,
the defaults are 1000000 or 1MB. If the specified size is exceeded, the process will abend.
Further troubleshooting showed the reason for the discard file filled up was due to a tablespace filled up in this case. In the RVASIP.dsc files we can found:
OCI Error ORA-01653: unable to extend table PPOWNER.VZ_JNR_FEED_TRX_LOG by 8192 in tablespace PPOWNER_DATA_1 (status = 1653). INSERT INTO "PPOWNER"."VZ_JNR_FEED_TRX_LOG" ("ID","JOURNAL_ID"
,"TRX_EXT_ID","BILLED","DB_MODIFICATION_DATE","DB_CREATION_DATE","SUB_TRX_ID","TRX_ID","CHG_ATTR","ACCESS_TYPE") VALUES (:a0,:a1,:a2,:a3,:a4,:a5,:a6,:a7,:a8,:a9)
Aborting transaction on ./dirdat/rt beginning at seqno 21275 rba 3795007
error at seqno 21275 rba 5169654
To fix the problem, I renamed RAVSIP.dsc, changed the max bytes of discard file to be 10MB in the parameter file:
discardfile ./dirrpt/RVASIP.dsc, Append,megabytes 10
Then I stopped and started the Replicat process. I have verified that those discarded dmls recorded in the discard file have been applied after Replicat process re-started. no manual intervene is ndeed.
Monday, June 17, 2013
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment