- 182 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
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
Yes, you can cancel anytime from the Subscription tab in your account settings on the Perlego website. Your subscription will stay active until the end of your current billing period. Learn how to cancel your subscription.
No, books cannot be downloaded as external files, such as PDFs, for use outside of Perlego. However, you can download books within the Perlego app for offline reading on mobile or tablet. Learn more here.
Perlego offers two plans: Essential and Complete
- Essential is ideal for learners and professionals who enjoy exploring a wide range of subjects. Access the Essential Library with 800,000+ trusted titles and best-sellers across business, personal growth, and the humanities. Includes unlimited reading time and Standard Read Aloud voice.
- Complete: Perfect for advanced learners and researchers needing full, unrestricted access. Unlock 1.4M+ books across hundreds of subjects, including academic and specialized titles. The Complete Plan also includes advanced features like Premium Read Aloud and Research Assistant.
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.
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.
Yes! You can use the Perlego app on both iOS or Android devices to read anytime, anywhere — even offline. Perfect for commutes or when you’re on the go.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
Please note we cannot support devices running on iOS 13 and Android 7 or earlier. Learn more about using the app.
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
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
- Cover
- Halftitle
- Title Page
- Copyright Page
- Dedication
- Table of Contents