Oracle Source CDC error Cannot find archived REDO log with sequence

[lguevara]

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

[Dana_Baldwin]

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