1 Reply Latest reply: Mar 30, 2013 10:10 AM by Osama_Mustafa RSS

    Query on Change Data Capture

    user10547935
      Hi,


      A small clarification on oracle CDC(change data capture),if the CDC is down for 6 hours due to some issues how do I capture all the source transactions into CDC views during this window?

      Just doing a purge and restarting the CDC Subscriber would solve the above scenario?

      Thanks
        • 1. Re: Query on Change Data Capture
          Osama_Mustafa
          Oracle CDC is all about capturing changes in DB tables and the changes are stored in special Oracle tables. There are two modes of CDC operation: asynchronous (based on Java) or synchronous (based on DB triggers, more performance overhead).

          Check
          http://docs.oracle.com/cd/B13789_01/server.101/b10736/cdc.htm#i1025409
          http://docs.oracle.com/cd/E14571_01/integrate.1111/e12643/data_capture.htm