This discussion is archived
2 Replies Latest reply: Aug 30, 2013 6:33 AM by mb_ogg RSS

start goldengate extract with SCN number

927790 Newbie
Currently Being Moderated

Hi All,

 

GG version: 11.2.1.0.4

Oracle DB: 11.2.0.3

Source OS: Solaris

Target OS: Linux

 

Is there any way to start Extract process with SCN number.

 

Thanks in advance.

Regards

Mvk

  • 1. Re: start goldengate extract with SCN number
    927790 Newbie
    Currently Being Moderated

    Hi,

     

    Thank you mb_ogg for the response.

    As per one of our requirement we need to start extract with SCN number.

    Is there any way to identify SCN number is in which archive log sequence or even in some cases which trail file if trail file is already generated?

     

    Thank you very much in advance

     

    Regards

    Mvk

  • 2. Re: start goldengate extract with SCN number
    mb_ogg Journeyer
    Currently Being Moderated

    Hi Mvk, I removed my original response because it was way off, sorry about that.  I see now that you were clearly talking about SCN yet I was talking about RBA, which is not the same.

    Back to your question, I don't however know of a way to start a a specific SCN, only RBA's or you can start at certain times in the log.

Legend

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