Oracle Datagaurd

Course Contents

Oracle Data Guard: Overview

• What Is Oracle Data Guard?
• Types of Standby Databases
• Data Guard Broker Framework
• Types of Services
• Benefits of Implementing Oracle Data Guard

Understanding the Oracle Data Guard Architecture

• Oracle Data Guard Architecture
• Data Guard Redo Apply Architecture
• Data Guard SQL Apply Architecture
• Specifying Role-based Destinations
• Configuring Standby Redo Logs
• Standby Database Modes

Using Oracle Data Guard Broker and Enterprise Manager

• Oracle Data Guard Broker Features
• Data Guard Broker Configurations
• Benefits of Using the Data Guard Broker
• Data Guard Broker Interfaces
• Using Enterprise Manager 10g Grid Control

Creating a Physical Standby Database by Using SQL

• Preparing the Primary Database
• Setting Initialization Parameters on the Primary Database
• Backing Up the Primary Database Using RMAN
• Creating a Control File for the Standby Database
• Setting Initialization Parameters on the Standby Database
• Setting Up the Environment to Support the Standby Database
• Starting the Physical Standby Database
• Performing Additional Configuration Tasks

Configuring Data Protection Modes and Log Transport Services

• Setting the Log Transport Mode
• Setting the Data Protection Mode
• Delaying the Application of Redo
• Using Flashback Database as an Alternative to Apply Delay
• Additional Attributes that Affect Log Transport Services

Overview of Logical Standby

• Performing Switchover and Failover
• Choosing the Best Role Transition Operation
• Performing a Switchover by Using Enterprise Manager
• Performing a Switchover by Using SQL
• Performing a Failover by Using Enterprise Manager
• Performing a Failover by Using SQL
• Restoring Databases After a Role Transition
• Flashback Through Standby Database Role Transitions

Enabling Fast-Start Failover

• When Will Fast-Start Failover Occur?
• Configuring Fast-Start Failover
• Prohibited Operations After Enabling Fast-Start Failover
• Managing the Observer
• Performing Role Changes
• Using Enterprise Manager to Enable Fast-Start Failover

Using Data Guard in a Real Application Clusters Configuration

• Real Application Clusters and Data Guard
• Configuration Considerations with RAC
• Configuring a Primary Database with RAC
• Configuring a Standby Database with RAC
• Apply Instance Failover
• Role Transitions with RAC

Other Considerations for Oracle Data Guard

• Using a Physical Standby Database for Read/Write Testing and Reporting
• Offloading Backups to a Physical Standby Database
• Using Flashback Database and Real-time Apply
• Using Flashback Database After RESETLOGS
• Enabling Redo Encryption
• Configuring Cascaded Redo Log Destinations

Workshop

• Workshop Premise
• Workshop Flow
• Workshop Scenarios

Top