Working with Oracle GoldenGate 12c
eBook - ePub

Working with Oracle GoldenGate 12c

From Implementation to Troubleshooting

Gavin Powell

Share book
  1. 182 pages
  2. English
  3. ePUB (mobile friendly)
  4. Available on iOS & Android
eBook - ePub

Working with Oracle GoldenGate 12c

From Implementation to Troubleshooting

Gavin Powell

Book details
Book preview
Table of contents
Citations

About This Book

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.

Frequently asked questions

How do I cancel my subscription?
Simply head over to the account section in settings and click on “Cancel Subscription” - it’s as simple as that. After you cancel, your membership will stay active for the remainder of the time you’ve paid for. Learn more here.
Can/how do I download books?
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
What is the difference between the pricing plans?
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
What is Perlego?
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Do you support text-to-speech?
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Is Working with Oracle GoldenGate 12c an online PDF/ePUB?
Yes, you can access Working with Oracle GoldenGate 12c by Gavin Powell in PDF and/or ePUB format, as well as other popular books in Computer Science & Databases. We have over one million books available in our catalogue for you to explore.

Information

Year
2019
ISBN
9781351998604
Edition
1

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

Table of contents