This discussion is archived
1 Reply Latest reply: Jun 19, 2013 9:57 AM by Nick_W RSS

Howto send SKIPTRANS to ABENDED extract?

user8685581 Newbie
Currently Being Moderated

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 Explorer
    Currently Being Moderated

    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. 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points