Load Ingest Data
Results 1 to 2 of 2

Thread: Source Database Disaster Recovery

  1. #1
    oturley@gci.com is offline Junior Member
    Join Date
    Nov 2009
    Posts
    1
    Rep Power
    0

    Source Database Disaster Recovery

    What are the recommended steps to complete the disaster recovery process for Attunity Oracle CDC for SSSIS solution when the source oracle database was restored from the backup to an earlier point in time and now is out of sync with the target SQL Server database?

  2. #2
    Gadi.Farhat is offline Development Manager
    Join Date
    Mar 2009
    Posts
    255
    Rep Power
    11
    Hi,

    After restoring the Oracle database to an earlier point in time, it is recommended to:
    1. Reset the CDC Solution to the current time, or any time after the database restore operation was done. This can be done using the "Reset CDC" option in the Management Console.
    2. Run the Full Load Packages
    3. Now you can continue running the CDC Packages

    Regards,

    Gadi
    To Find Out more About Attunity Technology:
    Attunity
    or:
    Contact Us

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •