Using the Add Standby Database wizard, you can add a standby database to an existing logical connection which already has an active database connection.
Creating a standby database connection
In the Details view, right-click the logical connection object you created using the Add Logical Connection wizard.
Select Add Standby Database. The Add Standby Database wizard starts.
Select the standby server and standby database.
Select the Replication Server that will manage the database connections.
Enter the user name and password of the maintenance user.
Select the user name and password that the RepAgent will use to connect to Replication Server.
If the RepAgent user does not exist, the wizard creates one for you and gives it a default name and password. Accept the defaults, or enter your own values.
Select the materialization method.
Select one of the following options:
Initialize Standby Database with Dump Load, which initializes the standby database with the current data dump from the active database.
Use Dump Marker in Transaction Log, which replicates transactions that are executed between the time the active database is enabled and the time the data is dumped.
Review the summary information about the replication environment.
If everything looks correct, click Finish. Otherwise, click Back to return to an earlier page in the wizard and change the replication environment information. Then return to the final wizard page and click Finish.
Replication Manager creates the standby database connection.
Before you use your warm standby environment, resume
the DSI thread on the replicate database connection, if necessary.
