Data Replication

  • 1.  The gap of SCN number

    Posted Wed July 28, 2021 05:34 AM
    Environment :
    Oracle Database 19c Enterprise Edition Release
    IBM InfoSphere Data Replication 11.4

    Situation :
    We get the latest SCN number to set bookmarking. I would like to know that after 4 days, will CDC resume from the point the SCN is captured? Kindly advise.

    ------------------------------
    data icons
    ------------------------------


    #DataIntegration
    #DataReplication


  • 2.  RE: The gap of SCN number

    Posted Wed July 28, 2021 06:42 AM
    Hello

    CDC will restart replicating from the bookmark, irrespective of how old it is as long as the Oracle logs are online, in this case as archived redo logs.

    The bookmark is taken from the target by default, unless an action such as setting the bookmark on the source with the dmsetbookmark command is taken to override this.

    Hope this helps

    Robert

    ------------------------------
    Robert Philo
    ------------------------------