Unable to find log files - connect_cdc_sqdata - Latest

Connect CDC (SQData) Troubleshooting

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Troubleshooting
Copyright
2024
First publish date
2000
Last updated
2024-11-25
Published on
2024-11-25T15:16:52.503000
The Publisher keeps track of the in-flight transactions and knows, at all times the safe restart point, that is the SCN of the oldest record of the oldest in-flight transaction. Commit and rollback information is managed for each Unit-of-work by the CDCStore transient Storage Manager and Publisher. Downstream Apply Engines process only committed UOW changed data. This guarantees a safe restart without risk of losing part of a transaction but is only effective if the archived logs are available. You must have archive log mode enabled in order to run the Oracle capture agent. If the required archive log is not available a diagnostic message will be passed from LogMiner to the Capture and you will receive a message similar to:
$ sqdconf start /<SQDATA_VAR_DIR>/oracdc/oracdc.cab

SQDC019E Oracle Error (1291):ORA-01291: missing logfile ORA-06512: at "SYS.DBMS_LOGMNR", line 53 ORA-06512: at line 2 SQDC020I sqdconf terminated with Return Code 8, Reason Code=0x7002850b ()

This occurs because the re-start SCN is actually before the range covered by the currently available redo log file. If you cannot make the necessary archive log available you will loose changed data. It will be necessary to reset the SCN of the capture agent to a later point that you determined is covered by available archive log files. Alternatively you can reset the SCN to 0 using the "sqdconf modify" and the capture agent will re-start from "current". Note, you must also issue the "sqdconf apply" before restarting for the SCN change to take effect.

In a production environment, where the Capture Agent is regularly monitored, this kind of extreme situation is very unlikely and would only occur if a capture agent remained in a stopped state for a significant amount of time.