Reviewing the installation process

Installing Mirror Replication Agent software is just one part of the process of setting up a replication system.

Table 2-7 lists the major steps required to set up a replication system to replicate transactions from an Oracle database in an enterprise network.

Table 2-7: Setting up a Sybase replication system

Step

To do this

Refer to

1

Install the connectivity drivers for the Oracle database server.

You must install the correct JDBC driver for your primary database server.

2

Install appropriate hardware and software.

Establish active mirroring of the Oracle redo logs.

Disk replication system vendor and device vendor documentation

3

Implement Disk replication system and devices.

This includes:

  • Designing the disk mirroring system

  • Installing appropriate hardware or software

  • Establishing active mirroring of the Oracle redo logs

Disk replication system vendor and device vendor documentation

4

Install Replication Server.

This includes:

  • Designing the replication system

  • Installing the Replication Server

  • Sybase installer documentation

  • Replication Server documentation

5

Prepare to install Mirror Replication Agent.

This includes:

6

Install the Mirror Replication Agent software.

This includes:

  • Installing the software

    NoteMirror Replication Agent must be installed on a machine from which it can directly access the mirrored Oracle redo logs.

“Installing the Mirror Replication Agent software” in this manual

7

Install ECDA Option for Oracle.

This includes:

  • Installing the ECDA software

  • Configuring connectivity to the Standby Oracle database

  • Sybase installer documentation

  • ECDA for Oracle documentation

8

Configure Replication Server and primary data server connections.

This includes:

  • Creating a Replication Server database connection to the primary data server

  • Creating a Replication Server login for the Mirror Replication Agent instance

  • Configuring Mirror Replication Agent parameters

  • Testing connections between the Mirror Replication Agent and the primary Replication Server, and between the Mirror Replication Agent and the primary data server

Mirror Activator for Oracle Administration Guide, Chapter 3, “Administering Sybase Replication Agent”

9

Configure Replication Server and standby data server connections.

This includes:

  • Installing the Heterogeneous support scripts for Oracle.

  • Creating a Replication Server login for the standby maintenance user.

  • Creating a Replication Server database connection to the standby data server

Replication Server Heterogeneous Replication Guide

10

Set up the Mirror Replication Agent instance.

This includes:

  • Creating the Mirror Replication Agent transaction log objects

  • Marking primary objects for replication

Mirror Activator for Oracle Administration Guide, Chapter 2, “Setup and Configuration”

11

Prepare for replication.

Refer to the checklist to verify that all the replication system components are in place before you start replication.

Mirror Activator for Oracle Administration Guide, Chapter 2, “Setup and Configuration”

12

(optional) Verify your replication system using Mirror Replication Agent test scripts.

Use the test scripts provided with Mirror Replication Agent to set up a test environment and verify replication from a primary database to a standby database.

Mirror Activator for Oracle Administration Guide

10

Prepare for replication.

This includes:

  • Creating Replication Definitions and Subscriptions.

  • Materializing the standby database to ensure data is synchronized with the primary database before you start replication.

  • Replication Server documentation

  • Mirror Activator for Oracle Administration Guide, Appendix A, “Materializing databases”

11

Start replication.

Put the Mirror Replication Agent instance in the Replicating state.

Mirror Activator for Oracle Administration Guide, Chapter 2, “Setup and Configuration”