Creating Multiple Replication Paths for Warm Standby Environments

Use logical connections to bind a replicate connection for a standby database and a primary connection for an active database to create two complete replication paths between an active database and a standby database in a warm standby environment.

  1. Divide transactions into two sets and ensure the transactions in the two sets can be run in parallel.
    For example, you can divide the transactions into two sets of objects such as tables or stored procedures.
  2. Enable multithreaded RepAgent and two replication paths for RepAgent for both the active database and replicate database, and bind the objects to the replication paths.
  3. Create a logical connection. See create logical connection in the Replication Server Reference Manual.
  4. Use rs_init to add the active and the standby databases to the replication system.
  5. Create an alternate logical connection
  6. Create an alternate active connection for the alternate logical connection.
  7. Use admin who to check for the REP AGENT thread and verify that the default and alternate connections to the active database of the warm standby pair are active.
    For example, you see:
    31 REP AGEN   Awaiting Command     TOKYO_DS.pubs2
  8. Create an alternate standby connection for the alternate logical connection.
Parent topic: Multiple Replication Paths for Warm Standby Environments