Database 10g: Data Guard Administration (3 day)

Course Overview

Learn how to use Oracle Data Guard to help protect the Oracle Database against planned and unplanned downtimes. The Data Guard architecture is used to create physical and logical standby databases, including Primary Database Configuration, Implementation and Monitoring.

Audience

• Oracle Database Administrators
• Oracle Support Engineers

Skills Gained

• Using Oracle Data Guard to help protect the Oracle Database against planned and unplanned downtimes
• Create physical and logical standby databases
• Primary Database Configuration, Implementation and Monitoring

See Course Outline for indepth course content

Prerequisites

• 10g DBA Fundamentals I (O1010)
• Oracle 10g SQL (O011)
• View Learning Path

Course Outline

Oracle Data Guard Introduction

• Describe the basics of Oracle Data Guard
• High availability usage of Data Guard architecture
• Considerations of planned and unplanned down time
• Physical and Logical differences

Oracle Data Guard Architecture

• Data Guard architecture
• Operational requirements of Data Guard
• Advantages of multiple Standby databases

Log Transport Services

• Service architecture
• Capabilities of services
• Service Interfaces
• Describe archive log gap detection
• Data protection modes

Oracle Data Guard Environment

• Understanding the differences of configuration with Data Guard
• Initialization parameters
• Data Guard views
• Performance configurations

Data Guard Broker

• Management Model
• Data Guard Broker architecture
• Data Guard Broker components
• Benefits of Data Guard Broker
• Data Guard Broker configurations
• Configuration management using DGMGRL

Data Guard SQL Architectecture

• When to use a logical standby database
• Create a logical standby database using Enterprise Manager

Switchover and Failover

• Database roles
• Switchover / Failover
• Flashback Database after a failover

Physical Standby Database

• Create & manage a Physical Standby database

Logical Standby database

• Create & manage a Logical Standby database

Further Considerations

• Back up the primary database with a physical standby database
• Back up a logical standby database
• Flashback Database features in a Data Guard configuration
• Encrypt redo information
• Cascaded redo log destinations

Database 10g: Data Guard Administration (3 day) / O10GDG