CDC Attunity : Async switch from online redo log to archived log when online logs are not available

Krutika Shirbhate 0 Reputation points
2024-07-29T14:16:57.0366667+00:00

My organization has been using the CDC Attunity tool for the past three years to manage data replication between an Oracle 11g source database and a SQL Server 2016 destination database. Recently, we have encountered an issue where the tool is unable to read data from the Oracle online redo logs due to some technical problems. As a solution, we would like to switch to using archived redo logs to read the data. To proceed with this change, we need to understand is there any option is provided by this tool for switching from online redo logs to archived redo logs when online log is not available (Async switch) in the CDC Attunity tool.

Please reply at the earliest as we are facing production issue.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,001 questions
0 comments No comments
{count} votes

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.