| |
| |
| Acknowledgments | |
| |
| |
| Introduction | |
| |
| |
| |
| Introduction to Oracle GoldenGate 11g and Replication | |
| |
| |
| What Is Replication and Why Use It? | |
| |
| |
| What Kinds of Replication Are There? | |
| |
| |
| Disk-Based Replication | |
| |
| |
| Database Data Replication | |
| |
| |
| Database Object Replication | |
| |
| |
| Oracle Replication: The Past | |
| |
| |
| Oracle Snapshots and Materialized Views | |
| |
| |
| Oracle Advanced Replication | |
| |
| |
| Oracle Streams | |
| |
| |
| Oracle Heterogeneous Replication | |
| |
| |
| Oracle GoldenGate | |
| |
| |
| What's Next? | |
| |
| |
| |
| The Oracle GoldenGate Architecture | |
| |
| |
| Documentation and Information Please | |
| |
| |
| Overview of Databases That Support Oracle GoldenGate | |
| |
| |
| The Oracle GoldenGate Architecture and Processes | |
| |
| |
| The Oracle GoldenGate Manager Process | |
| |
| |
| The Oracle GoldenGate Extract (or Capture) Process | |
| |
| |
| The Oracle GoldenGate Trail Files | |
| |
| |
| The Oracle GoldenGate Data Pump Process | |
| |
| |
| The Oracle GoldenGate Server Collector | |
| |
| |
| The Oracle GoldenGate Apply (Replicat) Process | |
| |
| |
| The Oracle GoldenGate Software Command Interface (GGSCI) | |
| |
| |
| The Oracle GoldenGate Parameter Files | |
| |
| |
| Data Replication and Latency | |
| |
| |
| Compatibility Between Different Versions of GoldenGate | |
| |
| |
| |
| Installing Oracle GoldenGate | |
| |
| |
| Oracle GoldenGate Requirements | |
| |
| |
| Oracle GoldenGate Oracle Database Platforms Supported | |
| |
| |
| Oracle GoldenGate Oracle Database Versions Supported | |
| |
| |
| Oracle GoldenGate Memory Requirements | |
| |
| |
| Oracle GoldenGate Disk Space Requirements | |
| |
| |
| Oracle GoldenGate Network Requirements | |
| |
| |
| The Demonstration Environments We Use in This Book | |
| |
| |
| Download and Set Up Oracle VirtualBox | |
| |
| |
| Creating the Oracle VirtualBox Images Used in This Book | |
| |
| |
| Download and Install Oracle GoldenGate | |
| |
| |
| What Do I Need to Know Before I Download GoldenGate? | |
| |
| |
| How Do I Download GoldenGate? | |
| |
| |
| Installing Oracle GoldenGate | |
| |
| |
| |
| Configuring Oracle GoldenGate | |
| |
| |
| Configuring Oracle GoldenGate After the Initial Install | |
| |
| |
| Configuring the Operating System Environment for GoldenGate | |
| |
| |
| Configuring the Oracle Database GoldenGate User | |
| |
| |
| Configuring for DDL Replication | |
| |
| |
| Configuring to Support Oracle Sequences | |
| |
| |
| Configuring the GoldenGate Directories and Using GGSCI | |
| |
| |
| Information to Collect Before You Architect Your Replication Solution | |
| |
| |
| Information You Will Need to Collect Before You Start | |
| |
| |
| Preparing Your Systems for Operation | |
| |
| |
| Configuration of the Oracle Database for GoldenGate Operations | |
| |
| |
| Configure the Database for Flashback Queries | |
| |
| |
| GoldenGate and Primary Keys | |
| |
| |
| Dealing with Deferred Constraints | |
| |
| |
| Verify That the Database Has Supplemental Logging Enabled | |
| |
| |
| Configuring the GLOBALS Parameter File | |
| |
| |
| Configuration and Administration of the Oracle GoldenGate Manager Process | |
| |
| |
| Configuration of the Oracle GoldenGate Manager Process | |
| |
| |
| Administration of the Oracle GoldenGate Manager Processes | |
| |
| |
| |
| Implementing Oracle GoldenGate One-Way Replication | |
| |
| |
| Preparing for Replication | |
| |
| |
| Introducing the HR Schema | |
| |
| |
| Our Selected Topology | |
| |
| |
| So, What Are We Doing? | |
| |
| |
| Preparing the Target Database for Replication | |
| |
| |
| Configuring the GoldenGate Manager Process | |
| |
| |
| Configuring the GoldenGate Extract Process | |
| |
| |
| Creating the Extract Parameter File | |
| |
| |
| Registering the Extract | |
| |
| |
| Adding the Trail File to GoldenGate and Associating It with the Extract | |
| |
| |
| Administering the Extract Process | |
| |
| |
| Configuring the GoldenGate Data Pump | |
| |
| |
| Creating the GoldenGate Data Pump Extract Parameter File | |
| |
| |
| Registering the GoldenGate Data Pump Extract | |
| |
| |
| Administering the GoldenGate Data Pump Extract Process | |
| |
| |
| Instantiating the Target Database Using GoldenGate | |
| |
| |
| Configure and Register the Initial-Load Extract Process | |
| |
| |
| Configure and Register the Initial-Load Replicat Process | |
| |
| |
| Instantiate the Target Database with the Configured GoldenGate Processes | |
| |
| |
| Configuring the GoldenGate Replicat Process | |
| |
| |
| Creating the Replicat Parameter File | |
| |
| |
| Registering the Replicat Process | |
| |
| |
| Administering the Replicat Process | |
| |
| |
| |
| GoldenGate Multitarget and Cascading Replication | |
| |
| |
| Configuring Multitarget Replication | |
| |
| |
| Configure the GoldenGate Manager Process on the New Target Server | |
| |
| |
| Add the New Target Database to an Existing or New Data Pump Extract | |
| |
| |
| Configuring Cascading Replication | |
| |
| |
| |
| GoldenGate Multimaster Replication | |
| |
| |
| Before You Configure Bidirectional Replication | |
| |
| |
| The Application and Bidirectional Replication | |
| |
| |
| The Trusted Source | |
| |
| |
| Keys Are Important (Also Keeping SKs Unique) | |
| |
| |
| Triggers | |
| |
| |
| Cascaded Deletes | |
| |
| |
| Loops | |
| |
| |
| Conflict Detection and Resolution | |
| |
| |
| Other Bidirectional Replication Issues | |
| |
| |
| Example of Configuring a Bidirectional Replication | |
| |
| |
| Configure the GoldenGate Extract Processes | |
| |
| |
| Configure the GoldenGate Data Pump Extract Processes | |
| |
| |
| Configure the Replicat Process for Both the ORCL.HR Schemas | |
| |
| |
| Instantiate the GOLDENGATE2.ORCL.HR Schema | |
| |
| |
| Create a Conflict Handler | |
| |
| |
| Start Replication in Both Directions | |
| |
| |
| |
| Advanced Features | |
| |
| |
| Advanced Configuration | |
| |
| |
| Checkpoint Tables | |
| |
| |
| Securing Your Environment | |
| |
| |
| Filtering Your Data | |
| |
| |
| Filtering Tables | |
| |
| |
| Filtering Rows | |
| |
| |
| Mapping Column Data | |
| |
| |
| Table-Level Column Mapping | |
| |
| |
| Global Mapping | |
| |
| |
| Executing SQL | |
| |
| |
| SQLEXEC as an Option for TABLE or MAP | |
| |
| |
| sqlexec as a Standalone Statement | |
| |
| |
| Scheduling sqlexec | |
| |
| |
| Configuring for RAC | |
| |
| |
| Where to Install | |
| |
| |
| How to Capture Changes | |
| |
| |
| Synchronizing Nodes | |
| |
| |
| Threads | |
| |
| |
| Connecting | |
| |
| |
| Configuring for ASM | |
| |
| |
| Modify the Listener | |
| |
| |
| Modify the tnsnames.ora File | |
| |
| |
| Modify the Extract Parameter File | |
| |
| |
| DBLOGREADER | |
| |
| |
| Error Handling | |
| |
| |
| |
| Oracle GoldenGate and Oracle Real Application Clusters | |
| |
| |
| Oracle Maximum Availability Architecture (MAA) | |
| |
| |
| Disaster Recovery, High Availability, and Replication | |
| |
| |
| Installing GoldenGate in a RAC Environment | |
| |
| |
| Configuring the Application Virtual IP Address | |
| |
| |
| Creating an Action Script | |
| |
| |
| Clusterware Registration | |
| |
| |
| Basic Administration of the GoldenGate Application | |
| |
| |
| |
| GoldenGate for MySQL | |
| |
| |
| Installing GoldenGate for MySQL | |
| |
| |
| Preparing for the Installation of GoldenGate on a MySQL Database Server | |
| |
| |
| Installing GoldenGate for MySQL on a MySQL Database Server | |
| |
| |
| Oracle to MySQL GoldenGate Replication | |
| |
| |
| Setting Up the MySQL Database | |
| |
| |
| Creating the GoldenGate Schema on MySQL | |
| |
| |
| Performing the Initial Load from Oracle to MySQL | |
| |
| |
| Creating the Definition File | |
| |
| |
| Initial Loading of the MySQL Schema | |
| |
| |
| Creating the Oracle Extract Process and the MySQL Replicat Process | |
| |
| |
| Replicating from MySQL to Oracle | |
| |
| |
| Defining the Objects and Generating the Definitions | |
| |
| |
| Initial Population of the Oracle Table from MySQL Using GoldenGate | |
| |
| |
| Configuring Replication Between MySQL and Oracle | |
| |
| |
| |
| Introducing Oracle GoldenGate for SQL Server | |
| |
| |
| Installing and Configuring Oracle GoldenGate for SQL Server | |
| |
| |
| Hardware Requirements | |
| |
| |
| Windows Server Requirements | |
| |
| |
| SQL Server Requirements and Supported Features | |
| |
| |
| Target Database SQL Server Instance Configuration | |
| |
| |
| Installing Oracle GoldenGate for SQL Server on Windows | |
| |
| |
| Configuration | |
| |
| |
| Configuring the Manager Process | |
| |
| |
| Manager Parameters | |
| |
| |
| Managing Oracle GoldenGate for SQL Server | |
| |
| |
| Database Management Considerations with Oracle GoldenGate for SQL Server | |
| |
| |
| Configuring Basic GoldenGate Replication for SQL Server | |
| |
| |
| Advanced GoldenGate for SQL Server | |
| |
| |
| Configuring Oracle GoldenGate in a Windows Clustering Environment | |
| |
| |
| Maintaining the Transaction Log Secondary Truncation Point When Extract Is Stopped | |
| |
| |
| IDENTITY Property on Columns in Multimaster Configurations | |
| |
| |
| Making DDL Changes to Existing Tables Configured for OGG | |
| |
| |
| The ALTARCHIVELOGDEST Extract Parameter | |
| |
| |
| |
| Monitoring, Troubleshooting, and Performance Tuning GoldenGate | |
| |
| |
| Monitoring Oracle GoldenGate | |
| |
| |
| GUI-Based Tools | |
| |
| |
| GGSCI | |
| |
| |
| Troubleshooting | |
| |
| |
| Common Methodology | |
| |
| |
| Commonly Used Diagnostic Tools | |
| |
| |
| Common Extract Performance and Error Issues | |
| |
| |
| Common Replicat Issues | |
| |
| |
| Hung Processes | |
| |
| |
| Taking It Further | |
| |
| |
| Performance Tuning | |
| |
| |
| Tuning the Initial Load | |
| |
| |
| GoldenGate Lag | |
| |
| |
| Before You Begin | |
| |
| |
| Extract Lag | |
| |
| |
| Pump Lag | |
| |
| |
| Replicat Lag | |
| |
| |
| Parallelization | |
| |
| |
| |
| Oracle GoldenGate Monitor and GoldenGate Director | |
| |
| |
| Oracle GoldenGate Monitor | |
| |
| |
| Oracle GoldenGate Monitor Architecture | |
| |
| |
| Oracle GoldenGate Instance Prep | |
| |
| |
| Using Oracle GoldenGate Monitor Server | |
| |
| |
| Oracle GoldenGate Director | |
| |
| |
| The GoldenGate Director Architecture | |
| |
| |
| |
| Zero-Downtime Upgrades and Migrations Using Oracle GoldenGate | |
| |
| |
| Zero Downtime Methodology | |
| |
| |
| Fallback Option | |
| |
| |
| |
| Oracle GoldenGate Veridata | |
| |
| |
| Veridata Functionality | |
| |
| |
| Configuring and Using Oracle GoldenGate Veridata | |
| |
| |
| Oracle GoldenGate Veridata Web | |
| |
| |
| Running Comparisons on the Command Line | |
| |
| |
| |
| Oracle GoldenGate Integration Options | |
| |
| |
| Using GoldenGate to Create a File for a Database Utility to Use | |
| |
| |
| Oracle GoldenGate for Flat File | |
| |
| |
| Installing Oracle GoldenGate Flat File | |
| |
| |
| The Oracle GoldenGate Flat File Infrastructure | |
| |
| |
| Types of Flat Files That Can Be Created | |
| |
| |
| DSV Files | |
| |
| |
| LDV Files | |
| |
| |
| The User Exit Properties File | |
| |
| |
| The Writer Process | |
| |
| |
| Defining the Writers | |
| |
| |
| Defining the Writer Mode | |
| |
| |
| Defining the Output File Name | |
| |
| |
| Defining Rollover Attributes | |
| |
| |
| Other Writer Output File Property Settings | |
| |
| |
| Configuring File Data Content Properties | |
| |
| |
| Including Meta File in Your Datafile Output | |
| |
| |
| Including Statistics in Your Datafile Output | |
| |
| |
| Including Statistics in Your Datafile Output | |
| |
| |
| Other API Interfaces into GoldenGate | |
| |
| |
| |
| GoldenGate 11.2 New Features | |
| |
| |
| New and Expanded Support for Database Platforms | |
| |
| |
| Globalization | |
| |
| |
| Security | |
| |
| |
| Intelligent Conflict Resolution | |
| |
| |
| Network Performance Improvements | |
| |
| |
| Integrated Capture | |
| |
| |
| GoldenGate and Compressed Data | |
| |
| |
| GoldenGate and Extract Memory | |
| |
| |
| Downstream Capture | |
| |
| |
| Finally: A RAC-Related Change | |
| |
| |
| Index | |