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).
This section describes setup and configuration tasks for the following Mirror Activator system components:
Primary database
Mirror Replication Agent
Replication Server
ECDA Option for Oracle or ECDA Option for ODBC
Standby database
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:
You will perform a snapshot materialization of the standby database, using the disk replication system facilities. See Appendix A, “Materializing Databases in a Mirror Activator system” for more information.
You have installed all Mirror Activator components.
You have already completed all of the tasks described in “Setting up Mirror Replication Agent connectivity”.
WARNING! When setting up a new Mirror Activator system, you must perform the tasks in Table 2-1 in the order they are shown. Deviating from this sequence may produce undesired results, requiring the process to be repeated.
Task |
Description |
|---|---|
1 |
Set up and enable the disk replication system for synchronous replication to the mirror log devices. |
2 |
Set up the disk replication system for snapshot replication to support materialization. |
3 |
Set up the Maintenance User in the primary data server and the primary database. |
4 |
Set up the Maintenance User in the standby data server. |
5 |
For Oracle: Set up the DDL user in the primary data server. |
6 |
Set up the Replication Server database objects in the primary database. |
7 |
For Oracle: Set up the Replication Server database objects in the RSSD. |
8 |
Create and configure a Mirror Replication Agent instance. |
9 |
For Oracle: Set up the ECDA Options to the standby database. |
10 |
Add database connections and Database Replication Definitions and Subscriptions for the primary and standby databases.
|
11 |
Initialize the Mirror Replication Agent transaction log |
12 |
Shut down the standby data server.
|
13 |
Quiesce the primary database to suspend update activity. |
14 |
Materialize the standby database data and log devices and the mirror log devices at the standby site. Retain synchronous replication to the mirror log devices. |
15 |
Initialize the primary database and Mirror Replication Agent using the pdb_init and ra_init commands, and set the paths to the mirror log devices.
|
16 |
Resume update activity on the primary database, after the device materialization and Mirror Replication Agent initialization are complete. |
17 |
If you use snapshot materialization for a standby database, start the standby data server. |
18 |
Resume the Mirror Replication Agent to put it in Replicating state. |
19 |
Resume the standby database connection in the Replication Server. |
The following sections contain detailed procedures for each setup and configuration task.
For ASE, if using a warm standby database, you must
first establish a logical connection.