Oracle GoldenGate 12c Implementer's Guide : Leverage the Power of Real-time Data Access for Designing, Building, and Tuning Your GoldenGate Enterprise

Cover Copyright Credits About the Author About the Reviewers www.PacktPub.com Table of Contents Preface Chapter 1: Getting Started What is GoldenGate? Oracle GoldenGate evolution Oracle GoldenGate solutions Oracle GoldenGate technology overview Extract � the capture process Trail files Data pump Server collector Replicat � the apply process The Manager process GGSCI Process data flow Oracle GoldenGate architecture Classic configurations One-to-one architecture One-to-many architectureMany-to-one architecture Cascading Bidirectional � active-active Bidirectional � active-passive New configurations Oracle Data Integrator Oracle Big Data 12c new features Integrated capture Integrated Replicat Downstream capture Installation Upgrading to 12c Multitenant database replication Coordinated Delivery Enhanced event-based processing Enhanced security Conflict Detection and Resolution Dynamic Rollback Streams to GoldenGate migration Improved management and monitoringOracle Management Pack Oracle GoldenGate Veridata 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 coordination Trail file format Summary Chapter 2: Installing and Preparing GoldenGate Prerequisites The GoldenGate certification matrix Downloading the softwareSoftware requirements Hardware requirements Memory CPU Network Disk The Oracle virtual machine The software installation Installing GoldenGate using the OUI Unpacking the media Enabling the X server Running the installer Performing a silent installation The subdirectories br dircrd dirchk dirdat dirdef dirpcs dirprm dirrpt dirsql dirtmp dirwlt Preparing the environment Preparing the 12c container database for data replication Enabling archive log modeEnabling supplemental logging Creating GoldenGate admin user Enabling the Flashback Query Enabling transaction data capture Preparing the 11g database for replication Enabling the archive log mode Creating the GoldenGate admin user Enabling the transaction data capture Preparing the operating system Creating the initial configuration Configuring the Manager process The capture process Creating the capture process Registering the capture process in a 12c container database **Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise** About This Book* Orchestrate the rich features of GoldenGate 12c and exploit the performance-enhancing features and manageability in your Enterprise environment * Master data integration techniques to empower your organisation's readiness to migrate to cloud technologies quickly and easily * An easy-to-follow step-by-step guide full of hands-on examples that offer a solid foundation of real-time data integration and replication in heterogeneous IT environments Who This Book Is ForThe book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required. What You Will Learn* Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives * Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products * Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI * Extend GoldenGate functionality through APIs and reduce your IT operational expenditure * Leverage the designs to build efficient, cost effective data integration solutions * Enhance system management and monitoring in your GoldenGate environment * Generate real-time statistics to gauge data throughput and performance * Evaluate data integration concepts through Oracle's new Integration Cloud Service offering In DetailGoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips. Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise About This Book Orchestrate the rich features of GoldenGate 12c and exploit the performance-enhancing features and manageability in your Enterprise environment Master data integration techniques to empower your organisation's readiness to migrate to cloud technologies quickly and easily An easy-to-follow step-by-step guide full of hands-on examples that offer a solid foundation of real-time data integration and replication in heterogeneous IT environments Who This Book Is For The book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required. What You Will Learn Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI Extend GoldenGate functionality through APIs and reduce your IT operational expenditure Leverage the designs to build efficient, cost effective data integration solutions Enhance system management and monitoring in your GoldenGate environment Generate real-time statistics to gauge data throughput and performance Evaluate data integration concepts through Oracle's new Integration Cloud Service offering In Detail GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips. Leverage the power of real-time data access for designing, building, and tuning your GoldenGate Enterprise In Detail GoldenGate exchanges data among systems in a timely manner and meets the demand for real-time access to information regardless of volume. The new release, 12c, includes an optimized database, intelligent and integrated delivery capabilities, expanded heterogeneity, and tighter security. Perform zero downtime data migration to on-premise or public cloud with GoldenGate's feature-rich portfolio. Start with the installation and learn the design concepts and enhanced configuration of GoldenGate 12c. Exploit new 12c features to successfully implement GoldenGate on your enterprise. Dive deep into configuring GoldenGate for high availability, DDL support, and reverse processing. Build fast, secure, robust, scalable technical solutions by tuning data delivery and networks. Finally, enrich your data replication knowledge by learning the troubleshooting tips. What You Will Learn Extend GoldenGate's out-of-the-box functionality to employ its rich features and meet your business objectives Deliver best-in-class data integration solutions by integrating GoldenGate with other Oracle products Deploy data integration solutions effectively to lower your total cost of ownership and increase you ROI Extend GoldenGate functionality through APIs and reduce your IT operational expenditure Leverage the designs to build efficient, cost effective data integration solutions Enhance system management and monitoring in your GoldenGate environment Generate real-time statistics to gauge data throughput and performance Evaluate data integration concepts through Oracle's new Integration Cloud Service offering Key FeaturesBook DescriptionWhat you will learnWho this book is forThe book is aimed at Oracle database administrators, project managers, and solution architects who wish to extend their knowledge of GoldenGate. The reader is assumed to be familiar with Oracle databases. No knowledge of GoldenGate is required.