04898nam 2200649Ia 450 991082578260332120240710013100.01-283-01614-197866130161401-84968-201-1(CKB)2550000000031710(EBL)950600(OCoLC)797916713(SSID)ssj0000471873(PQKBManifestationID)12212171(PQKBTitleCode)TC0000471873(PQKBWorkID)10434143(PQKB)11486519(Au-PeEL)EBL950600(CaPaEBR)ebr10450982(CaONFJC)MIL301614(PPN)228042917(FR-PaCSA)88851770(MiAaPQ)EBC950600(EXLCZ)99255000000003171019910521d2011 uy 0engur|n|---|||||txtccrOacle Goldengate 11g implementer's guide design, install, and configure high-performance data replication solutions using Oracle GoldenGate /John P. Jeffries1st ed.Birmingham, UK Packt Enterprise Pub.c20111 online resource (280 p.)Includes index.1-84968-200-3 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 databasesOracle 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 environmentPreparing 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 networksNon-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 LoadExample 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 encryptionDefault methodDesign, install, and configure high-performance data replication solutions using Oracle GoldenGate with this book and eBookIntegrated softwareSoftwareComputer softwareIntegrated softwareComputer software.005.7575Jeffries John P(John Peter),1964-1743823MiAaPQMiAaPQMiAaPQBOOK9910825782603321Oacle Goldengate 11g implementer's guide4172264UNINA