Oracle 10g Higher Availability using Data Guard

Last week I attended a class with OU in SFO with "Marielle Canning" for Data Guard implementation on Linux env & will be sharing some of my learnings there .....

One of the biggest responsibilities for a DBA is to provide 100% availability and reduce unplanned downtime for a database & Oracle Data Guard is one of the most effective and comprehensive data availability, data protection and disaster recovery solutions available today .

Overview :
    The database size is increasing dramatically every day and our critical business information system requires 24x7 uptime specially in an unplanned downtime when we can loose Data or it might get corrupted & it may take hours, even days to restore such a database. To minimize downtime and avoid data loss, we need a standby database that can take the role of the primary database in a timely fashion & here come the data guard in picture where Data Guard maintains these standby databases as transactionally consistent copies of the production database.

In short Oracle Data Guard is the management, monitoring, and automation software infrastructure that creates, maintains, and monitors one or more standby databases to protect enterprise data from failures, disasters, errors, and corruptions.

Data Guard Functional Components:    
    So here we will discuss what all we need to get the data guard working ....


a) Data Guard Config -A Data Guard configuration consists of one production (or primary) database and up to nine standby databases.

b)Redo Apply and SQL Apply - As Standbys are created from primary , we need the technology to make them at par with the primary by applying Redo to standby.

Data Guard provides two methods to apply this redo data to the standby database :

    * Redo Apply, used for physical standby databases
    * SQL Apply, used for logical standby databases

c)Role Management-Using Data Guard, the role of a database can be switched from a primary role to a standby role and vice versa, ensuring no data loss in the process, and minimizing downtime. There are two kinds of role transitions - a switchover and a failover.

    Switchover - This is used for planned maintaince specially for patching & upgrades .
- Is disaster recovery measure which comes in picture when Primary node is down .

d)Types of standby - we have 2 kinds of stanby data bases :

    Physical Standby - this is a replica of primary database on Block-by-block basis.The database schema, including indexes, are the same.

    Logical Standby - It has the same logical information as primary , but can be used as a seprate database for reporting etc .

e)Data Guard Protection Modes

    Maximum Protection- this is also called no-data-loss mode as here no commit of transaction is done unless teh redo is shipped & applied to atleast one of the standby .But the issue here is that if standby becomes unavailable , primary shuts down .

    Maximum Availability - the only diffenece this has from maximum performace mode is that it doesnt shutsdown db when standby is down , it waits for standby to get up & running and then resync it with primary .

    Maximum Performance- Archiver is used for this to ship the logs , thus the performance is more .The commit operation of the primary database does not wait for the standby database to acknowledge receipt .

f)Data Guard Broker
The Oracle Data Guard Broker is a distributed management framework that automates and centralizes the creation, maintenance, and monitoring of Data Guard configurations.

I will continue on the Data Guard topic for next blog & will include its functionalities , Pros & Cons of all modes , Switch over & Failover process .......
so stay tuned .......


Hi Pankaj, Basics of Data Guard are covered in this topic. You can also include the background processes related to Data Guard. Hope you will include in the next blog.

Posted by Salih on November 01, 2006 at 10:31 PM PST #

Hi Pankaj, I liked your blog specially its because it very simple and easy to understand. I have quite good understanding of Apps & Fusion Middleware & I have zeal to share my knowledge which I am doing via blog. I saw you mentioned that you took class in Oracle University, I am also interested in taking classes (Teaching) for OU courses specially in Application Server 10g & Apps , could you guide me how to contact Oracle University for same. Atul

Posted by Atul Kumar on December 02, 2006 at 11:00 PM PST #

Very nice blog entry. Takes an IQ of zero to understand :-) Keep it coming!

Posted by Thomas Isaksen on December 07, 2006 at 03:58 AM PST #

Hi Pankaj, the blog is very useful, can you please update with the pros and cons of failover process and any daily maintenance/check activites for DR site.

Posted by Ashok Kumar Chelliah on September 10, 2007 at 11:06 PM PDT #

Post a Comment:
  • HTML Syntax: NOT allowed

This blog is authored by Pankaj Chandiramani , Product Manager for Enterprise Manager at Oracle . Main Focus of the blog will be on Enterprise Manager 12c with deep coverage of Database Center Automation including DbaaS , Database Provisioning , Database Patching , Config , Compliance etc .


« June 2016