Working with Oracle GoldenGate 12c: From Implementation to Troubleshooting

✍ Scribed by Gavin Powell

• Publisher: Auerbach Publications
• Year: 2019
• Tongue: English
• Leaves: 201
• Edition: 1
• Category: Library

✦ Synopsis

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.

✦ Table of Contents

Cover
Half Title
Title
Copyright
Dedication
Contents
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)s
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 Confi guring 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 Confi guring Classic Capture
3.2.1 Adding Data Pump to the Extract Confi guration
3.2.2 Limitations of Classic Capture
3.3 Confi guring Integrated Capture
3.4 Confi guring Apply
3.4.1 Limitations of Non-Integrated Apply
3.5 Confi guration Limitations for both Capture and Apply
3.6 Process Group Confi guration
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 Confi guring 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 in Oracle Database
7.2 Reinstalling GoldenGate
7.2.1 Restart Oracle Databases
7.2.2 Recreate Tablespace
7.2.3 Reinstall GoldenGate Software
7.2.4 Database-Level Logging and Confi guration
7.2.5 Schema-Level Application Logging
7.2.6 Supporting DDL Replication
7.2.7 Extraction and Application Users
7.2.8 Confi gure and Start the Source
7.2.9 Test Replication
7.2.10 Add New Schemas
7.2.11 Script Only Basic Replication
7.2.12 GoldenGate Silent Installations
7.3 References
7.4 The End
Glossary
Index