SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK MASTERING ORACLE GOLDENGATE
SUMMARY
-
Items Found: 564
- ontents at a Glance
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: Getting Started
- Chapter 1: Introduction to Oracle GoldenGate (OGG)
- Chapter 2: Architecture
- Chapter 3: Oracle GoldenGate Pre-installation Tasks
- Chapter 4: Installing Oracle GoldenGate
- Chapter 5: Classic vs Integrated Capture and Apply
- Chapter 6: Capturing DDL Changes
- Chapter 7: Performing the Initial Load
- Part II: Advanced Confi gurations
- Chapter 8: Oracle GoldenGate Commands
- Chapter 9: Advanced Processing
- Chapter 10: Advanced Features
- Chapter 11: Upgrading Oracle GoldenGate
- Chapter 12: Bidirectional Replication
- Part III: Managing Oracle GoldenGate
- Chapter 13: Oracle GoldenGate Management Pack Part I
- Chapter 14: Oracle GoldenGate Management Pack Part II
- Chapter 15: Ensuring Data Integrity with Veridata
- Chapter 16: Troubleshooting Oracle GoldenGate
- Chapter 17: Using Oracle GoldenGate Adapters
- Part IV: Exploring GoldenGate Possibilities
- Chapter 18: Confi guring Oracle GoldenGate HA
- Chapter 19: Oracle GoldenGate for Big Data
- Chapter 20: Oracle GoldenGate for Non-Oracle Databases
- Chapter 21: Oracle GoldenGate for the Cloud
- Chapter 22: Oracle GoldenGate Studio
- Chapter 23: Undoing Data Changes
- Part V: Appendixes
- Chapter 24: Appendix A: OGG Heartbeat and Checkpoints
- Chapter 25: Appendix B: Preparing for Interviews
- Chapter 26: Appendix C: Get Certifi ed
- About the Author
- About the Technical Reviewer
- Acknowledgments
- Introduction
- Part I: Getting Started
- Chapter 1: Introduction to Oracle GoldenGate (OGG)
- What’s So Magical About Oracle GoldenGate?
- Types of Replication
- Available Replication Options
- Advantages of Oracle GoldenGate
- When to Use Oracle GoldenGate?
- Oracle GoldenGate vs Streams
- Oracle GoldenGate vs Data Guard
- Oracle GoldenGate vs SharePlex
- Oracle GoldenGate 12c New Features
- Summary
- Chapter 2: Architecture
- Overview of the Components
- Extract
- Data Pump
- Replicat
- Trails
- Collector
- Manager
- Checkpoints
- Support for Non-Oracle Databases
- Supported Topologies
- Unidirectional Replication
- Bidirectional Replication
- One-to-Many Replication
- Many-to-One Replication
- Peer-to-Peer Replication
- Summary
- Chapter 3: Oracle GoldenGate Pre-installation Tasks
- Memory Requirements
- Disk Space Requirements
- Network Requirements
- Confi guring Your Database and Server for Oracle GoldenGate
- Enable Logging for Oracle Databases
- Enable Logging for Sybase Databases
- Enable Logging for Microsoft SQL Server Databases
- Supported Data Types
- Supported Data Types for Oracle Databases
- Supported Data Types for SYBASE Databases
- Supported Data Types for MySQL Databases
- Supported Data Types for SQL Server Databases
- Supported Data Types for DB2 Databases on LUW
- Supported Data Types for DB2 Databases on z/OS
- Supported Operations
- Database Operations Captured for Oracle Databases
- Database Operations Captured on Sybase Databases
- Database Operations Captured on MySQL Databases
- Database Operations Captured on SQL Server Databases
- Database Operations Captured on DB2 Databases for LUW
- Database Operations Captured on Sybase Databases for z/OS
- Designing Your GoldenGate Replication Setup
- Why Choose Standard Naming Conventions?
- Naming Capture and Delivery Process
- Know Your Application
- Database Privileges for GoldenGate Users
- OGG User Permissions in Oracle Databases
- OGG User Permissions in Sybase Databases
- OGG User Permissions in IBM DB2 Databases
- OGG User Permissions in MySQL Databases
- OGG User Permissions in Teradata Databases
- Summary
- Chapter 4: Installing Oracle GoldenGate
- Download the Installer
- Setting Up Environmental Variables
- Setting Up Database Logging
- Setting Up User Privileges
- Installing Oracle GoldenGate on Unix/Linux
- Step 1: Log In as the Linux Superuser
- Step 2: Navigate to the GoldenGate Directory
- Step 3: Copy or FTP the GoldenGate Software File from the Local System or Remote Server
- Step 4: Locate the Installer
- Step 5: Begin Installation
- Step 6: Execute GGSCI
- Step 7: Create Subdirectories
- Step 8: Confi gure the Manager Port
- Step 9: Start/Stop the Manager
- Step 10: Check Supplemental Logging for the Database
- Step 11: Add Extracts
- Step 12: Install Oracle GoldenGate on the Target Machine
- Step 13: Add the Replicat
- Step 14: Create the Defi nition File
- Step 15: Enable Supplemental Logging for Oracle GoldenGate
- Step 16: Initial Data Synchronization
- Step 17: Start the Manager,Extract,and Replicat,and Test the Result
- Silent Installation
- Parameters in the Response File
- OGG Subdirectories
- Handling Character Set
- Using CHARSET
- Using Escape Sequences
- Using SOURCECHARSET
- Using NLS_LANG
- Summary
- Chapter 5: Classic vs Integrated Capture and Apply
- OGG Capture Process
- Classic Capture
- Integrated Capture
- Integrated Capture Modes
- OGG Apply Process
- Nonintegrated Apply
- Integrated Apply
- Support for Multitenant Databases
- Implementing Classic and Integrated Captures
- Creating a Classic Capture
- Creating an On-Source Integrated Capture
- Creating an Integrated Capture Using a Downstream Mining Database
- Monitoring an Integrated Capture
- Upgrading Classic Capture Mode to Integrated Capture Mode
- Creating a Classic Capture
- Upgrading to an Integrated Capture
- Implementing Classic and Integrated Apply
- Creating a Classic Apply
- Creating an Integrated Apply
- Capture and Apply Modes,Mix and Match
- Coordinated Replicat
- Summary
- Chapter 6: Capturing DDL Changes
- What Is DDL Replication?
- Types of DDL Replication
- Limitations with DDL Replication
- DDL Scope
- How Does DDL Replication Work?
- On the Source Machine
- On the Target Machine
- DDL Capture in Classic Capture Mode
- An Example of Classic Capture DDL
- DDL Capture in Integrated Capture Mode
- Selective DDL Replication with an Oracle Source DB
- Selective DDL Replication Using DDLAUXaddRule()
- Selective DDL Replication Using the DDL Parameter
- Using DUMPDDL
- DDL Replication in Active-Active Mode (Bidirectional Replication)
- DDL Replication in a Cascading Replication Setup
- DDL Replication in a Heterogeneous Environment
- Summary
- Chapter 7: Performing the Initial Load
- Preparing for the Initial Load
- Initial Load Using the Database Utility
- Initial Load Using SQLLOADER
- Initial Load Using the Direct Load Method
- Initial Load Using BULKLOAD to sqlloader
- Initial Load Example
- Summary
- Part II: Advanced Confi gurations
- Chapter 8: Oracle GoldenGate Commands
- Data Transformation Using Column Conversion Functions
- GGSCI Commands
- Native Non-GGSCI Commands and Utilities
- DEFGEN
- KEYGEN
- LOGDUMP
- Summary
- Chapter 9: Advanced Processing
- Data Transformation in Oracle GoldenGate
- Data Filter Methods
- Data Transformation Methods
- Using COLMAP for Column Mapping
- Data Transformation Examples
- Using COLMATCH
- OGG User Tokens
- User Exits
- SQLEXEC
- Using SQLEXEC as a Parameter to a TABLE or MAP Statement
- Using SQLEXEC to Run Stored Procedures
- Using SQLEXEC to Run as a Stand-Alone Parameter
- Macros in Oracle GoldenGate
- Oracle GoldenGate Auditing
- Summary
- Chapter 10: Advanced Features
- Collision Handling
- HANDLECOLLISION
- CDR for Active-Active Replication
- Supported Data Types for CDR
- Types of Confl icts
- Confl icts During an INSERT Operation
- Confl icts During an UPDATE Operation
- Confl icts During a DELETE Operation
- CDR Parameters
- CDR Example
- Oracle GoldenGate Performance Tuning
- Best Practices for Confi guring Your Oracle GoldenGate Replication Environment
- Determining the Current Performance Statistics
- Confi gure Your Database
- Enable Supplemental Logging
- PASSTHRU or NOPASSTHRU
- Tuning TCPBUFSIZE and TCPFLUSHBYTES
- Batch Transactions
- Use Compression
- Streams Pool for Integrated Extract and Replicat
- RANGE Splitting
- Encryption and Security
- Encrypting Database Passwords
- Generating a Custom Encryption Key
- Wallet and a Master Key
- Steps for Creating a Wallet and Master Key
- Renew the Master Key
- Encrypt and Decrypt Trail Files
- Encrypt Data Sent Over a Network
- Using an Oracle GoldenGate Credential Store
- Summary
- Chapter 11: Upgrading Oracle GoldenGate
- Download the Patch
- Install the Patch
- Pre-upgrade Tasks
- Upgrading Oracle GoldenGate on the Source
- Take a Backup
- Install the New Version of GoldenGate
- Convert Supplemental Log Group Version
- Verify the Upgrade
- Upgrading Oracle GoldenGate on the Target
- Take a Backup
- Install the New Version of GoldenGate
- Upgrade the Checkpoint Table
- Verify the Upgrade
- Post-upgrade Tasks
- Start GoldenGate and Monitor Replication
- Summary
- Chapter 12: Bidirectional Replication
- Key Points Before Setting Up OGG Bidirectional Replication
- Handling Data Loopbacks
- Handling Data Loopbacks in Oracle Databases
- Handling Data Loopbacks in All Supported Databases
- Handling Data Loopbacks in Teradata Databases
- Handling Data Loopbacks by Identifying Replicat Transactions
- CDR in Bidirectional Replication
- Setting Up OGG Bidirectional Replication
- Adding Confl ict Detection and Resolution
- CDR When Machine A is a Trusted Source and Always Wins
- CDR When Both Sites Are Equally Trusted
- DBFS Confi guration for OGG Bidirectional Replication
- Step 1: Install the Patch for bug-9651229
- Step 2: Confi gure DBFS Sequences
- Step 3: Create the New DBFS File Systems for OGG Replication
- Step 4: Confi gure the Extract/Replicat Processes
- Summary
- Part III: Managing Oracle GoldenGate
- Chapter 13: Oracle GoldenGate Management Pack Part I
- Oracle GoldenGate Monitor
- Installation Overview
- Install Oracle WebLogic Server
- Install the Oracle GoldenGate Monitor Server
- System Requirements
- Download the Software
- Installation
- Create the OGG Monitor Repository Using RCU
- Create the WebLogic Server Domain Using the Confi guration Wizard
- Confi gure the OGG Monitor Server
- Confi gure the JMX Server Properties
- SMTP,SNMP,and CLI Alert Properties
- Start the OGG Monitor Server
- Start the OGG Monitor Console
- Install the Oracle GoldenGate Monitor Agent
- Create the OGG Monitor Agent Instances
- Confi gure the OGG Monitor Agent Instances
- Confi gure the OGG Monitor Agent for the OGG Monitor Server
- Confi gure the OGG Monitor Agent When Using the OEM Plug-in for Oracle GoldenGate
- Create a Wallet When Using the OGG Monitor
- Create a Wallet When Using the OGG OEM Plug-In
- Enable Monitoring
- Start the OGG Monitor Agent
- Summary
- Chapter 14: Oracle GoldenGate Management Pack Part II
- Oracle GoldenGate Enterprise Manager Plug-In
- Installing the OGG Plug-in for EM
- System Requirements
- Downloading the Plug-In
- Deploying the Plug-In
- Creating an Oracle Wallet
- Confi guring the OGG Instance to Run with OEM
- Starting the OGG Instance
- Oracle GoldenGate Director
- OGG Director Server
- OGG Director Database
- OGG Director Web
- OGG Director Client
- OGG Director Administrator
- Why Use the OGG Director?
- Installing the OGG Director Server
- System Requirements
- Downloading the Software
- Installing the Server
- Using the GUI Installer
- Using Command-Line Installation
- Start and Stop the OGG Director Server
- Installing the OGG Director Client
- System Requirements
- Downloading Software
- Installing the Client
- Starting the OGG Director Client
- Starting the OGG Director Administrator
- Adding,Changing,and Deleting User Accounts
- Adding the OGG Data Source
- Confi guring the OGG Monitor Agent
- Viewing and Confi guring the Monitor Settings
- Starting the OGG Director Web
- Managing Oracle GoldenGate Using Custom Scripts
- Monitoring the Stopped Manager and Stopped/Abended Extract/Replicat Processes
- Summary
- Chapter 15: Ensuring Data Integrity with Veridata
- Why Use OGG Veridata?
- How Does It Work?
- Installation Overview
- System Requirements
- Installing the OGG Veridata Server
- Download the Software
- Installation
- Create the OGG Veridata Repository Using RCU
- Create an Oracle WebLogic Domain for OGG Veridata
- Start Veridata Managed Server
- Install the OGG Veridata Agent
- Deploy the OGG Veridata Agent
- Start and Stop the Veridata Agent
- Creating and Running OGG Veridata Compare Jobs
- Using the Veridata CLI
- Executing Vericom Commands
- Vericom Exit Status
- Running a Job Using Vericom
- Uninstalling OGG Veridata
- Summary
- Chapter 16: Troubleshooting Oracle GoldenGate
- Types of Failure
- Where to Look for Errors?
- OGG Error Log File
- OGG Process Report File
- OGG Process Discard File
- Troubleshooting Using the LOGDUMP Utility
- Troubleshooting Using SHOWSYNTAX
- Performing a Sanity Check
- Troubleshooting Examples: Issues with the Extract Processes
- Extract Abended Due to Privilege Issue
- Extract Abended/Stopped Due to Disk Space Full
- Extract Abended Due to Network Communication Error
- Extract Abended Due to Memory Allocation Error
- Extract Abended Due to ORA-03135
- Troubleshooting Examples: Issues with Replicat Processes
- Replicat Abended/Stopped Due to Missing Checkpoint Table
- Replicat Abended/Stopped Due to Corrupt Checkpoint Table or Missing Data in Checkpoint Table
- Replicat Abended Due to Table Structure or Data Inconsistency Error
- Replicat Abended Due to Error Processing DDL Statement
- Replicat Abended Due to Table Not Present in Target Schema
- Replicat Abended Due to Discard File Full
- Troubleshooting Examples: Data Sync Issues
- Troubleshooting Examples: DDL Capture Issue
- Troubleshooting Examples: Trail Files Corruption
- Corrupt Trail on the Source
- Corrupt Trail on the Target
- Using LOGDUMP to Point the Replicat to a Good RBA
- Using SKIPTRANSACTION
- Error Handling in Oracle GoldenGate
- Summary
- Chapter 17: Using Oracle GoldenGate Adapters
- Generating Flat Files in Real Time
- Overview of Tasks
- Downloading OGG Application Adapters
- Installing the OGG Application Adapter
- Viewing the Sample Files
- Creating the OGG User and Role
- Preparing the Database for Flat-File Extraction
- Adding a Checkpoint Table
- Generating the Table Defi nitions
- Creating the Flat-File Adapter Properties File
- Creating the Primary Extract
- Creating the User Exit Extract
- Starting the Extracts
- Verifying Flat Files
- Flat-File Adapter Properties
- Troubleshooting Your Flat-File Confi guration
- OGG for JMS Messaging
- JMS Delivery
- Implementation Overview for JMS Delivery
- How Does It Work?
- Confi guring the Primary and Data Pump Extracts on the Source Database Server
- Confi guring Data Integration on the Target Server
- JMS Capture
- Implementation Overview for JMS Capture
- How Does It Work?
- Confi guring the VAM Extract
- Confi guring the VAM Properties File
- Creating a Defi nition File for JMS Message
- Confi guring the Data Pump Extract
- Confi guring the Replicat on the Target Server
- Summary
- Part IV: Exploring GoldenGate Possibilities
- Chapter 18: Confi guring Oracle GoldenGate HA
- HA Using Oracle Clusterware
- Oracle Clusterware for OGG
- Virtual IP
- Setting Up the Oracle ACFS File System
- Installing Oracle GoldenGate HA
- Confi guring OGG HA
- Step 1: Create a Minimum of a Two-Node System with Oracle GoldenGate
- Step 2: Create a VIP for the Oracle GoldenGate Application
- Step 3: Create the Agent Script
- Step 4: Add a Clusterware Resource for the Oracle GoldenGate Application
- Step 5: Start the Resource Using Oracle Clusterware
- Step 6: Manage the Application
- Step 7: Test the Failover
- Summary
- Chapter 19: Oracle GoldenGate for Big Data
- Downloading Oracle GoldenGate for Big Data
- Installing Oracle GoldenGate for Big Data
- Running the OGG Java Adapter with the Replicat Process
- Running the OGG Java Adapter with the Extract Process
- Oracle GoldenGate Adapter for Apache Flume
- Flume Source
- Flume Channel
- Flume Sink
- Build the Flume Adapter
- Download and Install Maven
- Pre-checks
- Build the OGG Adapter for Flume
- Confi gure the OGG Adapter for Flume
- Set Up Flume
- Create the Replicat Process
- Start the OGG Adapter for Flume
- Flume Adapter Properties
- Oracle GoldenGate Big Data Adapter for HDFS
- Build the HDFS Adapter
- Download and Install Maven
- Pre-checks
- Build the OGG Adapter for HDFS
- Confi gure the OGG Adapter for HDFS
- Set Up HDFS
- Create the Replicat Process
- Start the OGG Adapter for HDFS
- HDFS Adapter Properties
- Oracle GoldenGate Adapter for Hive
- Build the Hive Adapter
- Download and Install Maven
- Pre-checks
- Build the OGG Adapter for Hive
- Confi gure the OGG Adapter for Hive
- Set Up Hive
- Create a Replicat Process
- Create Tables in Hive
- Query Hive for Data
- Start the OGG Adapter for Hive
- Hive Adapter Properties
- Oracle GoldenGate Adapter for HBase
- Build the HBase Adapter
- Download and Install Maven
- Pre-checks
- Build the OGG Adapter for HBase
- Confi gure the OGG Adapter for HBase
- Set Up HBase
- Create the Replicat Process
- Start the OGG Adapter for HBase
- HBase Adapter Properties
- Summary
- Chapter 20: Oracle GoldenGate for Non-Oracle Databases
- OGG for Sybase to Sybase Replication
- OGG for Sybase to Oracle Replication
- OGG for MySQL to MySQL Replication
- OGG for Oracle to MySQL Replication
- OGG for DB2 to Oracle Replication
- OGG for MS SQL Server to Oracle Replication
- Summary
- Chapter 21: Oracle GoldenGate for the Cloud
- GGCS Architecture
- Components of GGCS
- Obtaining GGCS
- Create the Oracle Cloud Account
- Create an SSH Key Pair
- Create the Oracle Database Cloud – DBaaS Instance
- Create a GGCS Instance
- SOCKS5 Proxy
- Creating the SOCKS5 Proxy on the Local Server
- Creating the SOCKS5 Proxy on a DMZ Server
- Replication Confi gurations Using GGCS
- On-Premise to Cloud Replication
- Cloud to Cloud Replication
- Cloud to On-Premise Replication
- Support for a Non-Oracle Cloud
- Summary
- Chapter 22: Oracle GoldenGate Studio
- Architecture
- Install and Confi gure OGG Studio
- Install the Oracle GoldenGate Instance
- Install the OGG Monitor Agent
- Install Oracle GoldenGate Studio
- Install the OGG Studio Repository
- Launch OGG Studio
- Summary
- Chapter 23: Undoing Data Changes
- Supported Databases
- Limitations of the OGG Reverse Utility
- Oracle Database
- Sybase Database
- SQL Server
- IBM DB2
- When Do You Need to Use the Oracle GoldenGate Reverse Utility?
- How Does It Work?
- OGG Reverse Utility Steps Overview
- Summary
- Part V: Appendixes
- Chapter 24: Appendix A: OGG Heartbeat and Checkpoints
- Steps to Set Up a Heartbeat Process
- Create Users
- Create Tables
- Add Supplemental Logging
- Create a Job to Update the HEARTBEAT Table
- Check the Job Status
- Confi gure the Extract
- Confi gure the Data Pump
- Confi gure the Replicat
- Additional Scripts
- Adding the Heartbeat Table in Oracle GoldenGate 122
- OGG Checkpoints
- Checkpoint Storage Location
- Creating the OGG Checkpoint Table
- Troubleshooting the Checkpoint Table
- Chapter 25: Appendix B: Preparing for Interviews
- The Basics
- Advanced
- Oracle GoldenGate 12c
- Performance and Security
- Troubleshooting
- Oracle GoldenGate GUI Tools
- Miscellaneous
- Chapter 26: Appendix C: Get Certifi ed
- Steps to Get Certifi ed
- Exam Topics
- How to Schedule an Exam?
