Jump to: navigation, search

Setting Up Replication

The following task summary provides instructions on how to deploy Genesys Info Mart in the Business Continuity architecture.

In the description and in the following procedure, the term "replication source" is used to refer to the Info Mart database at the active site (the source of data replication) while the term "replication target" is used to refer to the Info Mart database at the standby site (the target of data replication).

The following three major processes are used in Oracle GoldenGate for data replication between the source and target databases:

  • Extract
  • DataPump
  • Replicat

Use GoldenGate data-definitions files to configure each of these processes (refer to Oracle® GoldenGate Windows and UNIX Administrator's Guide for instructions). The following Task Summary provides Genesys-specific recommendations.

Important
The instructions for the replication setup and Disaster Recovery do not cover Genesys Info Mart tenant views. If it is important for your environment to preserve tenant views for the purposes of Disaster Recovery, contact Genesys for recommendations.

Deployment Prerequisites

The following instructions assume that the Genesys Info Mart deployment at the active site is operational. The active Genesys Info Mart server can continue to run until the step in which you copy the Info Mart database to the standby site.

As a prerequisite, you need to do the following:

  • Deploy the standby Genesys Info Mart Server application at the standby site. To avoid the synchronization task for Application objects between the active and standby sites, use the same Application configuration object for the standby Genesys Info Mart Server application as already configured for the active Genesys Info Mart Server application. It is recommended to stop Genesys Info Mart Server at the active site for the period while the standby Genesys Info Mart Server is being deployed. Once the deployment is complete at the standup site, check that the Application object in the Configuration Layer references the host on which the active Genesys Info Mart Server application must be running and start the active Genesys Info Mart Server. You will change the host association to point to the standby Genesys Info Mart Server application as part of the Disaster Recovery procedure.
  • Configure Database Access Points (DAPs) to extract IDB data after Disaster Recovery.
  • Install the Genesys Info Mart Administration Console at the standby site.

With these considerations in mind, follow the deployment instructions in the Genesys Info Mart 8.1 Deployment Guide to deploy the Genesys Info Mart components at the standby site before you proceed with the replication configuration.

Configuring Database Replication for Info Mart Database

Task Summary

Set up the Genesys Info Mart database at the standby site.
Refer to the Genesys Info Mart 8.1 Deployment Guide for general instructions. Keep in mind that the standby Info Mart database must have a schema identical to the active database.

Deploy Oracle GoldenGate at both sites.
Oracle GoldenGate must be deployed at both sites, on the hosts where the Info Mart database instances reside, according to the Oracle documentation.

Configure the Extract, DataPump, and Replicat modules.
The following Info Mart-specific samples demonstrate how to exclude Info Mart tables from replication.
Substitute the following variables in the configuration file examples:

[+] See variables

For configuration instructions, refer to the Oracle GoldenGate documentation.

Extract

[+] See configuration

DataPump

[+] See configuration

Replicat

[+] See configuration

(For Genesys Info Mart release 8.1.0 or 8.1.1 only) Create an additional index on the CTL_EXTRACT_HWM table on both Info Mart database schemas.
If you are using Genesys Info Mart release 8.1.0 or 8.1.1, perform this step before you execute the ADD TRANDATA command in the following step.
To create the index, use the following commands:

[+] See commands

Configure the replication source according to the Oracle GoldenGate documentation.
Configure the Oracle RDBMS that hosts the active Info Mart database as a replication source.
In particular, enable supplemental logging at the table level for all tables that are to be replicated to the target database. Use the following command within the GoldenGate SCI, substituting <Info_Mart> with the name of your Info Mart schema:
ggsci> ADD TRANDATA <Info_Mart>.*

Note: It is essential that the ADD TRANDATA command captures all of the changes in the Info Mart database before replication is started. If you have to upgrade Genesys Info Mart in the time window between performing this step and starting replication, repeat this command after you upgrade Genesys Info Mart and before you start replication.

Before you start Oracle GoldenGate processing, copy the Info Mart database from the replication source to the target.
To do so, use the following steps as an example, substituting <Info_Mart> with the name of your Info Mart schema:

[+] See steps

Start Replicat on the target database.
Use the following commands, substituting the following variables:

[+] See variables


[+] See commands

Start Extract and DataPump on the replication source.
Use the following commands, substituting the following variables:

[+] See variables


[+] See commands

Check the GoldenGate ggserr.log file for any reported issues and correct them, if necessary.

After completion of the above tasks, all Info Mart tables that are mapped for replication will be synchronized regularly between the replication source and target databases. For the tables that are excluded from replication, neither data nor database schema changes will be replicated.

This page was last edited on October 5, 2018, at 15:59.
Comments or questions about this documentation? Contact us for support!