1 Reply Latest reply: Jun 19, 2013 11:57 AM by Nick.W-Oracle RSS

    Howto send SKIPTRANS to ABENDED extract?

    user8685581

      Hi

       

      We have an extract that ABORT when DDL is executed on DB.

       

      xabc.prm

      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.

       

      1.

      What is the SKIPTRANS for when ist does not work for ABENDED processes?

       

      2.

      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 11.2.1.0.4_02 15864821 OGGCORE_11.2.1.0.5_PLATFORMS_121214.0600

      HP/UX, IA64, 64bit (optimized), Oracle 11g on Dec 14 2012 08:34:12

       

       

      Thanks

        • 1. Re: Howto send SKIPTRANS to ABENDED extract?
          Nick.W-Oracle

          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.