LEADER 04898nam 2200649Ia 450 001 9910825782603321 005 20240710013100.0 010 $a1-283-01614-1 010 $a9786613016140 010 $a1-84968-201-1 035 $a(CKB)2550000000031710 035 $a(EBL)950600 035 $a(OCoLC)797916713 035 $a(SSID)ssj0000471873 035 $a(PQKBManifestationID)12212171 035 $a(PQKBTitleCode)TC0000471873 035 $a(PQKBWorkID)10434143 035 $a(PQKB)11486519 035 $a(Au-PeEL)EBL950600 035 $a(CaPaEBR)ebr10450982 035 $a(CaONFJC)MIL301614 035 $a(PPN)228042917 035 $a(FR-PaCSA)88851770 035 $a(MiAaPQ)EBC950600 035 $a(EXLCZ)992550000000031710 100 $a19910521d2011 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOacle Goldengate 11g implementer's guide $edesign, install, and configure high-performance data replication solutions using Oracle GoldenGate /$fJohn P. Jeffries 205 $a1st ed. 210 $aBirmingham, UK $cPackt Enterprise Pub.$dc2011 215 $a1 online resource (280 p.) 300 $aIncludes index. 311 $a1-84968-200-3 327 $aCover; 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 327 $aOracle 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 327 $aPreparing 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 327 $aNon-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 327 $aExample 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 327 $aDefault method 330 $aDesign, install, and configure high-performance data replication solutions using Oracle GoldenGate with this book and eBook 606 $aIntegrated software$vSoftware 606 $aComputer software 615 0$aIntegrated software 615 0$aComputer software. 676 $a005.7575 700 $aJeffries$b John P$g(John Peter),$f1964-$01743823 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910825782603321 996 $aOacle Goldengate 11g implementer's guide$94172264 997 $aUNINA