back to Course Categories | back | print
Oracle11g Data Guard Administration          

Duration: 3 days

Description 
This class will teach students how to use the Oracle11g Data Guard to protect Oracle databases. Students will learn how to setup and administer a Data Guard environment. Best practices, troubleshooting and performance tuning will be covered. Logical standby improvements, enhancements to the data guard broker and environment will be covered.

Topics

  • The Data Guard Architecture
  • Fundamentals of a Physical Standby Database
  • Fundamentals of a Logical Standby Database
  • Standby database modes
  • Working with multiple standby databases
  • Log transport and apply
  • Log writing process
  • No data loss
  • No data divergence
  • SYNC versus ASYNC transmission
  • AFFIRM versus NOAFFIRM
  • Redo log reception
  • Role Management Services
  • Archive log gap detection
  • Archive log gap resolution
  • Data protection modes
  • Configuring Data Guard
  • Setting initialization parameters
  • Performance tuning Data Guard
  • Troubleshooting Data Guard
  • Data Guard Diagnostic Information
  • The Data Guard Broker architecture
  • Data Guard Broker components
  • Configuring the Data Guard Broker
  • Creating a physical standby database
  • Opening a physical standby in read-only mode
  • Setting up block change tracking on physical standby
  • Managing a physical standby database
  • Physical standby configurations
  • Creating a logical standby database
  • Managing a logical standby database
  • Logical versus physical standby
  • Logical standby configurations
  • Performing switchover and Failover
  • Client failover methods
  • Graceful failover
  • Forced failover
  • Flashback Database
  • Real-time apply
  • Apply delay
  • Cascaded destinations
  • Data protection modes
  • Pre-Switchover considerations
  • Work with network encryption
  • Create a logical standby control file
  • Standby redo logs
  • Managed recovery control options
  • Real time apply
  • Upgrading Databases in Data Guard Environment
  • Rolling Upgrades
  • Upgrading Data Guard from 10g to 11g

Prerequisites
A solid understanding of Oracle database administration is required. Knowledge of Oracle 11g Database Server is recommended.


 
 
 

Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800
email: info@trubix.com
....................................................................................................................................................................

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes

 

 
all content property © 2006, 2007Trubix Inc.| site design by Art Z design