Task four: Adding the standby database

Use rs_init to add the standby database and its RepAgent to the replication system, then you initialize it with data from the active database.

This section explains how to add the standby database to the replication system and prepare it for operation.

This section also describes enabling replication for objects in the standby database and granting permissions to the maintenance user in the standby database. Whether or not you need to perform these steps depends on your method for initializing the standby database.

Before you add the standby database:

  1. Create the standby database, if it does not already exist.

  2. Determine how to initialize the standby database.

  3. Add the standby database maintenance user—if you are using dump and load to initialize the standby database.

  4. Online the new database using the online database clause before replicating.