1 Oracle Data Guard: Overview
After completing this lesson, you should be able to do the following:
Describe the factors that affect planned and unplanned downtime
Describe the basic components of Oracle Data Guard
Explain the differences between physical and logical standby databases
Explain the benefits of creating a Data Guard environment
Explain the use of Data Guard in high-availability architectures
1
Oracle Data Guard: Overview
Copyright © 2006, Oracle. All rights reserved.
Objectives
After completing this lesson, you should be able to do the
following:
• Describe the factors that affect planned and unplanned
downtime
• Describe the basic components of Oracle Data Guard
• Explain the differences between physical and logical
standby databases
• Explain the benefits of creating a Data Guard
environment
• Explain the use of Data Guard in high-availability
architectures
1-2 Copyright © 2006, Oracle. All rights reserved.
Causes of Data Loss
Hardware & system errors 49%
Human errors 36%
Computer viruses 7%
Software corruption 4%
Natural disasters 3%
Source: Disaster Recovery Journal
1-3 Copyright © 2006, Oracle. All rights reserved.
Understanding the Causes of Downtime
Storage
failure
Computer
failures
Unplanned Human
downtime error
Data
failures
Corruption
Data Site
changes failure
Planned
downtime
System
changes
1-4 Copyright © 2006, Oracle. All rights reserved.
What Is Oracle Data Guard?
Primary Standby
database Redo transport database
Oracle Net
Database Database
copy
1-5 Copyright © 2006, Oracle. All rights reserved.
Types of Standby Databases
There are two types of standby databases:
• Physical standby database
– Identical to the primary database on a block-for-block
basis
– Synchronized with the primary database through
application of redo data received from the primary
database
• Logical standby database
– Shares the same schema definition
– Synchronized with the primary database by transforming
the data in the redo received from the primary database
into SQL statements and then executing the SQL
statements
1-6 Copyright © 2006, Oracle. All rights reserved.
Oracle Data Guard Broker Framework
Oracle
Management
Server
Repository
Agent Agent
Primary Standby
database database
Data Data
Guard Guard
broker Enterprise Manager broker
CLI management client
1-7 Copyright © 2006, Oracle. All rights reserved.
Types of Services
There are three types of services provided with Data Guard:
• Redo transport services
• Log apply services
– Redo Apply
– SQL Apply
• Role-management services
1-8 Copyright © 2006, Oracle. All rights reserved.
Role Transitions: Switchover and Failover
• Oracle Data Guard supports two role-transition
operations:
– Switchover
—
Planned role reversal
—
Used for OS or hardware maintenance
– Failover
—
Unplanned role reversal
—
Use in emergency
—
Zero or minimal data loss depending on choice
of data protection mode
—
Can be initiated automatically when fast-start failover is
enabled
• Role-transition operations are not automatically invoked.
1-9 Copyright © 2006, Oracle. All rights reserved.
1 - 10 Copyright © 2006, Oracle. All rights reserved.
Data Protection Modes
• Maximum protection
• Maximum availability
• Maximum performance
1 - 11 Copyright © 2006, Oracle. All rights reserved.
1 - 12 Copyright © 2006, Oracle. All rights reserved.
Benefits of Implementing
Oracle Data Guard
Oracle Data Guard provides the following benefits:
• Continuous service through disasters or crippling data
failures
• Complete data protection against corruptions and data
loss
• Efficient use of system resources
• Elimination of idle standby systems
• Flexible configuration of your system to meet business
protection and recovery requirements
• Centralized management
1 - 13 Copyright © 2006, Oracle. All rights reserved.
Role of Data Guard in a
High-Availability Architecture
Computer RAC
failures
Storage
failure
ASM
Human Flashback
error technology
Data
failures
Oracle HARD
Corruption RMAN
Site
Data Guard
failure
1 - 14 Copyright © 2006, Oracle. All rights reserved.
Role of Data Guard in a
High-Availability Architecture
• Online schema and
data reorganization
Data • Partitioned tables
changes and indexes
• Dynamic resource
provisioning
Planned
downtime
• Rolling patch updates
System • Rolling release upgrade
changes using Data Guard
SQL Apply
1 - 15 Copyright © 2006, Oracle. All rights reserved.
Oracle Data Guard and
Real Application Clusters
Oracle Data Guard and Real Application Clusters are
complementary and can be used together.
• Real Application Clusters provides high availability.
• Oracle Data Guard provides disaster protection and
prevents data loss.
1 - 16 Copyright © 2006, Oracle. All rights reserved.
Maximum Availability Architecture
Clients
Oracle WAN traffic Oracle
Application manager Application
Server Server
Data Guard RAC RAC
RAC
production physical logical
database standby standby
database database
1 - 17 Copyright © 2006, Oracle. All rights reserved.
Summary
In this lesson, you should have learned how to:
• Describe the basic components of Oracle Data Guard
• Describe the differences between physical and logical
standby databases
• Determine when Oracle Data Guard is an appropriate
solution in your Oracle Database configuration
• Explain the use of Data Guard in high-availability
architectures
1 - 18 Copyright © 2006, Oracle. All rights reserved.
Practice 1: Overview
This practice covers the following topics:
• Reviewing the factors that affect planned and unplanned
downtime
• Reviewing the differences between physical and logical
standby databases
• Reviewing the components of Oracle Data Guard
1 - 19 Copyright © 2006, Oracle. All rights reserved.
1 - 20 Copyright © 2006, Oracle. All rights reserved.