Share via

CDC processing of Oracle Archive log read any available

John Minihan 1 Reputation point
2020-12-22T10:24:50.833+00:00

CDC would process the redo logs in order, as they come available. Currently, CDC requires that all Oracle Redo logs, from the last change processed to current change, are available on disk before it processes anything.

SQL can be unavailable, due to error or design, for a period of time. If logs could be processed in order, rather than when all are available, recovery of the changes could be managed without a potentially huge storage requirement.

SQL Server | Other
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,396 Reputation points Microsoft External Staff
    2020-12-23T06:51:48.33+00:00

    Hi @John Minihan ,

    The archived Oracle Redo Logs that are used by Oracle to ensure that the database can roll back transactions and recover from failures. Below diagram shows the components that make up the CDC Service for Oracle.

    50781-screenshot-2020-12-23-144949.jpg

    Please refer to MS document change Data Capture Service for Oracle by Attunity System Architecture

    I am not sure what is your problem. If this thread is just a suggestion about Change Data Capture Service for Oracle, I recommend you to submit your suggestion to the Microsoft feedback at this link https://feedback.azure.com/forums/908035-sql-server . This site will serve as a connecting point between you and Microsoft.

    If I misunderstood your question, please let me know.

    Best regards,
    Cathy

    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.