Setting Up Replication
The following task summary provides instructions on how to deploy a standby Genesys Info Mart instance for the purpose of 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:
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.
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.
Note: Starting with release 8.1.4, you can use Genesys Info Mart Manager to perform the administrative and management functions.
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
Substitute the following variables in the configuration file examples: [+] See variables
For configuration instructions, refer to the Oracle GoldenGate documentation.
ADD TRANDATAcommand in the following step.
To create the index, use the following commands: [+] See commands
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.
[+] See steps
[+] 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.logfile 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.