Verhoef Training USA

Training Courses and On-Line Classes Preferred By IT Pros

Visit us at:   http://www.verhoef-training.com

103 Hillside Ave., PO Box 1515
West Caldwell, NJ 07006
Main Office:  800.631.0410
Sales Office:  800.533.3893

Oracle 11g Data Guard

Course:   ORADG
Duration:   3 Days
Level:   II
On our website at:   http://www.verhoef-training.com/courses/ORADG.html
 
Course Summary

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 bale 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 11g 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.

Topics Covered In This Course

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
What You Can Expect

Oracle11g Data Guard class enables the student participants to acquire and develop key skills to effectively implement and administer an Oracle Data Guard environment . This Oracle Data Guard course will:

Who Should Take This Course

Recommended for both Oracle Database Administrators and System Administrators.

Recommended Prerequisites

Attendees should be experienced Oracle Database Administrators, including experience with RMAN.

Training Style

Instructor Led with 50% lecture and 50% lab.

Related Courses
Code Course Title Duration Level
OR11SEC
Oracle Database 11g: Encryption & Advanced Data Security
3 Days
I
Details
ORBKUP
Oracle Database 11g: Backup and Recovery
5 Days
II
Details

Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.

You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.