Task Four: Adding the Standby Database

Use rs_init to add the standby database and its RepAgent to the replication system, then you initialize the standby database with data from the active 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. Bring the new database online using the online database clause before replicating.

• Create the Standby Database
  If it does not already exist, you must create the standby database in the appropriate Adaptive Server, according to your needs.
• Determine How to Initialize the Standby Database
  Initialize the standby database with data from the active database.
• Add the Standby Database Maintenance User
  If you plan to initialize the standby database using the dump and load commands, with or without the “dump marker” option, you must create the maintenance user login name for the standby database in both the standby and the active data servers before you add the standby database.
• Adding the Standby Database to the Replication System
  Initialize the standby database, bring it online, and resume the connection to it, to add it to the replication sysem.
• Enable Replication for Objects in the Standby Database
  To be ready to switch to the standby database, you must enable replication for the tables and stored procedures in the standby database that you want to replicate into the new standby database after the switch.
• Granting Permissions to the Maintenance User
  After adding the standby database, you must grant the necessary permissions to the maintenance user.