Pro Oracle GoldenGate for the DBA

by Bobby Curtis

Overview

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 aGoldenGate 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.

Product Details

ISBN-13:	9781484211809
Publisher:	Apress
Publication date:	08/25/2016
Edition description:	1st ed.
Pages:	306
Product dimensions:	7.01(w) x 10.00(h) x (d)

About the Author

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.

Table of Contents

1. Installation, Upgrade, and Removal.-2. Architecture.-3. Basic Replication Configuration.-4. Tuning Oracle GoldenGate.-5. Monitoring Oracle GoldenGate.-6. Data Verification.-7. Advanced Features.-8. Security.-9. Data Integration.-10. GoldenGate Utilities.-11. GoldenGate Studio and Oracle GoldenGate Monitor Agent.-12. Working with Oracle GoldenGate Studio.