1)Disaster recovery and data protection
Creates and maintains an immediate failover site with up-to-the-minute data to minimize recovery time for mission-critical systems.
2)Zero downtime operations
Enables uninterrupted business operations during system upgrades, migration, and maintenance activities.
3)Data distribution
Synchronizes data for distributed applications in real time for improved availability and scalability.
4)Query offloading
Ensures high performance for production systems while still supporting necessary read-only activities by replicating data between heterogeneous sources and targets.
(3)Enables real-time data integration across the enterprise:
1)Real-time data warehousing
Provides continuous, real-time capture and delivery of the most recent change data between OLTP systems and the data warehouse.
2)Operational reporting
Off loads reporting activity from the production database to lower-cost secondary systems that have current data for real-time reporting.
3)Operational data integration
Integrates operational data between OLTP systems in real time.
3.7.2 Using Oracle GoldenGate with Oracle Active Data Guard
Oracle Golden Gate and Oracle Active Data GuardFoot 2 are strategic capabilities within Oracle's software portfolio and are complementary to each other. When used together, Oracle GoldenGate and Oracle Active Data Guard offer a unique data protection and information distribution solution not offered by any other product.
While these features generally fall into the category of replication technologies, each has a very different area of focus:
(1)Oracle Active Data Guard is Oracle's strategic product for data protection and disaster recovery for Oracle Database.
Oracle Active Data Guard is a superset of standard Data Guard functionality included in Oracle Database Enterprise Edition, thus Active Data Guard also inherits all Data Guard functionality:
1) Transparent operation across all data types, storage attributes, DML and DDL
2) Management simplicity; simple one-way replication of the entire database
3) Superior corruption protection
4) Choice of asynchronous or synchronous (zero data loss) protection
5) High availability during unplanned events via automatic database and client failover
6) Minimized downtime by implementing database upgrades, system and site maintenance, or technology refresh, in rolling fashion across primary and standby databases
Oracle Active Data Guard requires a separate license and can only be used with Oracle Database Enterprise Edition. It can be purchased as the Active Data Guard Option for Oracle Database Enterprise Edition. It is also included with Oracle GoldenGate. Basic Data Guard functionality does not require a separate license, and it is included with Oracle Enterprise Edition. Oracle Active Data Guard is described in Section 3.6.2.
(2)Oracle GoldenGate is Oracle's strategic product for data distribution and data integration.
Oracle GoldenGate supplements Active Data Guard with its heterogeneous and bidirectional replication capabilities to enable enterprise-wide information distribution, zero-downtime upgrades and migrations, quer