This section describes setup and configuration tasks for the following Mirror Activator for Oracle system components:
Primary database
Mirror Replication Agent
Replication Server
ECDA for Oracle
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 for Oracle 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,” for more information.
You have installed all Mirror Activator for Oracle components.
You have already completed all of the tasks described in “Setting up Mirror Replication Agent connectivity”.
When setting up a new Mirror Activator for Oracle 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 Mirror Activator for Oracle system Maintenance user in the primary data server and in the primary database. |
4 |
Set up the Mirror Activator for Oracle DDL user in the primary data server. |
5 |
Set up the Replication Server database objects in the primary database. |
6 |
Set up the Replication Server database objects in the RSSD. |
7 |
Set up the ECDA for Oracle to the standby database. |
8 |
Add database connections and Database Replication Definitions and Subscriptions for the primary and standby databases. |
9 |
Create and configure a Mirror Replication Agent instance. |
10 |
Initialize the primary database using the Mirror Replication Agent pdb_init command. |
11 |
Shut down the standby data server.
|
12 |
Quiesce the primary database to suspend update activity. |
13 |
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. |
14 |
Initialize the Mirror Replication Agent using the ra_init command, and set the paths to the mirror log devices.
|
15 |
Resume update activity on the primary database, after the device materialization and Mirror Replication Agent initialization are complete. |
16 |
If you use snapshot materialization for a standby database, start the standby data server. |
17 |
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.
This step is required only when you use snapshot materialization
for a standby database.