Configuring the CDC Replication Engine for Oracle databases for OS (operating system) clustering

CDC Replication supports Active/Passive two-node clusters. Clustering provides continuous access to resources in the event of a hardware failure, software failure, or some other interruption.

To implement CDC Replication clustering support in your environment, you must complete all of the following prerequisite tasks.

Note: Prerequisites that only apply to CDC Replication as a clustered source or a clustered target are specified.
  • Install CDC Replication on the shared drive of the cluster.
  • Add a new instance of CDC Replication.
  • Ensure that the server port you specify during configuration of the instance is available and persistent on both nodes of the cluster. CDC Replication listens on this port.
  • Ensure that CDC Replication connects to the database in the same way on both nodes of the cluster. In other words, database connection parameters such as the path to the database and services must be identical on both nodes of the cluster.
  • Ensure that all of the database logs required for replication are available. This prerequisite only applies to CDC Replication as a clustered source.
  • Ensure that the path to the database logs required for replication is identical on both nodes of the cluster. This prerequisite only applies to CDC ReplicationCDC Replication as a clustered source.
  • Ensure that every CDC Replication source that connects to the target sees the target in the same way. The target must have a clustered IP address or use the same host name for both nodes of the cluster. This prerequisite only applies to CDC Replication as a clustered target.
  • You should schedule a regular backup of your CDC Replication metadata and event log messages. Note that metadata will only change when you add or modify subscriptions. You can find more information about this prerequisite in the failover procedure for CDC Replication in this section.
Note: You can run the dmshowlogdependency command with the –i flag to list the database logs required for replication.