Creating Alternate Connections in a Warm Standby Environment

Create an alternate primary connection to the active database or an alternate replicate connection to the standby database for an alternate logical connection.

At the Replication Server that manages the warm standby pair, enter:
create alternate connection to ds_name.db_name
named conn_server.conn_db
...
[as {active|standby} for conn_lds.conn_ldb]
where:
  • ds_name.db_name – the data server name and either the active or standby database name.
  • conn_server.conn_db – the alternate active or standby connection, which comprise a data server name a connection name. conn_ds must be the same as ds_name to support incoming Replication Agent connections.
  • conn_lds.conn_ldb – the data server and database connection components of the alternate logical connection name.
  • active | standby – specify whether to create an alternate connection to the active or standby database.