Creating Alternate Primary Connections

Use create alternate connection to create alternate connections from Replication Server to the primary database.

Enter:

create alternate connection to dataserver.database
named conn_server.conn_db
[with {log transfer on | primary only}]

where:

dataserver and database – are the primary data server and database.
conn_server.conn_db – is the alternate primary connection name, which comprises the data server name and a connection name.
- If conn_server is the same as dataserver, conn_db must be different from database.
- conn_server.conn_db must match the name of the connection between the Replication Agent and Replication Server.
- Each primary connection name must be unique in a replication system.
with log transfer on – instructs Replication Server to create an alternate primary connection and an alternate replicate connection to the database you specify in dataserver.database, with both connections having the name you specify in conn_server.conn_db
primary only – instructs Replication Server to create only an alternate primary connection to the primary database with the name you specify in conn_server.conn_db.

For example, to create an alternate primary connection named SALES_DS.pdb_conn2 to the pdb database in the SALES_DS data server, enter:

create alternate connection to SALES_DS.pdb
named SALES_DS.pdb_conn2
with primary only
go