Oracle GoldenGate consists of decoupled modules that are combined to create the best possible solution for your business requirements.
On the source system(s):
Oracle GoldenGate’s Capture (Extract) process reads data transactions as they occur, by reading the native transaction log, typically the redo log. Oracle GoldenGate only moves changed, committed transactional data, which is only a % of all transactions – therefore operating with extremely high performance and very low impact on the data infrastructure.
Filtering can be performed at the source or target – at table, column and/or row level.
Transformations can be applied at the capture or delivery stages.
Advanced queuing (trail files):
To move transactional data efficiently and accurately across systems, Oracle GoldenGate converts the captured data into a Oracle GoldenGate data format in “trail” files. With both source and target trail files, Oracle GoldenGate’s unique architecture eliminates any single point of failure and ensures data integrity is maintained – even in the event of a system error or outage.
Routing:
Data is sent via TCP/IP to the target systems. Data compression and encryption are supported. Thousands of transactions can be moved per second, without distance limitations.
On the target system(s):
A Server Collector process (not shown) reassembles the transactional data into a target trail.
The Delivery (Replicat) process applies transactional data to the designated target systems using native SQL calls.
Bi-directional:
In bi-directional configurations/solutions, this process runs the same in reverse, to concurrently synchronize data between the source and target systems.
Manager processes (not shown) perform administrative functions at each node.
Oracle GoldenGate is ideal for heterogeneous environments – not just supporting different versions of the same database or operation system/hardware, but replicating and integrating data across vendor systems.
We support log-based Capture of changed data from nearly all major database vendors.
We can Deliver that data to an even wider range of targets – including open source databases, several data warehouse appliances, ETL servers, and JMS message queues to support Service Oriented Architectures (SOA) and Event-Driven Architectures (EDA).
Oracle GoldenGate Director is a centralized server-based graphical enterprise application that offers an intuitive way to define, configure, manage, and report on Oracle GoldenGate processes.
Oracle GoldenGate Director is a value added module to centralize management and improve productivity.
Oracle GoldenGate Director supports all platforms and databases supported by Oracle GoldenGate.
Oracle GoldenGate Veridata is a high-speed data comparison solution that identifies and reports data discrepancies between databases without interrupting ongoing business processes. Using Oracle GoldenGate Veridata, companies can audit and verify large volumes of data across a variety of business applications with certainty, and maintain reliable data synchronization. Oracle GoldenGate Veridata reduces the amount of time and resources required to compare data, it minimizes the impact of human errors, and it ensures that potential problems can be instantly identified and addressed.
Key Veridata Features:
Compares large data volumes with high speed and efficiency
Allows both data sources to be online by handling in-flight transactions
Performs selective, parallel comparison
Offers intuitive Web interface and personalized views
Enables the comparison of databases that are different database versions or on different operating systems
(HP Nonstop only) Supports the comparison of only the data changed since the initial comparison (delta processing)
Why would you need Veridata?
Data discrepancies arise even without malicious intent — due to infrastructure problems, application errors, operator mistakes, configuration errors, or unexpected user behavior. With vigilant verification procedures using Oracle GoldenGate Veridata, companies can eliminate data inconsistencies across different business applications and avoid potential operational, financial, or regulatory risks.
On the source system:
An Extract process captures transactional changes from transaction logs
The Extract process sends data across a TCP/IP network to the target system.
On the target system:
A Server Collector process reassembles and writes the data to a GoldenGate trail.
A Replicat process reads the trail and applies it to the target database. This can be concurrent with the data capture or performed later.
Manager processes on both systems control activities such as starting, monitoring and restarting processes; allocating data storage; and reporting errors and events.
Bidirectional Capabilities
GoldenGate supports bidirectional replication between two databases, whether the configuration is for homogeneous or heterogeneous synchronization.
In a bidirectional configuration, both sides of the database may be live and processing application transactions at the same time. It also may be that the target application is standing-by waiting to be used if there is a fail-over. For this, operations are captured and queued to be synchronized back to the primary database once it becomes available.
Configuring GoldenGate for bidirectional may be as straightforward as configuring a mirror set of Extract and Replicat groups moving in the opposite direction. It is important, however, to thoroughly discuss special considerations for your environment to guarantee data accuracy. The following slides discuss some of the bidirectional concerns as well as known issues relating to file and data types.
Renames
To work around remote permissions issues that may arise when different users are being used on the source and target, RENAME will always be converted to equivalent ALTER TABLE RENAME for Oracle.
New Names
New names must be specified in TABLE/MAP statements in order to:
1) Replicate DML operations on tables resulting from a CREATE or RENAME,
2) CREATE USER and then move new/renamed tables into that schema
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Using Oracle GoldenGate for Siebel Zero Downtime Upgrades
- Real-Time Business Intelligence using Oracle GoldenGate
- ORA-8103 Troubleshooting, Diagnostic and Solution
- Design for Higher Availability and Faster Recovery Lawrence To Center of Expertise Worldwide Customer Support Oracle Corporation October 18th,
最新评论