Expert Oracle GoldenGate

  • 5h 4m
  • Ben Prusinski, Richard Chung, Steve Phillips
  • Apress
  • 2011

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

About the Authors

Ben Prusinski is an Oracle Certified Professional (OCP) and database architect with more than 14 years of experience with Oracle data warehouse and Oracle E-Business applications. As a corporate database consultant, Ben has provided services to dozens of Fortune 500 clients. He is an internationally recognized expert in Oracle high availability, performance tuning, database security, and ERP implementations. As a top Oracle expert, Ben received the prestigious Oracle ACE award in 2009 in recognition of his contributions to the Oracle community. As an Oracle GoldenGate Certified Associate, Ben is a popular speaker at major conferences such as Oracle OpenWorld, Chilean Oracle User Group (CLOUG) in Latin America, the Independent Oracle Users Group (IOUG), and Oracle Collaborate OAUG (Oracle Applications User Group). In addition to Oracle consulting for clients, Ben regularly updates his Oracle blog at with the latest database technology tips and information to share with the Oracle community.

Steve Phillips is an Information Systems Architect with Hewlett-Packard Enterprise Services and has been working with computer databases for over twenty-five years. Steve is an Oracle Certified Professional and a past presenter at Oracle Openworld and IOUG. Steve holds a master's degree in Information Systems from the University of Texas at Dallas and currently lives in Plano, Texas.

Richard Chung has 19 years of hands-on experiences in all aspect of IT environments. His recent focus is in the Business Intelligence area, such as Reporting, ETL, and Data architecture. Richard is Principal of BI and System Architect at Starwood Hotels and Resorts, where he built the current data warehouse and reporting applications; he also wrote highly sophisticated search engines and designed the ETL to populate the active data warehouse with near real-time data. Golden Gate is used to synchronize the critical business data around different cities in the US. Before Starwood, he worked at a startup, JP Morgan Chase, and Ernst & Young.

In this Book

  • Introduction
  • Installation
  • Architecture
  • Basic Replication
  • Advanced Features
  • Heterogeneous Replication
  • Tuning
  • Monitoring Oracle GoldenGate
  • Oracle GoldenGate Veridata
  • GoldenGate Director
  • Troubleshooting Oracle GoldenGate
  • Disaster Recovery Replication
  • Zero-Downtime Migration Replication
  • Tips and Tricks