article-preview

Oracle Database Migration with an Oracle GoldenGate Hub Configuration

This Oracle GoldeGate Maximum Availability Architecture (MAA) migration solution provides step-bystep instructions to set up and migrate any 11g Release 2 and later Oracle database, from any system platform (e.g. AIX, HP UX, Linux), from a single tenant to a multitenant architecture, or from a database not using Transparent Data Encryption (TDE) to a TDE database.

article-preview

Oracle GoldenGate Performance Best Practices

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.

article-preview

Oracle Maximum Availability Architecture (MAA) GoldenGate Hub

To achieve the highest levels of availability, resulting in zero or near-zero downtime for both unplanned outages and planned maintenance activities, customers frequently use the combination of Oracle Real Application Clusters (Oracle RAC), Oracle Active Data Guard, and Oracle GoldenGate. Traditionally, Oracle GoldenGate is installed and run locally on the database server that the GoldenGate processes connect to. When used with Oracle Grid Infrastructure Standalone Agent (XAG), Oracle GoldenGate processes can be configured to seamlessly relocate or fail over between Oracle RAC nodes and follow Oracle Active Data Guard switchover and failovers.