Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Why Replicate capture did not work when one of node of RAC and ASM source endpoint is down ?
One of the reasons for using Oracle RAC is that even if one of the nodes fails, a disruptive business can use it. Another is that upgrades or patches can be performed alternately without disrupting business during upgrades or patches.
However, when using Replicate, if one of the RAC nodes fails and shuts down, or if one node is shut down for maintenance, the capture is not performed. Please let me know why this is happening and what is the solution.
Regards,
Kwang Ho
Hello Kwang Ho,
When working in a RAC environment, it is strongly recommended to set up a shared folder that is accessible by all the RAC instances. If this is not possible, you need to define a temporary folder with the same name on each of the RAC instances. In addition, you need to define separate Oracle and ASM connection strings for each RAC instance.
Capturing changes after a RAC switchover
If you need to run a switchover procedure on your RAC environment with multiple standby nodes, do the following steps to ensure the continuity of CDC.
1. Run a task using the primary RAC node as a source.
2. Stop the task.
3. Do the switchover procedure. This changes your primary RAC node to a standby role and makes your standby node your primary RAC node.
4. Change the credentials to those of your new primary RAC node.
5. Resume the task. All the events that were triggered when the task was stopped will be replicated automatically and the changes will be captured accordingly.
Kindly refer to below link for more information
https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Oracle/OralcleDB_sourcebinary_A...
Regards,
Sachin B
Hello Kwang Ho,
When working in a RAC environment, it is strongly recommended to set up a shared folder that is accessible by all the RAC instances. If this is not possible, you need to define a temporary folder with the same name on each of the RAC instances. In addition, you need to define separate Oracle and ASM connection strings for each RAC instance.
Capturing changes after a RAC switchover
If you need to run a switchover procedure on your RAC environment with multiple standby nodes, do the following steps to ensure the continuity of CDC.
1. Run a task using the primary RAC node as a source.
2. Stop the task.
3. Do the switchover procedure. This changes your primary RAC node to a standby role and makes your standby node your primary RAC node.
4. Change the credentials to those of your new primary RAC node.
5. Resume the task. All the events that were triggered when the task was stopped will be replicated automatically and the changes will be captured accordingly.
Kindly refer to below link for more information
https://help.qlik.com/en-US/replicate/May2022/Content/Replicate/Main/Oracle/OralcleDB_sourcebinary_A...
Regards,
Sachin B
Hi @khchoy
If one of the replies helped to resolve the issue, please mark it as a solution & like it to make it easier for others to find.
Thanks in advance!
Dana