In today’s session we will start with defining availability and different states of system availability. Then we will cover Oracle replication products A brand new offering from Oracle for high availability solutionsL Oracle GoldenGate will be covered more in depth going over different use cases and how it complements existing Oracle products..
A detailed customer case study on RIM Blackberry will show Oracle GoldenGate in action in multiple projects within the company.
We discussed Oracle GoldenGate in previous sessions. Oracle GoldenGate offers a heterogeneous data replication solution that is transaction aware. It moves committed transactions from redo logs and maintains transaction integrity. Just as a reminder GoldenGate is built for moving data non-intrusively between heterogeneous systems in sub-seconds. Its reliability is especially critical for enabling continuous availability solutions. As we mentioned earlier this software is used to keep mission critical systems of leading Fortune 500 companies and it is designed for reliable data delivery.
Let’s take a deeper look how GG works. As I mentioned, GG moves data between heterogeneous databases, as shown here. It does not have to Oracle. The software operates at the database level and the capture component is typically installed on the source database server outside of the DBMS. GoldenGate’s CAPTURE reads native transaction logs and captures transactions as soon as they commit and takes outside of the database system to be queued. It only moves changed, committed transactional data– therefore operates with extremely high performance and very low impact .
It allows filtering at table, column and/or row level and row-level transformations can be applied at this capture stage or later when delivering.
After the capture GoldenGate converts the committed transactions into a universal data format in “trail” files. Using source and target trail files, it eliminates any single point of failure and ensures data integrity is maintained – even in the event of a system error or outage.
Another Capture component can be use to pump the data to multiple targets and for better recoverability. This configuration enhances the fault tolerance and reliability of the overall GoldenGate environment. In the event of a network failure (between the source and the target systems), the GoldenGate Capture component can continue to capture transactions since the data can be queued up locally in the Trail Files on the source, enhancing the recoverability in case of database failures.
This is NOT the database feature called Data Pump.
From the trail files the data is routed via TCP/IP to the target systems. During routing Data compression and encryption can be applied and thousands of transactions can be moved per second, without any distance limitations.
The other key component of GoldenGate is the Delivery module that is installed on the target database server. Qeued Transactions that are stored in the trail files are applied to target using native SQL calls
Basic transformations at the row level can be applied if desired at delivery or capture.
This data movement can be done bidrectionally. GoldenGate has built in loop detection to differentiate between new transactions versus the data it replicates.
GoldenGate’s modular architecture allows a number of data movement configurations to be supported. Here are popular examples.
Oracle GoldenGate has two additional products that I would like to mention here briefly.
Oracle GoldenGate Veridata is a low impact data comparison solution. It identifies and reports data discrepancies between heterogeneous databases without interrupting their availability
But It does not need to have Oracle GoldenGate to be deployed to do its high speed comparisons. Typical use cases include ensuring the standby systems– or the new environments’ users may be migrating to- have no data discrepancy before switchover. It allows validating data consistency for compliance related reporting too.
By comparing data and ensuring they are consistent companies decrease their risk exposure, especially the data is used for regulatory compliance. Knowing data is the same as the OLTP system gives extra confidence.
This automated approach helps speed and simplify IT work in comparing data sources. Because it compares in-flight transactions it does not require any interruption to source systems.
As you can see from the diagram that it gives an overview of different comparison jobs and (CLICK) provides a detailed report such as this one tohelp with immediately fixing the problem.
Oracle Management Pack for Oracle GoldenGate is the second related product.
It is a value added module to centralize management and improve IT productivity when working with Oracle GoldenGate.
It has both Web and Client GUIs and supports all platforms and databases supported by GoldenGate. It enables managing and monitoring of GoldenGate solutions across the enterprise. It has rich and web client interfaces and provides real-time feedback along with real-time alert notification of Oracle GoldenGate processes. It also improves IT responsiveness
Let’s take a look at existing Oracle replication solutions that are used for high availability and discuss how GoldenGate fits and adds value.
Oracle Streams is a builtin replication solution for Oracle databases that comes with the Enterprise Edition. It is homogeneous Oracle to Oracle.
Oracle GoldenGate is the strategic replication solution for Oracle. It is a flexible, heterogeneous and low overhead technology with many large customer references for mission critical environments. Oracle Streams customers will continue to receive support and the best Streams features will be added to Oracle GoldenGate
In today’s session we will start with defining availability and different states of system availability. Then we will cover Oracle replication products A brand new offering from Oracle for high availability solutionsL Oracle GoldenGate will be covered more in depth going over different use cases and how it complements existing Oracle products..
A detailed customer case study on RIM Blackberry will show Oracle GoldenGate in action in multiple projects within the company.
© 2010, www.oracledatabase12g.com. 版权所有.文章允许转载,但必须以链接方式注明源地址,否则追究法律责任.
相关文章 | Related posts:
- Real-Time Business Intelligence using Oracle GoldenGate
- Using Oracle GoldenGate for Siebel Zero Downtime Upgrades
- Introduction to Oracle GoldenGate And GG Official Price
- Oracle GoldenGate: Disaster Recovery Solution
- Using Real-Time Diagnostic Tools to Diagnose Intermittent Database Hangs
- Benefits From Oracle Real Application Cluster
- Collecting Diagnostic information for Oracle block corruption
- Managing Performance and Availability for 25,000 Siebel Contact Center Users with Oracle Real Application Clusters
- Does DB Time include wait on cpu queue time?
- 11gR2 Grid Infrastructure Single Client Access Name (SCAN) Explained
最新评论