|
Oracle Active/Active Replication |
Scroll |
An overview of Active/Active Replication is provided in the Change Data Capture Guide. Implementing such a configuration for Oracle is a two step process:
1.Create a single straight Replication Engine script that can be reused on each system.
2.Creation of Capture and Apply configurations on each of the systems.
add --active | --inactive --key=<TABLE_NAME>
--add-excluded-user=sqdata_user
--datastore=cdc:////<engine_agent_alias>
<cab_file_name>
Note: The Oracle LogMiner API Capture, by default excludes all updates made by an SQData Apply Engine. The reason for this is to avoid circular replication.
