Oacle Goldengate 11g implementer's guide : design, install, and configure high-performance data replication solutions using Oracle GoldenGate / John P. Jeffries.

Format:

Book

Author/Creator:

Jeffries, John P. (John Peter), 1964-

Language:

English

Subjects (All):

Integrated software--Software.

Integrated software.

Computer software.

Physical Description:

1 online resource (280 p.)

Edition:

1st ed.

Place of Publication:

Birmingham, UK : Packt Enterprise Pub., c2011.

Language Note:

English

Biography/History:

P Jeffries John: John P Jeffries has worked in many countries around the world, consulting on the Oracle technology. He is interested in different cultures and enjoys teaching others. At present, John lives and works in Singapore and is employed as a subject matter expert at a global bank, delivering enterprise-wide infrastructure design solutions, particularly in the database private cloud and data replication space. Since he wrote his first book, Oracle GoldenGate 11g Implementer's Guide, he has been heavily focused on leveraging Oracle's Fusion Middleware products (including GoldenGate) to address performance, data migration, and data delivery issues. With over 15 years of experience in Oracle, John has worked for a number of global organizations, such as BT, Siebel Systems, Dell, Thomson Reuters, and Oracle Corporation, to name a few. At Oracle, he worked in advanced customer services on key accounts as a senior principal consultant and became the UK data replication expert, often publishing articles on his own website (http: //oracle11ggotchas. com/). John is an Oracle Certified Professional and a GoldenGate specialist. He gives presentations at ODTUG conferences and continues to share his real-life hands-on experience through his work. Known for his ability to provide robust, effective solutions and workarounds, John delivers his knowledge, tips, and tricks in his new book, Oracle GoldenGate 12c Implementer's Guide.

Summary:

Design, install, and configure high-performance data replication solutions using Oracle GoldenGate with this book and eBook

Contents:

Cover; Copyright; Credits; Foreword; 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; 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 topologyProcess 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 replicationEnabling 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 architectureFile 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

Notes:

Includes index.

ISBN:

9786613016140

9781283016148

1283016141

9781849682015

1849682011

OCLC:

797916713