Multiple Connections to the Replicate Database

Create multiple connections from Replication Server to the replicate database.

When you create multiple connections to the replicate database, each replication connection subscribes to one transaction stream. Transactions in the same stream adhere to the primary commit order. Transactions in different streams are applied in parallel and may not be in primary commit order.

Default and Alternate Replicate Connections

You can also create replicate connections from multiple Replication Servers to the same replicate database in the same replication domain. Only one Replication Server in the replication domain can possess and control the default replicate connection. You cannot create multiple default replicate connections from other Replication Servers in the domain. Other Replication Servers can have only alternate replicate connections.

After you create an alternate replicate connection, you can alter the connection properties or drop the connection. You can also display the status of all connections and create subscriptions for the connection.