topic Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience in Qlik Replicate

Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

KG_Maleka — Mon, 29 May 2023 10:11:38 GMT

Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

We are using REDO logs and sometimes we miss a particular log, which end up causing us to reload target and business does not like that. We are then tasked to see if we can't use ARCHIVE REDO LOGS

If you are already using this option, what is your experience?

Re: Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

sureshkumar — Mon, 29 May 2023 10:56:08 GMT

Hello Team,

Use archived redo logs only: When this option is selected, Replicate will only access the archived redo logs. If the archived redo logs are stored on ASM only, the Replicate user needs to be granted the ASM privileges.

Required ASM privileges
The following section describes the additional permissions that are required when the redo logs are stored in ASM.

Grant the following read privilege:

SELECT ON v_$transportable_platform

https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedReplicateHDD/Oracle/OracleDBSource_Security.htm#ar_oracleds_385117211_beijchii

Regards,

Suresh

Re: Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

Jon_Donker — Mon, 29 May 2023 22:36:42 GMT

We tried it as a performance curiosity piece when we were developing and noticed it was marginally slower so we didn't pursue any further

We have a low tps oracle system (a couple of changes per a second) but the Qlik tasks has a source lookup in it to add overhead to the latency.

I am speculating that the performance might get worse if you have a higher tps system.

Re: Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

sureshkumar — Tue, 30 May 2023 05:57:01 GMT

Hello,

Yes, i agree, the Lookup may have a performance implication and will need to be tested to see if it meets all of your latency criteria.
Transformation: Source Lookup - CLOB datatype - li... - Qlik Community - 1987353

Transformation: Source Lookup - Oracle ROWID - Qlik Community - 1805170

Regards,

Suresh

Re: Is anyone using Archive REDO Logs only (oracle) to replicate and if so how is the experience

lguevara — Thu, 30 Oct 2025 20:08:00 GMT

Hi @sureshkumar

If in oracle RAC create a new destination of archive redo logs.

If configure in oracle a new "Archive redo logs destination" and set this value in "Archived redo logs destination ID"
- check in redo logs only.

but without asm privelege and without grant the CREATE ANY DIRECTORY.

Please you know if this work fine?

thanks