Qlik Replicate and Oracle as Source: To use CDC, the Oracle database must be configured to archived Redo logs [1022313]

Steve_Nguyen — Mon, 08 Apr 2024 12:17:16 GMT

After implementing an Oracle Database Failover or otherwise switching to a new database, Qlik Replicate tasks may not start processing CDC and repeat the message:

[SOURCE_CAPTURE ]I: Start processing new RESETLOGS_ID '1077621340' that does not still have archived Redo logs

This is an identical error message as seen in Unable to resume Qlik Replicate tasks due to the error Start processing new RESETLOGS_ID 'xxxxxx' that does not still have archived Redo logs, but implementing the solution has no effect.

Creating and running a new task reveals a different error:

[SOURCE_CAPTURE ]E: To use CDC, the Oracle database must be configured to archived Redo logs [1022313]

Resolution

The database must be in archivelog mode in order to enable CDC. See Prerequisites | Qlik Replicate with Oracle as source.

In addition, note that Qlik Replicate does checks when the task is started fresh, not at every resume.

article Qlik Replicate and Oracle as Source: To use CDC, the Oracle database must be configured to archived Redo logs [1022313] in Official Support Articles

Qlik Replicate and Oracle as Source: To use CDC, the Oracle database must be configured to archived Redo logs [1022313]

Resolution

Environment