Use standby node Oracle database as a source

[FrancoHR]

One of the clients wants to know if it can be replicated from a secondary node in this case Oracle.
Having the secondary database in Mount status, is it possible to connect to Qlik Replicate?
What state must the secondary database be in for it to replicate? considering that you can only go up to the Read Only level.

Regards,

[john_wang · Accepted solution]

Hello @FrancoHR ,

Thanks for reaching out to Qlik Community!

Qlik Replicate support Snapshot Standby and Physical Standby (with Active Data Guard enabled) as source endpoint. If the database is in mount status, it's not supported.

Hope this helps.

John.

[haneryh1]

19.10 is more stable than 19.11; we rolled back to 10 at Oracle consulting's recommendation. RHEL 7.6 on dell has been stellar. We tried to migrate to OCI and then Oracle Cloud at Customer...that all shit the bed; very poorly supported and the tooling was not stable. Its all on prem now and it runs amazing. We no longer monkey with RAC...but we data guard all production builds [your sla may be different to its not an argument against rac]. Easy peasy. Nothing wrong with OEL, imo.