Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hello @gayatri235 ,
Are you meaning the STANDY
role of Oracle (secondary server)?
Qlik Replicate detects the Oracle source database role automatically, and we support both of the 2 roles, PRIMARY
or STANDY
.PRIMARY
role
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 PRIMARY
node, then the supplemental logging settings will be synchronized
to STANDY
node 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 PRIMARY
node and waiting for it being transferred to STANDY
node. After the supplemental logging is synchronized then Replicate can utilize it in STANDY
role node.
In summary, if you want to use Oracle STANDY
role node as Qlik Replicate source database, the supplemental logging property should be added in the Oracle PRIMARY
node.
Hope this helps.
John.
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
Hi @gayatri235 ,
Do you mean Oracle Standby server? Please also check our user guide for supported standby configuration.
Regards,
Desmond
Hello @gayatri235 ,
Are you meaning the STANDY
role of Oracle (secondary server)?
Qlik Replicate detects the Oracle source database role automatically, and we support both of the 2 roles, PRIMARY
or STANDY
.PRIMARY
role
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 PRIMARY
node, then the supplemental logging settings will be synchronized
to STANDY
node 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 PRIMARY
node and waiting for it being transferred to STANDY
node. After the supplemental logging is synchronized then Replicate can utilize it in STANDY
role node.
In summary, if you want to use Oracle STANDY
role node as Qlik Replicate source database, the supplemental logging property should be added in the Oracle PRIMARY
node.
Hope this helps.
John.