Expert Oracle GoldenGate Book

Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication.

The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You'll learn methods for tuning Oracle GoldenGate performance. You'll discover GoldenGate's utility as a migration and extract, transform, load (ETL) tool. You'll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment.

• Explains all aspects of using GoldenGate for replication
• Covers homogeneous, heterogeneous, and bidirectional replication
• Shows the use of GoldenGate for data migration and extract, transform, load (ETL)

What you'll learn

• Install Oracle GoldenGate quickly and painlessly
• Design single- and bi-directional replication solutions
• Apply GoldenGate to high-availability solutions
• Troubleshoot and tune GoldenGate for performance
• Verify data synchronization using GoldenGate Veridata
• Manage and monitor GoldenGate environments using GoldenGate Director

Expert Oracle GoldenGate is for database professionals who need to master the latest in replication technology from Oracle. It is for the Oracle Database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software.

Table of Contents

1. Introduction
2. Installation
3. Architecture
4. Basic Replication
5. Bi-Directional Replication
6. Heterogeneous Replication
7. Tuning Oracle GoldenGate
8. Monitoring Oracle GoldenGate
9. Oracle GoldenGate Veridata
10. Oracle GoldenGate Director
11. Troubleshooting
12. High Availability & Disaster Recovery
13. Zero Downtime Migrations and Upgrades
14. Best Practices