- Oracle GoldenGate 11g Implementer's guide
- John P Jeffries
- 434字
- 2021-04-13 16:39:47
The Oracle GoldenGate topology is a representation of the databases in a GoldenGate environment, the GoldenGate components configured on each server, and the flow of data between these components.
The flow of data in separate trails is read, written, validated and check-pointed at each stage. GoldenGate is written in C and because it is native to the operating system, can run extremely fast. The sending, receiving, and validation have very little impact on the overall machine performance. Should performance become an issue due to the sheer volumes of data being replicated, you may consider configuring parallel Extract and/or Replicat processes.
The following sections describe the process topology. Firstly discussing the rules that you must adhere to when implementing GoldenGate, followed by the order in which the processes must execute for end to end data replication.
When using parallel Extract and/or Replicat processes, ensure you keep related DDL and DML together in the same process group to ensure data integrity. The topology rules for configuring the processes are as follows:
- All objects that are relational to an object are processed by the same group as the parent object
- All DDL and DML for any given database object are processed by the same Extract group and by the same Replicat group
Should a referential constraint exist between tables, the child table with the foreign key must be included in the same Extract and Replicat group as the parent table having the primary key.
If an Extract group writes to multiple trails that are read by different Replicat groups, the Extract process sends all of the DDL to all of the trails. It is therefore necessary to configure each Replicat group to filter the DDL accordingly.
The following tables show the position of each link in the process topology for the two fundamental configuration types:
In terms of performance monitoring, the GGSCI tool provides real-time statistics as well as comprehensive reports for each process configured in the GoldenGate topology. In addition to reporting on demand, it is also possible to schedule reports to be run. This can be particularly useful when performance tuning a process for a given load and period.
The INFO ALL command provides a comprehensive overview of process status and lag, whereas the STATS option gives more detail on the number of operations. Both commands offer real-time reporting. This is demonstrated in the following screen shots:
From the screenshot you can see that the STATS command provides daily and hourly cumulative statistics for a given process, including the overall total and the latest real-time figures.
- JBoss AS 5 Development
- Drupal Multimedia
- Maya建模技術解析
- 中文版CorelDRAW X8基礎培訓教程（全彩版）
- 數字創意大師：Alias二維與三維概念設計工作流淺析
- 新編 中文版Photoshop入門與提高
- 詳解AutoCAD 2022電氣設計（第6版）
- SPSS統計分析
- 平面設計制作標準教程（微課版 第2版）
- Photoshop CC完全自學教程：從入門到實踐（全新版）
- Photoshop+CorelDRAW 字體設計與創意：草圖/實現/包裝（微課版）
- Oracle E/Business Suite R12 Supply Chain Management
- 攝影師的后期課：RAW格式技法篇
- Open Source Identity Management Patterns and Practices Using OpenAM 10.x
- Maya 2022從新手到高手