Oracle Source CDC error Cannot find archived REDO log with sequence

lguevara — Fri, 24 Oct 2025 17:33:11 GMT

Hi,

I using oracle 19c as source with qlik replicate 202411, I configure cdc in oracle with log miner, the archive logs and supplemental logging are enable.

But I has this error:

[SOURCE_CAPTURE ]T: Set position in LOG MINER (oracdc_reader.c:1289) [SOURCE_CAPTURE ]T: Start LogMiner Session in thread '1' for: StartScn '0xxxx', MaxScn '000xxx', LastTransactionScn '0000000000000000', ScnNotFoundError '0' (oracdc_reader.c:846) [SOURCE_CAPTURE ]T: Get archived REDO log with sequence 211xxx for the first SCN in thread 1 (oracdc_reader.c:298) [SOURCE_CAPTURE ]T: Cannot find archived REDO log with sequence '211xxx', thread '1' (oracdc_reader.c:410) [SOURCE_CAPTURE ]T: Failed to set position in thread '1' (oracdc_reader.c:2049) [SOURCE_CAPTURE ]T: Oracle CDC stopped [1022301] (oracdc_merger.c:1235) [SOURCE_CAPTURE ]T: Endpoint is disconnected [1020414] (endpointshell.c:4271) [SOURCE_CAPTURE ]T: Error executing source loop [1020414] (streamcomponent.c:1946) [SOURCE_CAPTURE ]T: Stream component 'st_0_EP_dOoaPxMxURSr6L9DBm6wfg' terminated [1020414] (subtask.c:1675) [SOURCE_CAPTURE ]T: Free component st_0_EP_dOoaPxMxURSr6L9DBm6wfg (oracle_endpoint.c:51) [TASK_MANAGER ]I: Task error notification received from subtask 0, thread 0, status 1020414 (replicationtask.c:3635) [TASK_MANAGER ]W: Task 'TASK_vcU5_eNQf6xSxuIdKpywMA' encountered a recoverable error (repository.c:6372) [SORTER ]I: Final saved task state. Stream position 0000001CF9E6A9360200000100031B2900050C33001000000000001CF9DDB95A, Source id 4103654, next Target id 13, confirmed Target id 9, last source timestamp 1761175260000000 (sorter.c:772) [SOURCE_CAPTURE ]E: Oracle CDC stopped [1022301] (oracdc_merger.c:1235) [SOURCE_CAPTURE ]E: Endpoint is disconnected [1020414] (endpointshell.c:4271) [SOURCE_CAPTURE ]E: Error executing source loop [1020414] (streamcomponent.c:1946) [TASK_MANAGER ]E: Stream component failed at subtask 0, component st_0_EP_dOoaPxMxURSr6L9DBm6wfg [1020414] (subtask.c:1504) [SOURCE_CAPTURE ]E: Stream component 'st_0_EP_dOoaPxMxURSr6L9DBm6wfg' terminated [1020414] (subtask.c:1675)

Please If you have any idea about the error.

Thanks

Re: Oracle Source CDC error Cannot find archived REDO log with sequence

Dana_Baldwin — Fri, 24 Oct 2025 17:50:33 GMT

Hi @lguevara

How long is your RMAN retention for archived logs? As a rule of thumb we recommend 3 days retention so you can more easily recover from a possible issue over a weekend, but you may want/need a longer retention time.

This error means that the physical file is no longer available and/or it does not show status=A in v$archived_log. The file must be on disk and registered as available in the source for Replicate to process it.

Thanks,

Dana

topic Re: Oracle Source CDC error Cannot find archived REDO log with sequence in Qlik Replicate

Oracle Source CDC error Cannot find archived REDO log with sequence

Re: Oracle Source CDC error Cannot find archived REDO log with sequence