Data Guard Administration

 Click here

Course Overview

This course teaches students how Data Guard can be used to develop highly available Oracle database environments and introduces students to the features used to minimize system downtime and prevent data loss. Hands-on practice sessions are designed to give students an opportunity to create physical and logical standby databases and use Enterprise Manager Grid Control to manage the Data Guard configuration.

Course Goals

• Understanding the Data Guard architecture
• Modifying Data Guard services
• Using the Data Guard broker
• Implementing physical and logical standby databases
• Performing failover and switchover operations
• Enabling fast-start failover

Prerequisites

• Participants to have general understanding Oracle Database 10g

Who Should Attend?

• Database Administrators
• Support Engineers
• Technical Consultant

Course Materials

• Student Handbook
• Data Guard Reference Book

Duration

• Three (3) days

Course Outline

• Introduction
  • What is Oracle Data Guard
  • Types of Standby Databases
  • Data Guard Broker Framework
  • Types of Services
  • Benefits of Implementing Data Guard
• Data Guard Architecture
  • Oracle Data Guard Architecture
  • Redo Apply
  • SQL Apply
  • Role-Based Destinations
  • Standby Redo Logs
  • Standby Database Modes
• Data Guard Broker & Enterprise Manager
  • Data Guard Broker Features
  • Data Guard Broker Configurations
  • Data Guard Broker Benefits
  • Data Guard Broker Benefits
  • Data Guard Broker Interfaces
  • Using Enterprise Manager 10g Grid Control
• Physical Standby Databases
  • Preparing the Primary Database
  • Setting Parameters on the Primary Database
  • Backing Up the Primary Database
  • Creating the Standby Control File
  • Setting Parameters on the Standby Database
  • Settup Up the Standby Database Environment
  • Starting the Physical Standby Database
  • Additional Configuration Tasks
• Data Protection Modes & Log Transport Services
  • Setting the Log Transport Mode
  • Setting the Data Protection Mode
  • Timing Redo Apply
  • Additional Log Transport Factors
• Logical Standby Databases
  • Preparing to Create a Logical Standby Database
  • Creating a Physical Standby Database
  • Transitioning to a Logical Standby Database
  • Opening the Logical Standby Database
  • Additional Configuration Tasks
• Switchover & Failover
  • Choosing the Transition Role
  • Switchover Using Enterprise Manager
  • Switchover Using SQL
  • Failover Using Enterprise Manager
  • Failover Using SQL
  • Restoring Databases after Role Transition
  • Flashback through Role Transitions
• Fast-Start Failover
  • When Does Fast-Start Failover Occur
  • Configuring Fast-Start Failover
  • Managing the Observer
  • Performing Role Changes
  • Fast-Start using Enterprise Manager
• Data Guard in RAC Configurations
  • Real Application Clusters & Data Guard
  • Configuring a Primary Database with RAC
  • Configuring a Standby Database with RAC
  • Apply Instance Failover
  • Role Transitions with RAC
• Other Considerations
  • Read/Write Testing using a Physical Standby Database
  • Offloading Backups to a Physical Standby Database
  • Using Flashback Database & Real-time Apply
  • Using Flashback Database After RESETLOGS
  • Redo Encryption
  • Cascaded Redo log Destinations