Share via

CDC for Oracle by Attunity stuck at status Logger after restart

EF Lin 1 Reputation point
2021-04-16T01:51:28.633+00:00

Hi, I currently have Oracle CDC tool up and running. The changed data are flowing through from the Oracle Database to the CDC Database Instance which is created by the tool in SQL Server successfully. However, the only issue I have is the tool will stuck in the Logger Mode if I stop the CDC Service for a period of time (like an hour).

Could you please advise what caused this? And how resolve it?

Errors as below:

timestamp,type,node,status,sub_status,status_message,source, text_data,binary_data
"15/04/2021 10:04:54 PM","INFO","SQLSERVER","RUNNING","INIT","ORACDC300I:The Oracle CDC instance for service OracleCDCService1 and database ORACLE_CDC_TEST started.","service","",""
"15/04/2021 10:04:54 PM","INFO","SQLSERVER","RUNNING","INIT","ORACDC305I:The value of the option 'source_env_report' was changed to 11.","infrastructure","",""
"15/04/2021 10:05:04 PM","ERROR","SQLSERVER","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
"15/04/2021 10:05:15 PM","ERROR","SQLSERVER","SUSPENDED","LOGGER","ORACDC511E:The Oracle CDC failed to position.","source","",""
"15/04/2021 10:05:55 PM","INFO","SQLSERVER","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service OracleCDCService1 and database ORACLE_CDC_TEST received a reconfigure signal.","service","",""
"15/04/2021 10:05:55 PM","INFO","SQLSERVER","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 12.","infrastructure","",""
"15/04/2021 10:05:55 PM","REPORT","SQLSERVER","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
CDC Service version is: 6.0.0.129

Character set information:
NLS_CHARACTERSET: 178
LS_NCHAR_CHARACTERSET: 2000

Reader Information:
Thread: 1
Last Transaction SCN: 165592140
Last SCN: 165592140
Greatest Sequence: 9813
Start SCN: 165592140
Transaction Sequencer: 1
Context Sequencer: 0
Max SCN: 0
Last RBASQN: 9801
Last RBABLK: 36610
Last RBABYTE: 16
State: 0

Redo logs:

Captured Tables:
82220
28846
28845
28841
28827
28821
28733
28729
",""

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,894 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,467 questions
0 comments

10 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Seshu 1 Reputation point
    2021-05-20T11:14:06.577+00:00

    We managed to troubleshoot the issue at our end couple of weeks ago. This was down to the Oracle Archiving process setup at our end, it triggers at around 8 PM in the night, right after that those archive logs (.ARC files) were being deleted by another job as part of the Daily Backups. Essentially that .arc file is being deleted by Daily backup job before CDC process is done with it, hence this issue.

    0 comments
  2. EF Lin 1 Reputation point
    2021-05-11T02:18:14.013+00:00

    Further testing, I left the service run for few days, and it went to Logger Mode by itself for some reasons...could someone please help...

    timestamp,type,node,status,sub_status,status_message,source, text_data,binary_data
    "11/05/2021 2:11:23 AM","INFO","Test_Server","RUNNING","IDLE","ORACDC303I:The Oracle CDC instance for service OracleCDCService1 and database ORACLE_CDC_TEST received a reconfigure signal.","service","",""
    "11/05/2021 2:11:23 AM","INFO","Test_Server","RUNNING","IDLE","ORACDC305I:The value of the option 'source_env_report' was changed to 16.","infrastructure","",""
    "11/05/2021 2:11:24 AM","REPORT","Test_Server","SUSPENDED","LOGGER","ORACDC000R:Oracle Diagnostics","infrastructure","
    CDC Service version is: 6.0.0.129

    Character set information:
    NLS_CHARACTERSET: 178
    LS_NCHAR_CHARACTERSET: 2000

    Reader Information:
    Thread: 1
    Last Transaction SCN: 172832214
    Last SCN: 172832214
    Greatest Sequence: 10091
    Start SCN: 172832214
    Transaction Sequencer: 2
    Context Sequencer: 0
    Max SCN: 0
    Last RBASQN: 10068
    Last RBABLK: 67066
    Last RBABYTE: 460
    State: 0

    Redo logs:

    Captured Tables:
    82220
    28846
    28845
    28841
    28827
    28821
    28733
    28729
    ",""

    0 comments
  3. Seshu 1 Reputation point
    2021-05-04T08:48:41.923+00:00

    hi, Wonder if someone can advise on the following... The Name filed under V$ARCHIVED_LOG view is set to blank as shown in the below screenshot. Not sure if the "Name" filed is mandatary for Logminer to work particularly when the transactions are archived to a file ? It could be the reason why the CDC service is unable to locate the record after archiving takes place at 8 PM. It then goes into SUSPENDED->LOGGER state.

    Stattus_message under cdc.xdbcdc_trace table shows as "ORACDC511E:The Oracle CDC failed to position."

    Thanks for your help.

    93544-image.png

    0 comments
  4. Seshu 1 Reputation point
    2021-04-30T08:11:00.05+00:00

    We kind of know what is going wrong here but no solution yet. Its is not a problem with the stop and start for us. It is something to do with the Oracle archive logs. Our archive log process kickoff at around 8 PM(in Dev environment) and service is failing link between the online and archive logs seamlessly hence it goes into Suspend state. It is somehow unable to link the transaction logs between the archived one and online. Not sure if there is any fundamental gap here.
    We are using Oracle 11g and SQL Server 2016.

    Also, oracle account that we are using has DBA got permissions at DB end so assuming that it is not a permission related as such.

    92901-image.png

    92854-image.png

  5. EF Lin 1 Reputation point
    2021-04-29T21:06:03.983+00:00

    @Seshu We don't have that issue. Logmining permission has been granted to the account without problem..

    The only problem we have is when we resume the CDC service.

    0 comments