
1 | DISASTER RECOV ERY FOR ORACLE DATABASE – RECOVERY APPLIAN CE , ACTIVE DATA GUARD AND ORACLE GOLDENGATE
Overview
Oracle Database provides three different approaches to disaster recovery that provide the highest
level of data protection and availability compared to any other approach for protecting Oracle data.
Oracle Zero Data Loss Recovery Appliance is an engineered system designed to eliminate data loss
and dramatically reduce data protection overhead for all Oracle databases in the enterprise. Integrated
with Recovery Manager (RMAN), it enables a centralized, incremental forever backup strategy for
hundreds to thousands of databases, using cloud-scale, fully fault-tolerant hardware and storage.
Replication capabilities integrated with the Recovery Appliance make it ideally suited for providing
disaster recovery for Oracle databases where a restore from backup is sufficient to address recovery
time objectives.
Oracle Active Data Guard is the replication solution optimized for data protection and disaster recovery
for the Oracle Database. Active Data Guard prevents data loss and downtime by maintaining a
synchronized physical replica of the production database. If the production database becomes
unavailable for any reason, client connections can quickly, and in some configurations transparently,
fail over to the replica to immediately restore service. Active Data Guard als o eliminates idle
redundancy by allowing read-only workloads to be offloaded to a copy of the production database.
Active Data Guard is ideally suited for providing disaster recovery for databases with recovery time
objectives that cannot tolerate the downtime that accompanies a restore from backup.
Oracle GoldenGate
This paper provides Oracle Maximum Availability Architecture
is Oracle’s ful l-featured replication solution designed to address a wide range of
requirements. GoldenGate maintains a synchronized logical copy of a production database that is
open read-write at all times. A GoldenGate replica, for example, can offload reporting applications that
require read-write database access or can be used to load-balance read-write workloads using
multimaster replication. Increased flexibility, however, is accompanied by several trade-offs for data
protection and operational simplicity compared to Active Data Guard. GoldenGate is used for disaster
recovery by customers who accept these trade-offs in return for its additional flexibility.
1
1 http://www.oracle.com/technetwork/database/features/availability/maa-096107.html
best practices for the use of the
Recovery Appliance, Active Data Guard, and Oracle GoldenGate for disaster recovery. It assumes the
reader already has a basic technical knowledge of each solution.
评论