Active Data Guard  

 Oracle Active Data Guard


“Active Data Guard 11g was a quick win! We easily dual-purposed our ten terabyte standby database for both disaster protection and for secure read-only access to our public-facing eCommerce applications. We were happy to discover after much effort evaluating other alternatives, that utilizing our existing Data Guard standby database was the simplest solution to provide customers with continuous access to current information.”    Sue Merrigan - Senior Director, Information Management, Intermap Technologies

Oracle Active Data Guard - an option for Oracle Database 11g Enterprise Edition - enhances Quality of Service by offloading resource intensive workloads from your production database to one or more synchronized standby databases. Active Data Guard enables read-only access to a physical standby database for queries, real-time reporting, web-based access, etc., while continuously applying changes received from the production database. Active Data Guard also eliminates the overhead of performing backups on production systems by enabling RMAN block-change tracking and fast incremental backups using a physical standby database.

Active Data Guard's seamless integration with Data Guard capabilities that are included with the Oracle Database Enterprise Edition means Active Data Guard users automatically benefit from Oracle's industry leading high availability and disaster protection and from other new Data Guard 11g features.

The following diagram presents a high level overview of Oracle Active Data Guard.



Active Data Guard Benefits

  1. Increase performance of production database: Offload unpredictable workloads to an up-to-date replica of the production database.

  2. Simplify operations:  Eliminate management complexity that accompanies traditional replication solutions.

  3. Eliminate compromise:  Reporting replica is up-to-date and online at all times - not possible with traditional storage mirroring technology.
    .

  4. Reduce cost: An Active Data Guard physical standby database also provides disaster protection and high availability and can serve as a QA system - no additional hardware or software investment is required.

  5. Reduce backup time:  Complete incremental backups up to 20x faster by using RMAN Block Change Tracking on a  physical standby database.

Active Data Guard Use Cases

Active Data Guard makes it possible to utilize physical standby databases for a wide variety of business purposes.  Different industry examples include:

  • Telecommunications: Field service technicians access to service schedules and customer inquiries to check status of service requests.
  • Heathcare: Fast access to up-to-date medical records.
  • Finance and Administration: Ad-hoc queries, reports, and executive dashboard.
  • Transportation: Package tracking, queries, schedule information.
  • Web-business: Catalog browsing, customer order inquiry, scale-out performance using reader farms.

Active Data Guard Reader Farms

In the example of a Web-business, there is frequently a need to scale out performance to handle catalog queries, order lookup, and other read-only activities that can vary widely depending upon the time of year or other special circumstances that lead to sudden peaks in volume.  Active Data Guard is uniquely suited for these situations, because additional standby databases can easily be provisioned to handle peak periods.  A single production database can support direct connections to up to nine standby databases, creating what is referred to as a Reader Farm.  Addtional cascaded standby databases can be used to scale performance to a virtually unlimited extent. 

The figure below shows an example of a simple Reader Farm.  In addition, because Active Data Guard is compatible with Data Guard functionality - the Reader Farm pictured below has data protection and high availability already built-in.  If the production database fails, any of the standby databases in the configuration can quickly transition to the production role - automatically keeping the remaining standby databases synchronized with the latest transactions.


.
disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, DR, DR, DR, DR,DR, DR,DR, DR,DR, DR, Database Mirroring, Database Mirroring, Database Mirroring, Database Mirroring, HADR, HADR, HADR, HADR, HADR, HADR, HA, HA, HA, HA, HA, HA, DR, DR, DR, DR, DR, DR, disaster recovery, disaster recovery, disaster recovery, disaster recovery, Database Mirroring, HADR, HADR, HADR, HADR, HADR, HADR, HA, HA, HA, HA, HA, HA, DR, DR, DR, DR, DR, DR, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, DR, DR, DR, DR,DR, DR,DR, DR,DR, DR, Database Mirroring, Database Mirroring, Database Mirroring, disaster recovery, business continuity, business continuity, business continuity, business continuity, business continuity, business continuity, disaster recovery, business continuity, business continuity, business continuity, business continuity, business continuity, business continuity, disaster recovery, disaster recovery, disaster recovery, disaster recovery, disaster recovery, DR, DR, DR, DR,DR, DR,data guard, data guard, data guard, data guard, data guard, data guard, data guard, data, guard, data guard, data guard, data guard, dataguard, data guard, data guard, data guard, data guard, data guard
 
Left Curve
Product Information
Right Curve
 · Data Sheet
 · Active Data Guard Best Practices
 · Oracle BI Server & Active Data Guard
 · Active Data Guard FAQ
 · Oracle Data Guard
 · Maximum Availability Architecture
 · Oracle Database High Availability

Left Curve
Webcasts/Podcasts
Right Curve
 · Production User Experience
 · Active Data Guard Overview
 · Oracle Replication  Technologies for High Availability and Disaster Recovery

Left Curve
Demonstrations
Right Curve
 · Maximum Availability Architecture & Active Data Guard
 · Improving Performance using Active Data Guard

Left Curve
Customers
Right Curve
 · Intermap Technologies
 · Real Networks
 · Amazon.com
 · MobilTel & Burlington Coat Factory

Left Curve
Articles
Right Curve
 · Succeeding With Failure, by Ari Kaplan, President, IOUG

Left Curve
Documentation
Right Curve
 · Data Guard 11g Concepts and Administration
 · Data Guard Broker 11g

Left Curve
Training
Right Curve
 · Instructor-led
 · Oracle By Example - Data Guard 11g




E-mail this page
Printer View Printer View
Oracle Is The Information Company About Oracle | Oracle RSS Feeds | Careers | Contact Us | Site Maps | Legal Notices | Terms of Use | Privacy