Multiple Replication Agents

Replication Agent for Oracle supports the use of multiple Replication Agent instances with Replication Server Multi-Path Replication™ to replicate data in parallel from one Oracle primary database across two or more independent replication paths. By replicating data in parallel, multiple Replication Agents can increase replication throughput and performance and reduce resource contention.

Supported Databases

Replication Agent for Oracle 15.7.1 supports multiple Replication Agents to replicate Oracle 10g and 11g tables and procedures to these replicate databases:
  • Adaptive Server® Enterprise – version 15.7 and later.

  • Oracle – version 10g and 11g. See Replication Server Options > Replication Agent Release Bulletin > Product Summary > Product Compatibility.

  • Sybase® IQ – version 12.7 ESD #3 and later. See Replication Server Release Bulletin > Product Compatibility > Replication Server Interoperability .

For a description of end-to-end Multi-Path Replication scenarios, see the Replication Server Heterogeneous Replication Guide.

New Parameters

Replication Agent for Oracle 15.7.1 includes the ra_admin_owner and ra_admin_prefix parameters for use with multiple Replication Agents. See the Replication Agent Primary Database Guide and the Replication Agent Reference Manual.

DDL Replication in a Multipath Environment

To prevent DDL synchronization errors, use the pdb_setrepddl command, which has been updated for environments using multiple Replication Agents.

License

No separate license is required to use multiple Replication Agents with Replication Agent for Oracle.