topic Re: Oracle as source in Qlik Replicate

Oracle as source

gayatri235 — Fri, 12 Jan 2024 05:10:56 GMT

Hello Team,

We need to configure oracle as source. Our organization was asking us to enable supplemental logging for secondary server, why can't we do that?

As per qlik replicate pre-req, we need to enable supplemental logging on primary only.

II tried googling for the justification why we need supplemental logging on primary only but couldn't find much.

It will be a great help, if anyone provides a justification.

Regards,

Gayatri.

Re: Oracle as source

OritA — Fri, 12 Jan 2024 08:52:06 GMT

Hi Gayatri,

In genreal, the supplemental logging cuase Oracl to write information to the redo logs. The redologs are managed by the primary Oracle instance. For further information please consult your Oracle DBA.

Regards,

Orit

Re: Oracle as source

DesmondWOO — Fri, 12 Jan 2024 09:35:58 GMT

Hi @gayatri235 ,

Do you mean Oracle Standby server? Please also check our user guide for supported standby configuration.

Regards,
Desmond

Re: Oracle as source

john_wang — Fri, 12 Jan 2024 09:36:17 GMT

Hello @gayatri235 ,

Are you meaning the STANDYrole of Oracle (secondary server)?

Qlik Replicate detects the Oracle source database role automatically, and we support both of the 2 roles, PRIMARYor STANDY.

PRIMARYrole
1. The database must be in read-write mode, Replicate can add the supplemental logging automatically (if grant enough privileges). Or your DBA add it manually and Replicate use it afterwards.

STANDY role
1. The database is in read-only mode. however it accepts PRIMARY node synchronization operations, for example if the supplemental logging is added in PRIMARYnode, then the supplemental logging settings will be synchronized
to STANDYnode after the internal cycle between the two Oracle nodes.
2. Qlik Replicate cannot add supplemental logging in read-only mode database (or Disaster Recovery database), the operations should be done on PRIMARYnode and waiting for it being transferred to STANDY node. After the supplemental logging is synchronized then Replicate can utilize it in STANDYrole node.

In summary, if you want to use Oracle STANDYrole node as Qlik Replicate source database, the supplemental logging property should be added in the Oracle PRIMARY node.

Hope this helps.

John.

Re: Oracle as source

gayatri235 — Fri, 12 Jan 2024 10:07:21 GMT

Yes, it does help. Thank you!!!
Gayatri