Working with Oracle GoldenGate 12c

From Implementation to Troubleshooting

Gavin Powell

• Publisher: Auerbach Publications
• Year: 2019
• ISBN:
  9781351998604
• Edition: 1
• Topic: Computer Science
• Subtopic: Databases
• Index: Computer Science

This book teaches the basics of Oracle GoldenGate, which is a product that is used to simplify the process of Oracle Database Replication. GoldenGate can be used for reporting, failover, high availability, live reporting, data warehousing, and BigData ETL process, as well as connecting to multiple other data sources outside of Oracle Database such as SQL Server, MySQL, Teradata, PostgreSQL, and many others. The purpose of GoldenGate and its popularity is its ability to make the highly complex architecture of database replication into a much more simplistic task. This book teaches the reader how to use Oracle GoldenGate, from installation to troubleshooting.

Contents

Dedication

List of Figures

List of Tables

About the Author

Introduction

Chapter 1 GoldenGate Architecture

1.1 Different Replication Methods

1.1.1 Master-to-Slave Replication

1.1.2 Master-to-Master Replication

1.1.3 GoldenGate Options for Use with Oracle^® Database

1.2 The Architecture of GoldenGate

1.2.1 The Manager Process

1.2.2 The Extract Process

1.2.3 The Replicat Process

1.2.4 The Collector Process

1.2.5 Checkpoints

1.2.6 Extract Files

1.2.7 Groups

1.2.8 The Commit Sequence Number (CSN)

1.2.9 Support for Globalized Character Sets

1.3 So What’s Next?

Chapter 2 Installing GoldenGate

2.1 Pre-Installation Steps

2.2 Downloading and Installing

2.2.1 Downloading GoldenGate Software

2.2.2 Installing GoldenGate Software

2.2.3 Testing GoldenGate Software

2.3 Setting up Oracle Database for GoldenGate

2.3.1 Oracle Transparent Network Substrate (TNS)

2.3.2 Replication Logging

2.4 So What’s Next?

Chapter 3 Configuring GoldenGate

3.1 The Architecture of Capture (Extract) and Apply (Replicat)

3.1.1 Capture Method Architecture

3.1.2 Apply Method Architecture

3.1.3 Mixing Methods of Capture and Apply

3.2 Configuring Classic Capture

3.2.1 Adding Data Pump to the Extract Confi guration

3.2.2 Limitations of Classic Capture

3.3 Configuring Integrated Capture

3.4 Configuring Apply

3.4.1 Limitations of Non-Integrated Apply

3.5 Configuration Limitations for Both Capture and Apply

3.6 Process Group Configuration

3.7 Starting Up Oracle GoldenGate Replication

3.7.1 Deinstall and Rebuild Replication

3.7.2 A Simple Installation of Extract and Replicat

3.8 So What’s Next?

Chapter 4 Basic GoldenGate Administration

4.1 Configuring Credentials for GoldenGate

4.1.1 Identities in the Credential Store

4.1.2 Password Encryption

4.2 Using the GGSCI Command Line Interface

4.2.1 GGSCI Commands

4.2.2 More on the Manager Process

4.2.3 More on the Extract and Replicat Processes

4.2.4 Automation in GGSCI

4.2.5 Working with Parameters and Parameter Files

4.3 GoldenGate Backups

4.4 So What’s Next?

Chapter 5 Loading Data into GoldenGate

5.1 Cold Copying a Database with Data Pump

5.1.1 Recovering with Data Pump up to a System Change Number (SCN)

5.2 Hot Copying a Single Table with SQL*Loader

5.3 Other Load Options

5.4 So What’s Next?

Chapter 6 Applying Replication

6.1 Using GoldenGate for Live Reporting

6.2 Using GoldenGate for a Standby/Failover Database

6.2.1 Implementing Standby for Two Oracle Databases Using GoldenGate

6.3 Using GoldenGate for Data Distribution to Many Targets

6.3.1 Implementing Data Distribution to Two Targets

6.4 Using GoldenGate to Consolidate a Warehouse from Many Sources

6.4.1 Implementing Data Warehouse Consolidation with GoldenGate

6.5 High Availability with Master-to-Master Replication

6.5.1 Implementing Master-to-Master Replication with GoldenGate

6.6 So What’s Next?

Chapter 7 Wrapping It Up

7.1 Deinstalling GoldenGate

7.1.1 Stop the GoldenGate Processes

7.1.2 Removing DDL

7.1.3 Removing Objects

7.1.4 Uninstalling Oracle GoldenGate

7.1.5 Removing GGATE User and Tablespace ...