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 support
Remote plans
Remote services
Application Server
Applications
Oracle Forms
Oracle Portal
App Upgrades
SQL Server
Oracle Concepts
Software Support
Remote Support
Development
Implementation

Consulting Staff
Consulting Prices
Help Wanted!

Oracle Posters
Oracle Books
Oracle Scripts
Ion
Excel-DB

Don Burleson Blog

Oracle Data Guard Training

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

Click here for on-site course prices

Optional supplemental mentoring

* 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

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.

		Oracle Data Guard Standby Database Failover Handbook Bipul Kumar ISBN 0-9745993-8-7

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.

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

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

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

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