Creating a Standby Database Connection

Use the Add Standby Database wizard to add a standby database to an existing logical connection that already has an active database connection.

1. In the Details view, right-click the logical connection object you created using the Add Logical Connection wizard.
2. Select Add Standby Database.
   The Add Standby Database wizard starts.
3. Select the standby server and standby database.
4. Select the Replication Server that will manage the database connections.
5. Enter the user name and password of the maintenance user.
6. 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.

7. Select the materialization method.
8. Select one of these 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.
9. Review the summary information about the replication environment.
10. If everything looks correct, click Finish. Otherwise, click Back to return to an earlier page in the wizard and change the replication environment information.

Before you use your warm standby environment, resume the DSI thread on the replicate database connection, if necessary.