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

[KG_Maleka]

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?

[sureshkumar]

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/Oracl...

Regards,

Suresh

[Jon_Donker]

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.

[sureshkumar]

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

[lguevara]

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