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

• Record Nr.: UNINA9910825782603321
• Autore: Jeffries John P (John Peter), <1964->
• Pubbl/distr/stampa: Birmingham, UK, : Packt Enterprise Pub., c2011
• ISBN: 1-283-01614-1; 9786613016140; 1-84968-201-1
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (280 p.)
• Disciplina: 005.7575
• Soggetti: Integrated software; Computer software
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: Includes index.
• Nota di contenuto: 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
• Sommario/riassunto: Design, install, and configure high-performance data replication solutions using Oracle GoldenGate with this book and eBook