Oracle Training Oracle Support Development Oracle Apps

 E-mail Us
 Oracle Articles
New Oracle Articles

 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog

 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Oracle Support

 SQL Tuning

 Oracle UNIX
 Oracle Linux
 Remote s
 Remote plans
 Application Server

 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S


 Consulting Staff
 Consulting Prices
 Help Wanted!


 Oracle Posters
 Oracle Books

 Oracle Scripts

Don Burleson Blog 







Oracle Data Guard Training

© 2007-2016 by Burleson Corporation


This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring


Key Features

* Learn secrets for Data Guard implementation standby and failover

* Understand the Oracle10g Data Guard architecture

* Ensure success with a first-time failover database implementation

* See how to use Recovery Manager with Data Guard

* Learn the expert troubleshooting Tips and Techniques

* Get working scripts to perform Data Guard administration and monitoring



Course Description

Unlike some mediocre Oracle Data Guard training, this course examines all Oracle Data Guard features with an eye on those features that are the most important to you.

This Oracle Data Guard training is special because this course is taught by a veteran Oracle Certified DBA with more than 20 years of full-time experience.  This Oracle Data Guard class can also be customized according to your specific needs.

Book Required

Oracle Data Guard
Standby Database Failover Handbook

Bipul Kumar



This Oracle Data Guard training course is designed for practicing Oracle professionals who have basic experience with Oracle. Prior experience with Oracle is not required, but experience using Oracle database is highly desirable.


Curriculum Design

This Oracle Data Guard training course was designed by Donald K. Burleson, an acknowledged leader in Oracle database administration.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including Oracle High-Performance SQL tuning.  Burleson also served as the Editor for the premier book Oracle Data Guard by Rampant TechPress.  Burleson Corporation instructors offer decades of real world DBA experience in Oracle features, and they will share their Oracle secrets in this intense Oracle Data Guard training. 

Oracle Data Guard Training
3-Day Syllabus

Copyright © 2007-2016 by Donald K. Burleson



01 - Introduction to Data Guard
  What is Oracle Data Guard
  MAA - Maximum Availability Architecture
     Primary Database
     Standby Database
        Physical Standby Database
        Logical Standby Database
        Snapshot Standby Database
  Data Guard Services
     Redo Transport Services
     Apply Services
     Role Transitions
  Data Guard Broker
  Protection Modes
     Physical Redo Architecture
  Logical SQL Apply
  Redo Transport
  After Standby Startup
  Standby Startup
  Logical Apply
  Gap Detection and Resolution
  Complimentary Technology
  Benefits of Using Data Guard
02 - Creating a Physical Standby (SQL & RMAN)
  Preparing the Primary   
  Force Logging   
  Configuring Standby Redo Logs   
     Logfiles on the Standby  
     Standby Redo Logs  
     Using SQL to Create SRLs   
  Initialization Parameters on Primary  
  Role-Based Destinations   
  Redo Transport Mode  
  Oracle Net for Physical Standby  
  Creating a Listener Entry   
  Copying the Primary's Password File   
  Standby Init.ora File   
  Directory Path on the Target  
  Starting the Physical Standby  
  Invoking RMAN  
  Real-Time Apply  
  Starting Redo Apply  
  Standby on the Same Server  
  Data Corruption  
  Lost Write Detection
03 - Overview of Data Guard Broker
  Data Guard Broker Components
  Broker Configuration
  Data Guard Broker Architecture
  DMON Process
  Benefits of Using Data Guard Broker
  DGMRL Commands
  Enterprise Manager
04 - Creating a Data Guard Broker Configuration
  Configuration File
  Log Files
  Changing Properties
  Database Properties
  Disable Broker Management
05 - Creating a Physical Standby Using Enterprise Manager
  Creating Physical Standby
  Physical Standby via EM


06 - Configuring Data Protection Modes
  Data Protection Modes
     Maximum Protection
     Maximum Availability
     Maximum Performance
   How to Set the Mode
     Using Grid Control to Set the Mode
07 - Monitoring a Data Guard Configuration
  Monitoring Using Enterprise Manager
  Viewing Data Guard Status
  Data Guard Performance
     Viewing Data Guard Performance
     Viewing Log Files
     Data Guard Metrics
     Viewing Diagnostic Information
     Destination Settings
08 - Optimizing a Data Guard Configuration
  Monitoring Performance
  Optimizing Redo Transport
  Optimizing Redo Transmissions
  MaxConnections Database Property
  RedoCompression Property
  Delaying the Application of Redo
09 - Using Flashback Database in a Data Guard Configuration
  Flashback Database
     Configuring Flashback Database
     Enable Flashback Database
  Flash Recovery Area
  Flashback and Role Transitions
  Flashback Database After Failover
  Flashback Database Scenario
10 - Performing Role Transitions
  Role Transitions
  Role Management Services
  Switchover Using DGMGRL
  Switchover Using Enterprise Manager
    Failover Using DGMGRL
    Re-enable Disabled Databases
    Failover Using Enterprise Manager
    Failover - Back on the Standby
11 - Backup and Recovery Considerations
  RMAN in Data Guard
  Maximum Availability Architecture (MAA)
  Offload Backups to a Physical Standby
  RMAN Recovery Catalog
     Create the Recovery Catalog
     Register the Primary Database
  Persistent Configuration Settings
  RMAN Parameters for Primary
  RMAN Parameters for Standby
  Daily Incremental
  RMAN Script
  Loss of Data File on Primary
  Using a Backup
  Using the Physical Standby
  Recovering a File on the Standby
  Block Media Recovery
12 - Managing Client Connectivity
  Client Connectivity Issues
  Helping Make the Right Connection
  Managing Services
  Client Failover
     Automating Client Failover
     Client Failover Components
  Automatic Failover to a New Primary
  Data Guard Broker and FAN
  OCI Clients
  OLE DB Clients
  JDBC Clients
  Service Names and tnsnames.ora File
13 - Patching & Upgrading Databases in a Data Guard Configuration
  Data Guard Broker
  Upgrading with a Physical Standby
  Rolling Upgrade Workflow
     Rolling Upgrade



This is a BC Oracle training course (c) 2007-2016



Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational