Implementing such a configuration for Oracle is a two step process:
- Create a single straight Replication Engine script that can be reused on each system.
- Create 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.