We have an extract that ABORT when DDL is executed on DB.
DDL INCLUDE OBJNAME abc.* EVENTACTIONS (DISCARD, ABORT)
When the extract is in ABENDED state we want to skip this one DDL transaction:
send XSYRA, SKIPTRANS 22.2592190948 THREAD 2
But it does not work:
ERROR: EXTRACT XSYRA not currently running.
What is the SKIPTRANS for when ist does not work for ABENDED processes?
Why is DISCARD not skipping this record? When start the extract again it is ABENDED again.
The doc says: "The process resumes processing with the next record in the trail."
Oracle GoldenGate Command Interpreter for Oracle
Version 126.96.36.199.4_02 15864821 OGGCORE_188.8.131.52.5_PLATFORMS_121214.0600
HP/UX, IA64, 64bit (optimized), Oracle 11g on Dec 14 2012 08:34:12
SKIPTRANS is used to tell Extract to skip a long running transaction or a empty transaction that hasn't committed. It was used prior to Bounded Recovery being implemented when OGG would require old archive logs in order to restart.
To skip a DDL operation, you can use this parameter..
DDLERROR RESTARTSKIP 1
This will tell Extract to skip the next DDL operation it encounters. I haven't used it with DDL INCLUDE OBJNAME abc.* EVENTACTIONS (DISCARD, ABORT).
I'm not sure of the order of operations on this, but a short test would show if it would work.