Pro Oracle GoldenGate for the DBA
This book provides a simple approach to learning the Oracle GoldenGate product. This approach provides the in-depth perspective of GoldenGate from an implementer’s viewpoint; however, also addresses why the management viewpoint is important as well. Your journey through this book includes and archit...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2016.
|
| Edición: | 1st ed. 2016. |
| Colección: | The expert's voice in Oracle
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009630241906719 |
Tabla de Contenidos:
- Contents at a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Foreword; Chapter 1: Installation, Upgrade, and Removal; Selecting the Correct Version; Installing Oracle GoldenGate 12c; Creating Subdirectories; Viewing Inventory File Information; Upgrading Oracle GoldenGate; Removing Oracle GoldenGate; Oracle Universal Installer Deinstall Option; Hacking the oraInventory File; Summary; Chapter 2: Architecture; Architectures; Unidirectional Replication; Bidirectional (Active-Active) Replication; Real-Time Data Warehousing; Real-Time Data Distribution
- Data Distribution via MessagingUnderstanding System Change Numbers; Finding the System Change Number in Oracle; GoldenGate Processes; Manager Process; Collector Process; Capture Process; Classic Capture; Integrated Capture; Data Pump Process; Delivery Process; Classic Delivery; Coordinated Delivery; Integrated Delivery; Trail Files; Summary; Chapter 3: Basic Replication Configuration; Profiler; Run Profiler; Parameter Files; Extract Parameter File; Data Pump Parameter File; Replicat Parameter File; Manager Parameter File; Trail Files; Sizing and Retention of Trail Files; Obey Files
- Unidirectional ConfigurationPrerequisites; Enable Archive Log Mode; Enable Supplemental Logging; Enable Force Logging; Enable GoldenGate Parameter; Create a GoldenGate User; Granting Permissions to GoldenGate Users; Building Source GoldenGate Environment; Adding SCHEMATRANDATA or TRANDATA; SCHEMATRANDATA; TRANDATA; Edit Parameter Files; Starting the Extract; Extract (Data Pump) Process; Adding the Extract (Data Pump) Process; Starting the Data Pump (Extract) Process; Instantiation; Apply (Replicat) Process; Adding the Apply (Replicat) Process; Starting the Apply (Replicat) Process; Summary
- Chapter 4: Tuning Oracle GoldenGateDifferent Types of Tuning; Classic Process Tuning; Tools for Tuning; GoldenGate Tools; Monitoring Latency or Lag Events; Reporting Transactional Statistics; Database Tools; Operating System Tools; Tuning the Classic Processes; Considerations When Using Multiple Process Groups; Maintaining Data Integrity; Number of Groups; Memory; Isolating Process-Intensive Tables; Using Parallel Replicat Groups on the Target System; Adding New Trails from the Extract; Source Steps; Target Steps; Network Tuning; Detecting Any Network Bottlenecks
- Workaround for Bandwidth IssuesCompressing Data for Bandwidth Reduction; Increasing the TCP/IP Packet Sizes; Sizing TCP/IP Buffer Size; Eliminating Disk I/O Bottlenecks; Improving I/O Performance by System Configuration; Improving I/O Performance Within Oracle GoldenGate; Managing Virtual Memory and Paging; Applying Similar SQL Statements (Using Arrays); Full Table Scan Due to Absence of Keys; Tuning Integrated Processes; Tuning Tools for Integrated Processes; Automatic Workload Repository Output; Streams Performance Advisor; Installing Streams Performance Advisor
- Understanding Streams Performance Advisor Output
