Oracle GoldenGate 11g Implementer's guide


Oracle GoldenGate 11g Implementer's guide
eBook: $32.99
Formats: PDF, PacktLib, ePub and Mobi formats
$28.05
save 15%!
Print + free eBook + free PacktLib access to the book: $87.98    Print cover: $54.99
$83.04
save 6%!
Packt
Anytime, Anywhere
Unlimited eBook downloads and up to 50% off the print version!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • The very first book on GoldenGate, focused on design and performance tuning in enterprise-wide environments
  • Exhaustive coverage and analysis of all aspects of the GoldenGate software implementation, including design, installation, and advanced configuration
  • Migrate your data replication solution from Oracle Streams to GoldenGate
  • Design a GoldenGate solution that meets all the functional and non-functional requirements of your system
  • Written in a simple illustrative manner, providing step-by-step guidance with discussion points
  • Goes way beyond the manual, appealing to Solution Architects, System Administrators and Database Administrators

Book Details

Language : English
Paperback : 280 pages [ 235mm x 191mm ]
Release Date : February 2011
ISBN : 1849682003
ISBN 13 : 9781849682008
Author(s) : John P Jeffries
Topics and Technologies : All Books, Enterprise Products and Platforms, Oracle Database, Enterprise, Oracle

Table of Contents

Preface
Chapter 1: Getting Started
Chapter 2: Installing and Preparing GoldenGate
Chapter 3: Design Considerations
Chapter 4: Configuring Oracle GoldenGate
Chapter 5: Configuration Options
Chapter 6: Configuring GoldenGate for HA
Chapter 7: Advanced Configuration
Chapter 8: Managing Oracle GoldenGate
Chapter 9: Performance Tuning
Chapter 10: Troubleshooting GoldenGate
Appendix A: GGSCI Commands
Appendix B: GoldenGate Installed Components
Appendix C: The Future of Oracle GoldenGate
Index
  • Chapter 1: Getting Started
    • What is GoldenGate?
    • Oracle GoldenGate evolution
    • Oracle GoldenGate solutions
    • Oracle GoldenGate technology overview
      • The capture process (Extract)
      • Trail files
      • Data Pump
      • Server Collector
      • The Apply process (Replicat)
      • The Manager process
      • GGSCI
      • Process data flow
    • Oracle GoldenGate architecture
      • One-to-One
      • One-to-Many
      • Many-to-One
      • Cascading
      • Bi-directional (Active-Active)
      • Bi-directional (Active-Passive)
    • Supported platforms and databases
    • Oracle GoldenGate topology
      • Process topology
        • The rules
        • Position
        • Statistics
    • Design considerations
      • Choosing a solution
      • Network
      • Database schema
    • What to Replicate?
      • Object mapping and data selection
      • Initial Load
      • CSN co-ordination
      • Trail file format
    • Summary
    • Chapter 2: Installing and Preparing GoldenGate
      • Prerequisites
        • Downloading the software
        • Software requirements
        • Hardware requirements
          • Memory
          • CPU
          • Network
          • Disk
      • Software installation
        • Installing GoldenGate
        • The subdirectories
          • dirchk
          • dirdat
          • dirdef
          • dirpcs
          • dirprm
          • dirrpt
          • dirsql
          • dirtmp
      • Preparing the environment
        • Preparing the database for data replication
          • Enabling supplemental logging
        • Preparing the operating system
      • Creating the initial configuration
        • Creating the GoldenGate administrator
        • The Manager process
        • The Extract process
          • Creating and starting an Extract process
        • The Data Pump process
        • The Replicat process
          • Creating and starting a Replicat process
        • Configuration summary
      • Uninstalling GoldenGate from Linux/UNIX
      • Summary
      • Chapter 3: Design Considerations
        • Replication methods
          • Active-active
          • Active-passive
          • Cascading
          • Physical Standby
        • Networking
          • Surviving network outages
            • Redundant networks
        • Non-functional requirements (NFRs)
          • Latency
          • Availability
          • Backup and recovery
        • Hardware considerations
          • Computing architectures
            • Grid computing
            • Single server
            • Clusters
          • Machines
            • The x86-64 Linux Server
            • The Database Machine
            • Scaling up and out
        • Changed data management
          • Point in Time Recovery (PITR)
            • Oracle Recovery Manager (RMAN)
            • Flashback
            • SAN Snapshot
        • Summary
        • Chapter 4: Configuring Oracle GoldenGate
          • GoldenGate parameters
          • Configuring the Initial Load
            • Choosing a method
              • File to Replicat
              • File to database utility
              • Direct Load
              • Direct Bulk Load
          • Performing the Initial Load
            • Example architecture
            • File to Replicat method
              • Configuring Initial Data Capture
              • Configuring Initial Data Delivery
          • Configuring Change Data Capture
          • Configuring Change Delivery
          • Testing Change Data Capture and Delivery
          • Stopping GoldenGate processes
          • More about trail files
            • The trail
            • Trail file purging
          • Configuring the Manager process
          • Summary
          • Chapter 5: Configuration Options
            • Using BATCHSQL
              • SQL cache
              • Exceptions
              • When to use BATCHSQL
            • Data compression
              • Compressing the Data Stream
                • The COMPRESS option
              • Oracle table compression
            • Security features
              • Data encryption
              • Password encryption
                • Default method
                • Named method
            • Event Actions
              • Event Records
            • Bi-directional configuration options
              • Loop detection
              • Conflict detection
              • Conflict resolution
              • Oracle sequences
              • Oracle triggers
            • Heterogeneous environments
              • Specific options
                • Microsoft SQL Server
                • IBM DB2
              • The DEFGEN utility
            • DDL replication
              • The DDL parameter
                • Filtering
                • Mapping options
              • Initial setup
                • Known issues
              • Using DUMPDDL
              • DDL OPTIONS
            • Summary
            • Chapter 6: Configuring GoldenGate for HA
              • GoldenGate on RAC
                • Shared storage
                  • Automatic Storage Management Cluster File System (ACFS)
                  • Database File System (DBFS)
                • Configuring Clusterware for GoldenGate
                  • The Virtual IP
                  • Creating a GoldenGate application
                • Increasing system resilience
              • GoldenGate on Exadata
                • Configuration
                  • Creating the Extract process
                  • Creating the Replicat process
              • Failover
                • Automatic failover
                • Manual failover
                  • Relocating a service
                  • Relocating a VIP
              • Summary
              • Chapter 7: Advanced Configuration
                • Mapping your data
                  • Column mapping
                    • Using the COLMAP option
                    • The COLMATCH option
                    • Using the DEFGEN utility
                • Data selection and filtering
                  • The WHERE clause
                  • The FILTER clause
                  • Loop detection
                    • Active-active
                    • Cascade
                • Data transformation
                  • Truncation and extraction
                  • Concatenation
                  • Substitution
                  • Case changing
                  • Numeric conversions
                  • Date conversions
                • DDL support
                • The SQLEXEC parameter
                  • Data lookups
                    • Executing stored procedures
                    • Executing SQL
                  • Executing DML
                    • Handling errors
                  • Scheduling jobs
                • Using and defining macros
                • User tokens
                • User Exits
                  • Calling C routines
                  • Sample User Exits
                    • Source files explained
                • Using logic in data replication
                • Licensing
                • Summary
                • Chapter 8: Managing Oracle GoldenGate
                  • Command level security
                    • The CMDSEC file
                  • Trail file management
                  • Managing process startup
                  • Managing TCP/IP errors
                    • The tcperrs file
                  • Reporting and statistics
                    • Monitoring errors
                    • Monitoring latency
                      • A bespoke solution to monitoring and reporting
                    • Measuring throughput
                      • Data throughput
                      • Operation throughput
                  • Summary
                  • Chapter 9: Performance Tuning
                    • Before tuning GoldenGate
                      • Online redo
                      • Large objects (LOBs)
                      • Base lining
                    • Balancing the load across parallel process groups
                      • Considerations for using parallel process groups
                    • Splitting large tables into row ranges across process groups
                      • The RANGE function
                        • Adding Replicats with @RANGE function
                    • Configuring multiple parallel process groups
                      • Source system configuration
                        • Parallel process parameter files
                        • Creating extract parallel process groups
                      • Target system configuration
                        • Parallel process parameter files
                        • Creating Replicat parallel process groups
                        • Improving Replicat throughput
                    • New releases
                      • DBFS enhancements
                      • New redo log OCI API
                    • Tuning the network
                      • Linux TCP tuning
                      • Configuring a Bequeath connection
                    • Summary
                    • Chapter 10: Troubleshooting GoldenGate
                      • Troubleshooting tips
                        • Replication not working?
                          • The CHECKPARAMS parameter
                        • Adjusting the start point
                          • Altering Extract processes in RAC environments
                        • Checking process checkpoints
                        • Investigating network issues
                          • TCP/IP
                          • SQL*Net
                        • Investigating Oracle errors
                      • Exception handling
                        • Creating an Exceptions handler
                        • Viewing Exceptions
                          • Before and after images
                      • Handling Oracle Sequences
                      • Using LOGDUMP
                        • Opening files
                        • Viewing the header record
                        • Viewing the transaction record
                        • Miscellaneous commands
                        • Filtering records
                      • Upgrading GoldenGate
                      • Summary

                      John P Jeffries

                      Originally from a development background, John P Jeffries has worked for Oracle Corporation since the Siebel acquisition in 2005. His time at Siebel was spent developing ETL solutions for Data Warehouses, later moving to Oracle Consulting and then Oracle Advanced Customer Services as a Senior Principal Consultant, earning the internal title of "The UK's Data Replication Expert". Now a freelance consultant, he can be found onsite in many of the world's most respected financial institutions in London, consulting on Oracle GoldenGate, Streams, and Active Data Guard. With over 15 years of Oracle experience, and an OCP since Oracle 8i, he has extensive knowledge of Oracle databases, including Enterprise Linux and RAC, coupled with the ability to design and build high-performance distributed database systems. He has trained internal and external clients in Data Warehousing and Data Replication techniques, and continues to share his knowledge and experience through his own Website: http://www.oracle11ggotchas.com.

                      Read Packt's recent Q&A with John for further information

                      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 Implementer's guide +    Getting Started with Oracle Data Integrator 11g: A Hands-On Tutorial =
                      50% Off
                      the second eBook
                      Price for both: $47.10

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

                      What you will learn from this book

                      • Deliver high-speed data replication solutions
                      • Implement robust Disaster Recovery solutions
                      • Migrate applications with no data loss or downtime
                      • Configure GoldenGate for High Availability and Scalability
                      • Troubleshoot and solve data replication problems, including Conflict Handling and Error Detection
                      • Write your own GoldenGate macros and enhancements
                      • Configure multi-target replication from a single-source database
                      • Configure bi-directional replication
                      • Report on your data throughput and latency
                      • Tune GoldenGate for high performance
                      • Learn about the advanced features and techniques that make GoldenGate the preferred choice in data replication

                      In Detail

                      Data replication is an important part of any database system that is growing due to today's demand for real-time reporting and regulatory requirements. GoldenGate has recently become Oracle's strategic real-time data replication solution. Until now, very little has been written about how to implement GoldenGate in a production enterprise environment where performance, scalability, and data integrity are paramount.

                      Your days of dismay over the lack of documentation over Oracle GoldenGate are over.

                      Welcome to Oracle GoldenGate 11g Implementer's guide – a comprehensive practical book, which will deliver answers to your questions in a clear, concise style, allowing you to progress effectively in a timeline-driven environment. Based on the author's own experience, this long awaited GoldenGate administration book has all that is required to install, design, configure, and tune data replication solutions suited to every environment. Be the first to master GoldenGate's power and flexibility by reading this unique hands-on implementation companion.

                      Systems need to send data from one system to another in a timely manner to satisfy the ever-increasing need for speed. Regardless of whether you are a novice or an expert – or someone in between – this book will guide you through all the steps necessary to build a high-performance GoldenGate solution on Oracle11gR1. Expert users can dive into key topic areas such as performance tuning or troubleshooting, while novice users can step through the early installation and configuration chapters, later progressing to the advanced chapters.

                      This book is more than an implementation guide. It offers detailed real-life examples, encouraging additional thought and discussion by going beyond the manual.

                      With Oracle GoldenGate 11g Implementer's guide in hand, you'll be designing, installing, and configuring high-performance solutions using GoldenGate in less time than you can say "replicate"

                      Approach

                      More than just a step-by-step guide, this book offers examples, tips, and tricks that are all discussed in detail, providing the reader with the knowledge and confidence to implement them. Supporting diagrams, illustrations, and screenshots promote understanding and enhance the overall reading experience.

                      The author's onsite experience in implementing Oracle GoldenGate in the financial sector is thoroughly reflected in this book.

                       

                      Podcast content courtesy of artofbi.com

                      Christian Screen, Solutions Engineer and Consultant for the BI Consulting Group chats with author John P. Jeffries about GoldenGate, his experiences and his new book

                      Who this book is for

                      This book is for Solution Architects and Database Architects who wish to learn about the functionality and efforts required in implementing a data replication, migration or integration solution using GoldenGate. It is also designed for System Administrators and Database Administrators who want to implement, or those who have already implemented, Goldengate and who want to explore its advanced features. An intermediate understanding of Oracle database technology is assumed.

                      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