Goldengate

See Also Goldengate Contract

Goldengate [1] is a real time continuous data sychronization solution primarily for Oracle systems but can be used to replicate other databases also.

It has various uses such as real time business intelligence, query offloads, and zero down time upgrades.

At WNA Goldengate is part of the Business Continuity and Disaster Recovery initiative. It is used with the IFS system to replicate the PROD database to three replicated databases. One database is the DR database. This database will be used in the event of disaster rendering the PROD database unusable. The second database is the Business Intelligence database that will allow users to do real time queries and reports without impacting the PROD database. The final data base is the test Goldengate database. This will be used to test upgrades to the the Goldengate database. This database could also be used to replicate problems in the IFS Prod database as well as test bug fixes and customizations.

Usage of Goldengate

To ensure a successful implementation of Goldengate there are a few things to be aware of

• Ensure you are replicating all the correct schemas. In WNA's environment this includes IFSAPP and others. It is possible to exlcude certain tables within the schemas but for simplicity sake this should be avoided.
• Triggers and other background jobs. You need to avoid duplicating processes that have already taken place in the Host system. For instance, if the host system has run a process to generate new orders this does not need to be run again as the orders will have already been generated. A script needs to be created to turn off those triggers in the target system and be turned on if the target system is brought on line.
• If tables are added or changed in the Host system they need to be added to the target system first. Otherwise data will be replicated from the host system without a defined target. This will cause the process to abend.

References

File:Goldengate.pdf Retrieved 04/08/11 Timeline:2010