Oracle 11g DataGuard

Course ID

31112

Course Description

Business continuity and disaster recovery are top priorities for the senior management of most global enterprises. Economic fluctuations, rapid changes in market trends, and competitive pressures imply that the global enterprise of today must operate in a 24x7 environment, and must be able to swiftly and efficiently deal with unforeseen business interruptions. Oracle Data Guard is the most effective solution available today to protect the core asset of any enterprise - its data, and make it available on a 24x7 basis even in the face of disasters and other calamities. This course discusses Oracle Data Guard 10g technology, and demonstrates how it is one of the most important elements in the business continuity infrastructure of any enterprise. Oracle Data Guard is the most effective and comprehensive Disaster Recovery solution available today for enterprise data.

Prerequisites

Before taking this course, students are recommended to attend the following classes
  • Oracle Database 11g: Administration I
  • Oracle Database 11g: Administration II
  • Oracle Database Administration experience including RMAN

Audience

  • Oracle Database Administrators
  • System Administrators

Course Content

    Overview of Oracle10g/11g Data Guard
  • Objectives
  • Causes of data loss
  • What is Oracle Data Guard
  • Types of standby databases
  • Oracle Data Guard Broker Framework
  • Types of services
  • Role transitions: Switchover and failover
  • Data protection modes
  • Benefits of Oracle Data Guard
  • Summary

    Understanding the Oracle Data Guard Architecture
  • Objectives
  • Data Guard Operational Requirements: Hardware and OS
  • Data Guard Operational Requirements: Software
  • Oracle Data Guard Architecture
  • Primary Database Flow
  • Standby Database Flow
  • Standby Redo Logs
  • Physical Standby Database: Redo Apply Architecture
  • Logical Standby Database: SQL Apply Architecture
  • SQL Apply Process: Architecture
  • Real-Time apply
  • Standby Redo Log Configuration
  • Standby Database Modes
  • Summary Using Data Guard Broker and Enterprise Manager
  • Objectives
  • Data Guard Broker Features
  • Data Guard Broker Architecture
  • Data Guard Broker Requirements
  • Life Cycle of Data Guard Broker: Architecture
  • Benefits of Using the Data Guard Broker
  • Data Guard Broker Interfaces
  • Benefits of Using Enterprise Manager
  • Using the Command Line Interface of the Data Guard Broker

    Configuring a Physical Standby Database Using SQL
  • Objectives
  • Steps to Create a Physical Standby Database
  • Preparing the Primary Database
  • Setting the INIT parameters on the Primary DB
  • Backing up the Primary DB using RMAN
  • Creating the control file for the Standby DB
  • Copying files to the Standby DB
  • Setting the INIT parameters for the Standby DB
  • Starting the Physical Standby DB
  • Summary

    Configuring Data Protection Modes and Redo Log Transport Services
  • Objectives
  • Data Protection Modes and Redo Transport Modes
  • Data Protection Modes
  • Setting the Data Protection Mode
  • Delaying the application of Redo
  • Summary

    Creating a Logical Standby Database by Using SQL
  • Objectives
  • Preparing to Create a Logical Standby Database
  • Creating a Logical Standby Database
  • Summary

    Performing Switchover
  • Objectives
  • Types of Roles in an Oracle Data Guard Configuration
  • Role Management Services
  • Role Transitions: Switchover
  • Choosing the best Role Transition Operation
  • Switchover
  • Activating a Standby Database
  • Restoring Databases after a Role Transition
  • Summary

    Performing Failover
  • Objectives
  • Types of Roles in an Oracle Data Guard Configuration
  • Role Management Services
  • Role Transitions: Failover
  • Choosing the best Role Transition Operation
  • Failover
  • Activating a Standby Database
  • Restoring Databases after a Role Transition
  • Summary

    Enabling Fast Start Failover
  • Objectives
  • Overview of Fast-Start Failover
  • C Disabling Fast-Start Failover
  • Performing Role Changes
  • Performing a manual Failover
  • Summary

    Other considerations for Oracle Data Guard
  • Objectives
  • Using RMAN to Backup a Physical Standby DB
  • Restrictions and Usage Notes
  • Flashback across Database Changes
  • Enabling Redo Encryption
  • Activating a Physical Standby DB for Reporting
  • Cascaded Redo log Destinations
  • RAC considerations
  • Summary

For More Information

For training inquiries, call 850-308-1376

or email us at eramos@gbsi.com

Course Details

Duration - 3 days
Price - $1895.00 USD


(Discounts may apply. Call for more information.)

Course Actions

Schedule

Acceletrain Collaborative Learning Environment (formerly know as VILT) places industry certified and expert instructors, peers, learners and multi-media components into a "borderless classroom", and interactive learning environment that can span multiple physical locations. VILT combines the benefits of the traditional brick-and-mortar classroom with innovative learning techniques and the cost savings of internet-based training.