Oracle GoldenGate Performance Best Practices (White Paper)

Oracle White Paper
Oracle GoldenGate Performance Best Practices

Introduction
The strategic integration of Oracle Exadata Database Machine and Oracle Maximum Availability Architecture (MAA) best practices (Exadata MAA) provides the best and most comprehensive Oracle Database availability solution. Oracle GoldenGate is a key component of MAA, providing a logical replication solution for fast platform migration and a near zero downtime solution for application and database upgrades. It complements the rest of Oracle’s MAA solution that tolerates failures and enables online maintenance and rolling upgrade through Oracle Real Application Clusters (Oracle RAC), Oracle Automatic Storage Management (Oracle ASM), and Oracle Active Data Guard.

This white paper describes best practices for configuring Oracle GoldenGate for the best performance, simple manageability, and stability for Oracle databases. Non-Oracle databases are not covered in this paper.
Refer to “Oracle GoldenGate with Oracle Real Application Clusters Configuration” MAA white paper at the link below for the initial configuration of Oracle GoldenGate, including installation, Oracle Database File System (DBFS) configuration for shared Oracle GoldenGate files, and Oracle Real Application Clusters (Oracle RAC) services configuration.

http://www.oracle.com/technetwork/database/availability/maa-gg-performance-1969630.pdf

Replicación de On-Premises a Oracle Public Cloud utilizando GoldenGate Cloud Service (GGCS)

En este insteresante artículo podemos ver el procedimiento para configurar replicación Oracle GoldenGate (OGG) entre una base de datos Oracle local y el servicio cloud de Oracle (DBCS) en Oracle Public Cloud (OPC) utilizando  GoldenGate Cloud Service (GGCS).
En el artículo no se trata puntualmente la instalación de Oracle GoldenGate para  bases de datos Oracle On-Premises ni el aprovisionamiento de Oracle GGCS y DBCS. Se asume que el software de GoldenGate ya ha sido instalado en el servidor local y las instancias de GGCS y DBCS ya existen.

Oracle High Availability Demonstrations

Comparto aqui un link a High Availability Demonstrations en el sitio de Oracle
Realmente muy interesante, son demostraciones de casos de HA divididos por categorias:

• Data Guard
• Active Data Guard
• Recovery Manager (RMAN)
• Flashback Technology
• Data Guard and Applications
• Oracle Secure Backup (OSB)
• Global Data Services (GDS)
• Oracle GoldenGate
• Oracle Sharding
• Cloud MAA

En futuros posts les iré comentando un poco más sobre cada caso.

Oracle Goldengate With Oracle Real Application Clusters Configuration

Oracle White Paper
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