Oracle Goldengate With Oracle Real Application Clusters Configuration
Executive Overview
Oracle Real Application Clusters (Oracle RAC) and Oracle Clusterware allow Oracle Database to run any packaged or custom application across a set of clustered servers. This capability provides the best availability for node and instance failures and most planned maintenance activities, and the most flexible scalability. If a clustered node fails, the Oracle database continues running on the surviving nodes. When more processing power is needed, another node can be added without interrupting user access to data.
Oracle Clusterware is a cluster manager that is designed specifically for the Oracle database. In an Oracle RAC environment, Oracle Clusterware monitors all Oracle resources (such as database instances and listeners). If a failure occurs, then Oracle Clusterware automatically attempts to restart the failed resource. During outages, Oracle Clusterware relocates the processing performed by the inoperative resource to a backup resource. For example, if a node fails, then Oracle Clusterware relocates the database services being used by the application to a surviving node in the cluster.
This white paper describes best practices for configuring Oracle GoldenGate to work with Oracle RAC, Oracle Clusterware and Oracle Database File System (DBFS). Oracle GoldenGate is instrumental for many reasons, including the following:
- To migrate to an Oracle Database, incurring minimal downtime
- As part of an application architecture that requires Oracle RAC plus the flexible availability features provided by Oracle GoldenGate, such as active-active database for data distribution and continuous availability, and zero or minimal downtime during planned outages for system migrations, upgrades, and maintenance
- To implement a near real-time data warehouse or consolidated database on Oracle RAC, sourced from various, possibly heterogeneous source databases, populated by Oracle GoldenGate
- To capture from an OLTP application running on Oracle RAC to support further downstreamconsumption such as a SOA type integration
This paper focuses on configuring Oracle GoldenGate to run on Oracle RAC, which can act asthe source database, as the target database, or in some cases as both source and target databases for Oracle GoldenGate processing.
http://www.oracle.com/technetwork/database/features/availability/maa-goldengate-rac-2007111.pdf
No hay comentarios:
Publicar un comentario