2 Replies Latest reply: Aug 30, 2013 8:33 AM by Mackbell-Oracle RSS

    start goldengate extract with SCN number

    927790

      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

          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
            Mackbell-Oracle

            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.