Mastering Oracle GoldenGate

Master Oracle GoldenGate technology on multiple database platforms using this step-by-step implementation guide. Learn about advanced features to use in building a robust, high-availability replication system. Provided are detailed illustration of Oracle GoldenGate concepts, GoldenGate tools and add-ons, as well as illustrative examples. The book covers Oracle GoldenGate for Oracle database, and also discusses setup and configuration for other common databases such as IBM DB2, SYBASE ASE, MySQL, and Microsoft SQL Server.

The technology landscape is fast-changing, and Mastering Oracle GoldenGate stays current by covering the new features included in Oracle GoldenGate 12c. The book covers both classic capture and integrated capture, as well as delivery. Also covered are Oracle GoldenGate security and performance tuning, to keep your system secure and performing at its best. You will learn to monitor your GoldenGate system using tools that come with Oracle GoldenGate management pack, as well as using shell scripts. Troubleshooting is well-illustrated with examples:

• Covering Oracle GoldenGate technology across common database brands
• Discussing high-performing and secure replication environments
• Speaking to replication in Big Data and cloud computing environments

What You Will Learn

• Implement Oracle GoldenGate for real time replication
• Secure and tune your replication environment for high performance
• Administer your Oracle GoldenGate environment
• Learn troubleshooting approaches with help of examples
• Learn and make use of GoldenGate Management Pack and its API
• Feed live data into Big Data and cloud-based systems

Who This Book Is For

Mastering Oracle GoldenGate is for database professionals who have chosen to ride the Oracle GoldenGate roller coaster for real-time replication solutions. The book is for beginners as well as professionals who are willing to master the leading replication technology in the industry. It is an excellent choice for professionals who are implementing or maintaining Oracle GoldenGate replication environments on any of the major database management system platforms.

Table of Contents

Part I: Getting Started
Chapter 1: Introduction to Oracle GoldenGate (OGG)
Chapter 2: Architecture
Chapter 3: Oracle GoldenGate Pre-installation Tasks
Chapter 4: Installing Oracle GoldenGate
Chapter 5: Classic vs. Integrated Capture and Apply
Chapter 6: Capturing DDL Changes
Chapter 7: Performing the Initial Load

Part II: Advanced Configurations
Chapter 8: Oracle GoldenGate Commands
Chapter 9: Advanced Processing
Chapter 10: Advanced Features
Chapter 11: Upgrading Oracle GoldenGate
Chapter 12: Bidirectional Replication

Part III: Managing Oracle GoldenGate
Chapter 13: Oracle GoldenGate Management Pack Part I
Chapter 14: Oracle GoldenGate Management Pack Part II
Chapter 15: Ensuring Data Integrity with Veridata
Chapter 16: Troubleshooting Oracle GoldenGate
Chapter 17: Using Oracle GoldenGate Adapters

Part IV: Exploring GoldenGate Possibilities
Chapter 18: Configuring Oracle GoldenGate HA
Chapter 19: Oracle GoldenGate for Big Data
Chapter 20: Oracle GoldenGate for Non-Oracle Databases
Chapter 21: Oracle GoldenGate for the Cloud
Chapter 22: Oracle GoldenGate Studio
Chapter 23: Undoing Data Changes

Part V: Appendixes
Chapter 24: Appendix A: OGG Heartbeat and Checkpoints
Chapter 25: Appendix B: Preparing for Interviews
Chapter 26: Appendix C: Get Certified