Setting up a new Mirror Activator system

This section describes setup and configuration tasks for the following Mirror Activator system components:

Primary database

Mirror Replication Agent

Replication Server

Standby database

Use the setup and configuration tasks in this section if you are setting up a new Mirror Activator system (that is, using a primary database that was not previously configured for a Replication Server warm standby application).

If you are converting an existing warm standby application to a Mirror Activator system, see “Converting a warm standby application to a Mirror Activator system” for setup and configuration tasks.

Table 2-1 provides a checklist of the tasks required to configure all of the software components and set up a new Mirror Activator system for replication.

The checklist in Table 2-1 assumes that:

The primary database was not previously configured for a Replication Server warm standby application.

You will perform a snapshot materialization of the standby database, using the disk replication system facilities. See Appendix A, “Materializing Databases,” for more information.

You have already completed all of the tasks described in “Setting up Mirror Replication Agent connectivity”.

If the primary database was previously configured for a Replication Server warm standby application, do not use the checklist in Table 2-1. You must instead use the setup and configuration tasks described in “Converting a warm standby application to a Mirror Activator system”.

When setting up a new Mirror Activator system, you must perform the tasks in Table 2-1 in the order they are shown. If you deviate from this sequence, the results may be unpredictable, and you may have to back out of the entire process and start over.

**Table 2-1: Setup and configuration for a new Mirror Activator system**
Task	Description
1	Set up the Mirror Activator system Maintenance User in the primary data server and in the primary database.
2	Set up the Mirror Activator system Maintenance User in the standby data server.
3	Set up the Replication Server database objects in the primary database.
4	Initialize the primary database using the Mirror Replication Agent pdb_init command. After the primary dabatase is initialized, you must not allow any DDL operations before it is quiesced in step 7.
5	Add a logical connection and database connections for the primary and standby databases to the Replication Server.
6	Shut down the standby data server. This step is required only when you use snapshot materialization for a standby database in Adaptive Server version 12.5.0.3.
7	Quiesce the primary database to suspend update activity.
8	Materialize the standby database data and log devices and the mirror log devices at the standby site, and set up the disk replication system for synchronous replication to the mirror log devices.
9	Initialize the Mirror Replication Agent using the ra_init command, and set the paths to the mirror log devices. You can initialize the Mirror Replication Agent concurrently with materialization (step 8).
10	Resume update activity on the primary database, after the device materialization and Mirror Replication Agent initialization are complete.
11	If you use snapshot materialization for a standby database in Adaptive Server version 12.5.0.3, start the standby data server. If you use the snapshot materialization mount database option, mount the standby database and bring it online.
12	Resume the Mirror Replication Agent to put it in Replicating state, and resume the standby database connection in the Replication Server.

Table 2-1: Setup and configuration for a new Mirror Activator system

Task

Description

Set up the Mirror Activator system Maintenance User in the primary data server and in the primary database.

Set up the Mirror Activator system Maintenance User in the standby data server.

Set up the Replication Server database objects in the primary database.

Initialize the primary database using the Mirror Replication Agent pdb_init command.

After the primary dabatase is initialized, you must not allow any DDL operations before it is quiesced in step 7.

Add a logical connection and database connections for the primary and standby databases to the Replication Server.

Shut down the standby data server.

This step is required only when you use snapshot materialization for a standby database in Adaptive Server version 12.5.0.3.

Quiesce the primary database to suspend update activity.

Materialize the standby database data and log devices and the mirror log devices at the standby site, and set up the disk replication system for synchronous replication to the mirror log devices.

Initialize the Mirror Replication Agent using the ra_init command, and set the paths to the mirror log devices.

You can initialize the Mirror Replication Agent concurrently with materialization (step 8).

Resume update activity on the primary database, after the device materialization and Mirror Replication Agent initialization are complete.

If you use snapshot materialization for a standby database in Adaptive Server version 12.5.0.3, start the standby data server.
If you use the snapshot materialization mount database option, mount the standby database and bring it online.

Resume the Mirror Replication Agent to put it in Replicating state, and resume the standby database connection in the Replication Server.

The following sections contain detailed procedures for each setup and configuration task.