Revision as of 03:35, February 8, 2013 by Tanyai (talk | contribs)
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.

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.
  • Configure Database Access Points (DAPs) to extract IDB data after Disaster Recovery.
  • Install the Genesys Info Mart Administration Console at the standby site.

The configuration of the standby Genesys Info Mart application must be identical to the application configuration at the active site, with the following exception:

  • To prevent the standby Genesys Info Mart from writing data into the Info Mart database during replication, do not configure the connection from the standby Genesys Info Mart application to the Info Mart DAP at the standby site at this point.

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

  1. 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.
  2. 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.
  3. 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
  4. (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
  5. 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.
  6. 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
  7. Start Replicat on the target database.
    Use the following commands, substituting the following variables:
    [+] See variables
    8. [+] See commands
  8. Start Extract and DataPump on the replication source.
    Use the following commands, substituting the following variables:
    [+] See variables
    9. [+] See commands
  9. 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. This includes any changes to the Info Mart database schema that are made at the replication source.
Comments or questions about this documentation? Contact us for support!