Qlik Replicate and Amazon RDS for Oracle source endpoint: ARCHIVELOG mode is not defined in the used Oracle database

[john_wang]

While accessing the Amazon RDS for Oracle as the source database, the task reports a warning message and an error message during the task startup.

The messages in task log file:

2024-08-01T10:22:33:282880 [SOURCE_CAPTURE  ]W:  ARCHIVELOG mode is not defined in the used Oracle database  (oracle_endpoint_conn.c:179)

2024-08-01T10:22:33:395316 [SOURCE_CAPTURE  ]E:  Cannot retrieve Oracle archived Redo log destination ids [1020401]  (oracdc_merger.c:661)

Environment

• Qlik Replicate All versions
• Amazon RDS for Oracle All versions

Resolution

Setting up the Oracle database instance with Enabled Automatic Backups option to Yes by using AWS Management Console, or by AWS CLI command.

For example:

aws rds modify-db-instance --db-instance-identifier mydevdb --backup-retention-period 2 --apply-immediately

Where mydevdb is the identifier of DB instance to modify. This value is stored as a lowercase string.

Internal Investigation ID(s)

00168581