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.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
