Oracle Training Oracle Support Development Oracle Apps

 
 Home
 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
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

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

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

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

ISBN
0-9745993-8-7  
 

Audience

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

 

DAY 1

01 - Introduction to Data Guard
 
  What is Oracle Data Guard
  MAA - Maximum Availability Architecture
  Configurations
     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
  Architecture
     Primary
     Standby
     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
  Licensing
 
 
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
 
  Requirements
  Configuration File
  Log Files
  Workflow
  Changing Properties
  Database Properties
  Disable Broker Management
 
 
05 - Creating a Physical Standby Using Enterprise Manager
 
  Creating Physical Standby
  Physical Standby via EM
 

DAY 2

06 - Configuring Data Protection Modes
 
  Data Protection Modes
     Maximum Protection
     Maximum Availability
     Maximum Performance
     Comparisons
   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
 
DAY 3
 
10 - Performing Role Transitions
 
  Role Transitions
  Role Management Services
  Switchover
  Switchover Using DGMGRL
  Switchover Using Enterprise Manager
  Problems
  Failover
    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
     Usage
  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
  AFTER STARTUP Trigger
  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 -  2016

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.