Oracle Goldengate 11g Complete Cookbook


Oracle Goldengate 11g Complete Cookbook
eBook: $41.99
Formats: PDF, PacktLib, ePub and Mobi formats
$35.69
save 15%!
Print + free eBook + free PacktLib access to the book: $111.98    Print cover: $69.99
$69.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Various recipes that will help you to set up Goldengate in various environments
  • Practical examples of Goldengate management tasks
  • Step by step instructions with various examples and scripts

Book Details

Language : English
Paperback : 362 pages [ 235mm x 191mm ]
Release Date : September 2013
ISBN : 1849686149
ISBN 13 : 9781849686143
Author(s) : Ankur Gupta
Topics and Technologies : All Books, Enterprise Products and Platforms, Cookbooks, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Installation and Initial Setup
Chapter 2: Setting up GoldenGate Replication
Chapter 3: DDL Replication and Initial Load
Chapter 4: Mapping and Manipulating Data
Chapter 5: Oracle GoldenGate High Availability
Chapter 6: Monitoring, Tuning and Troubleshooting GoldenGate
Chapter 7: Advanced Administration Tasks – I
Chapter 8: Advanced Administration Tasks – Part II
Chapter 9: GoldenGate Veridata, Director, and Monitor
Index
  • Chapter 1: Installation and Initial Setup
    • Introduction
    • Installing Oracle GoldenGate in a x86_64 Linux-based environment
    • Installing Oracle GoldenGate in a Windows environment
    • Enabling supplemental logging in the source database
    • Supported datatypes in Oracle GoldenGate
    • Preparing the source database for GoldenGate setup
    • Preparing the target database for GoldenGate setup
    • Setting up a Manager process
    • Setting up a Classic Capture Extract process
    • Setting up an Integrated Capture Extract process
    • Setting up a Datapump process
    • Setting up a Replicat process
    • Chapter 2: Setting up GoldenGate Replication
      • Introduction
      • Setting up a simple GoldenGate replication configuration between two single node databases
      • Setting up a GoldenGate replication with multiple process groups
      • Configuring an Extract process to read from an Oracle ASM instance
      • Setting up a GoldenGate replication between Oracle RAC databases
      • Determining the size of trail file areas
      • Verifying the data transfer on the target system
      • Generating encryption keys
      • Encrypting database user passwords
      • Encrypting the trail files
      • Setting up a GoldenGate replication between tables with different structures using defgen
      • Chapter 3: DDL Replication and Initial Load
        • Introduction
        • Performing an initial setup required for GoldenGate DDL replication
        • Setting up a GoldenGate DDL replication and verifying the changes
        • Performing an initial load using GoldenGate
        • Performing an initial load using an extract file to the GoldenGate's replicat method
        • Loading data using trail files to the Replicat process method
        • Loading data with files to the database utility method
        • Loading data with the GoldenGate direct load method
        • Loading data with bulk load to the SQL loader method
        • Chapter 4: Mapping and Manipulating Data
          • Introduction
          • Setting up a GoldenGate replication with mapping between different columns
          • Adding custom fields for a replicated record using tokens
          • Adding custom fields to a replicated record using SQLEXEC
          • Filtering the records using the FILTER and WHERE clause
          • Mapping the changes to a target table and storing the transaction history in a history table
          • Creating a GoldenGate configuration to run a Shell script when an end-of-day processing record is replicated
          • Creating an exception handler to record the erroneous transactions in a GoldenGate configuration
          • Chapter 5: Oracle GoldenGate High Availability
            • Introduction
            • Choosing a GoldenGate high availability option
            • Creating a highly available GoldenGate configuration using Oracle Clusterware and ACFS
            • Creating a highly available GoldenGate configuration using Oracle Clusterware and OCFS2
            • Creating a highly available GoldenGate configuration using Oracle Clusterware and DBFS
            • Manually switching over Oracle Clusterware-based configuration to the other node
            • Automatic failover of a DBFS-based configuration
            • Creating a set of parallel load balanced, highly available GoldenGate configurations using Oracle Clusterware and DBFS
            • Chapter 6: Monitoring, Tuning and Troubleshooting GoldenGate
              • Introduction
              • Steps to configure a BATCHSQL mode
              • Splitting the replication load into multiple process groups for optimal performance
              • Optimizing the network settings for a GoldenGate configuration
              • Performing a healthcheck of a live GoldenGate configuration
              • Script to perform a regular scheduled healthcheck of a live GoldenGate configuration
              • Steps to measure throughput of a GoldenGate configuration
              • Steps to re-instantiate a failed GoldenGate configuration
              • Steps to implement a Heartbeat mechanism for the GoldenGate replication
              • Chapter 7: Advanced Administration Tasks – I
                • Introduction
                • Upgrading Oracle GoldenGate binaries
                • Table structure changes in GoldenGate environments with similar table definitions
                • Table structure changes in GoldenGate environments with different table definitions
                • Resolving GoldenGate errors using the logdump utility
                • Undoing the applied changes using the reverse utility
                • Creating an Integrated Capture with a downstream database for compressed tables
                • Chapter 8: Advanced Administration Tasks – Part II
                  • Introduction
                  • Creating a GoldenGate configuration with a consistent state Behind the target database
                  • Replicating data from an active standby database in Archivelog mode only
                  • Migrating from an Oracle Streams environment to Oracle GoldenGate
                  • GoldenGate Administration role separation from the DBA team
                  • Cross RDBMS replication using GoldenGate
                  • Creating a multimaster GoldenGate replication configuration
                  • Chapter 9: GoldenGate Veridata, Director, and Monitor
                    • Introduction
                    • Setting up the Oracle GoldenGate Monitor server
                    • Setting up Oracle GoldenGate Monitor Agents
                    • Installing Oracle GoldenGate Director
                    • Installing and using Oracle GoldenGate Director Client to manage the GoldenGate instances
                    • Steps to set up the GoldenGate monitoring using OEM 12c
                    • Steps to install Oracle GoldenGate Veridata
                    • Steps to compare data between the source and target environment using Oracle GoldenGate Veridata

                    Ankur Gupta

                    Ankur Gupta is an Oracle Database Consultant based in London. He has a Master's degree in Computer Science. He started his career as an Oracle developer and later on moved into database administration. He has been working with Oracle Technologies for over 11 years in India and the UK. Over the last 6 years, he has worked as an Oracle Consultant with some of the top companies in the UK in the areas of investment banking, retail, telecom and media. He is an Oracle Certified Exadata, GoldenGate Specialist, and OCP 11g DBA. His main areas of interest are Oracle Exadata, GoldenGate, Dataguard, RAC, and Linux. Outside the techie world, he is an avid cook, photographer, and enjoys travelling.
                    Sorry, we don't have any reviews for this title yet.

                    Submit Errata

                    Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                    Sample chapters

                    You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                    Frequently bought together

                    Oracle Goldengate 11g Complete Cookbook +    Governance, Risk, and Compliance Handbook for Oracle Applications =
                    50% Off
                    the second eBook
                    Price for both: $38.24

                    Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                    What you will learn from this book

                    • Configure DML and DDL Goldengate replication
                    • Tune and Troubleshoot Goldengate replication
                    • Cross Platform replication using Goldengate
                    • Monitor Goldengate Replication using OEM 12c
                    • What to do when GoldenGate replication breaks
                    • Reverse changes applied by Goldengate
                    • High Availability Setup for Goldengate
                    • Learn about GoldenGate Veridata and GoldenGate Director
                    • Migrate Oracle Streams environment to Goldengate

                    In Detail

                    Oracle Goldengate 11g Complete Cookbook is your complete guide to all aspects of Goldengate administration. The recipes in this book will teach you how to setup Goldengate configurations for simple and complex environments requiring various filtering and transformations. It also covers various aspects of tuning and troubleshooting the replication setups using exception handling, custom fields, and logdump utility.

                    The book begins by explaining some basic tasks like Installation and Process groups setup. You will then be introduced to some further topics including DDL replication and various options to perform Initial Loads. You will then learn some advanced administration tasks such as Multi Master replication setup and conflict resolution. Further recipes, contain the cross platform replication and high availability options for Goldengate.

                    Approach

                    Oracle Goldengate 11g Complete Cookbook follows the Cookbook style. Each recipe provides step by step instructions with various examples and scripts. This book provides the necessary information to successfully complete most of the possible administration tasks.

                    Who this book is for

                    Oracle Goldengate 11g Complete Cookbook is aimed at Database Administrators, Architects, and Middleware Administrators who are keen to know more about Oracle Goldengate. Whether you are handling Goldengate environments on a day-to-day basis, or using it just for migration, this book provides the necessary information required to successfully complete your administration tasks. The reader is expected to have some knowledge of Oracle databases.

                    Code Download and Errata
                    Packt Anytime, Anywhere
                    Register Books
                    Print Upgrades
                    eBook Downloads
                    Video Support
                    Contact Us
                    Awards Voting Nominations Previous Winners
                    Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                    Resources
                    Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software