Oacle Goldengate 11g implementer's guide [[electronic resource] ] : design, install, and configure high-performance data replication solutions using Oracle GoldenGate / / John P. Jeffries |
Autore | Jeffries John P (John Parsons), <b. 1815.> |
Pubbl/distr/stampa | Birmingham, UK, : Packt Enterprise Pub., c2011 |
Descrizione fisica | 1 online resource (280 p.) |
Disciplina | 005.7575 |
Soggetto topico |
Integrated software
Computer software |
Soggetto genere / forma | Electronic books. |
ISBN |
1-283-01614-1
9786613016140 1-84968-201-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910456936603321 |
Jeffries John P (John Parsons), <b. 1815.>
![]() |
||
Birmingham, UK, : Packt Enterprise Pub., c2011 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
Oacle Goldengate 11g implementer's guide [[electronic resource] ] : design, install, and configure high-performance data replication solutions using Oracle GoldenGate / / John P. Jeffries |
Autore | Jeffries John P (John Parsons), <b. 1815.> |
Pubbl/distr/stampa | Birmingham, UK, : Packt Enterprise Pub., c2011 |
Descrizione fisica | 1 online resource (280 p.) |
Disciplina | 005.7575 |
Soggetto topico |
Integrated software
Computer software |
ISBN |
1-283-01614-1
9786613016140 1-84968-201-1 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
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 |
Record Nr. | UNINA-9910781295903321 |
Jeffries John P (John Parsons), <b. 1815.>
![]() |
||
Birmingham, UK, : Packt Enterprise Pub., c2011 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|