Pro Oracle GoldenGate for the DBA

1. Front Matter

   Pages i-xxi

   PDF

2. Installation, Upgrade, and Removal

   • Bobby Curtis

   Pages 1-15

3. Architecture

   • Bobby Curtis

   Pages 17-28

4. Basic Replication Configuration

   • Bobby Curtis

   Pages 29-54

5. Tuning Oracle GoldenGate

   • Bobby Curtis

   Pages 55-77

6. Monitoring Oracle GoldenGate

   • Bobby Curtis

   Pages 79-100

7. Data Verification

   • Bobby Curtis

   Pages 101-186

8. Advanced Features

   • Bobby Curtis

   Pages 187-209

9. Security

   • Bobby Curtis

   Pages 211-215

10. Data Integration

    • Bobby Curtis

    Pages 217-224

11. GoldenGate Utilities

    • Bobby Curtis

    Pages 225-239

12. GoldenGate Studio and Oracle GoldenGate Monitor Agent

    • Bobby Curtis

    Pages 241-268

13. Working with Oracle GoldenGate Studio

    • Bobby Curtis

    Pages 269-301

14. Back Matter

    Pages 303-307

    PDF

Take a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer’s viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and architecture discussion of GoldenGate and the benefits of purchasing GoldenGate from a management perspective. Then the book quickly moves into advanced implementation components associated with GoldenGate. You’ll find many use-cases and instructions throughout the book to help with everything from easy to complex GoldenGate implementations.

An Oracle GoldenGate implementation generally consists of a group project, involving both business and technical resources. Pro Oracle GoldenGate for the DBA provides the viewpoint from the DBA’s vantage point. This approach provides the components of who, what, why, when, and how in defining the implementation and support of a GoldenGate project. The success of most technical projects require the support of multiple resource groups, and Pro Oracle GoldenGate for the DBA supplies the insight for the DBA member to understand the implementation and support process.

• Takes you through justification, installation, and support.
• Provides the DBA perspective toward a successful a result.
• Covers from basic toward increasingly advanced implementations

What You Will Learn

• Understand the core architecture of data replication using Oracle GoldenGate
  
• Implement a one-way setup of a classic capture and an integrated capture and replication
  
• Design, architect and implement a multi-master replication model
  
• Replicate unsupported data types using tokens
  
• Manage and troubleshoot multiple GoldenGate implementations
  
• New features of GoldenGate supported in Oracle 12c

Who this Book is For

Pro Oracle GoldenGate for the DBA is aimed squarely at Oracle database administrators who find themselves involved in GoldenGate integration projects. The book provides the DBA view into such projects, helping database administrators toward successful implementations and solid business results.

• Replication
• Classic Capture
• Integrated Capture
• Multi-master Replication
• Heterogeneous Replication
• GoldenGate Studio

• Winston, USA

  Bobby Curtis

Bobby L. Curtis, MBA is an Oracle ACE Director and specializes in database monitoring and data integration technologies, both aimed at making usability simpler and easier.  Currently he is working as a Senior Technical Consultant focused on implementations and migrations of scalable databases while providing monitoring solutions for these environments.   Bobby is a member of the Independent Oracle User Group (IOUG), Georgia Oracle User Group (GAOUG), and the Rocky Mountain Oracle User Group (RMOUG).  He lives with his wife and three kids in Douglasville, GA.  Bobby is honing his technical skills at Accenture Enkitec Group (www.enkitec.com), and can be followed on twitter at @dbasolved.

Policies and ethics