Free Oracle Tips

HTML Text

Home
E-mail Us
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

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 Consulting 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

1 - Introduction to Data Guard

Standby Database Concepts

History of Standby Database

Chronological Development of Standby Technology

Types of Standby Databases

Physical Standby Database

Logical Standby Database

Archive log repository

Benefits and Drawbacks

Disaster Protection

Load Balancing

Automated Management

Not a cheap option

Operational Constraints

Lifecycle of Standby Database

A Sample Configuration

Summary

02 - Data Guard Architecture

Architectural Components

Process Architecture

Redo Log File

Archived Redo Log File

Data Guard Apply Modes

Redo Apply Mode

SQL Apply Mode

Log Miner Technology

Archive Gap Sequence

Detection And Resolution

Data Guard Broker Architecture

Configuration, Sites And Resources

Server Side Components Of The Broker

Client Side Components Of The Broker

Role of Transport Network Substrate

03 - Implementing Standby Databases

Physical Standby Database

Manual Recovery Physical Standby Database

Managed Recovery Physical Standby Database

Read-Only Physical Standby Database

Creating Physical Standby Database

On A Remote Host Machine

Preparing To Create Physical Standby Database

Backup Primary Database

Modifying Initialization Parameter file

Oracle Net Configuration

Starting Standby Database

Verify Physical Standby Database

On A Local Host Machine

Modifying Initialization Parameters

Oracle Net Configuration

Starting Standby Database

Accommodating Difference In Directory Structure Between Primary And Standby Site

Creating Logical Standby Database

Limitations of Logical Standby Database

Requirements for Logical Standby Database

Creating A Logical Standby database

Backup Primary Database

Building LogMiner Dictionary

Oracle Net Configuration

Modifying Initialization Parameter File

Changes on Logical Standby Site

Sample Configuration

DAY 2

04 - Standby Database Administration

Administration Of Physical Standby Database

General Administration Tasks

Controlling Managed Recovery Process

Opening Standby Database in Read-only mode

Manually Recovery of Standby Database

Shutting Down Standby Database

Monitor Physical Standby Database

Tools For Monitoring Standby Database

Recovery Progress On Standby Site

Propagating Unrecoverable Operations To Standby Database

Changes In The Tablespaces Or Datafiles

Reset Online Redo Logs On Primary Database

Datafile Name Changes On Primary Database

Changing Initialization Parameter On Primary Standby Database

Physical Standby Database With Time Lag

Resolving Archive Gap Sequence On Physical Standby Database

Administration Of Logical Standby Database

Starting Up And Shutting Down A Logical Standby Database

Starting and Stopping Log Apply Service

Monitoring Logical Standby Database

Tools to monitor logical standby site

Monitoring Overall Progress Of SQL Apply Operation

Monitoring Log Apply Services

Managing Schema Objects

Managing Tables In Logical Standby Database

Logical Standby Database With Time Lag

Resolving Archive Gap Sequence On Logical Standby Database

Cascaded Standby Database

Using Physical Standby Database For Cascaded Standby Database

Using Logical Standby Database For Cascaded Standby Database

Impact On Other Standby Database In Configuration

Transparent Application Failover

05 - Log Management Services

Log Transport Services

Log Apply Services

Physical Standby Database

Logical Standby Database

Log Management Policies

Factors Influencing Log Transport Policies

A Sample Log Management Policy

Standby Redo Logs

Log Transport Service Transmission Attributes

Process To Transfer Redo Data

Network Characteristics Influencing Redo Transmission

Acknowledging Redo Disk I/O Operation On Standby Database

Standby Database Protection Modes

Protection Modes In Oracle9i Release 1

Guaranteed Protection Mode

Instant Protection Mode

Rapid Protection Mode

Delayed Protection Mode

Protection Modes In Oracle9i Release 2

Maximum Protection

Maximum Availability

Maximum Performance

Summary

06 - Switchover And Failover

Types Of Database Role Transitions

Role Transition Using Switchover

Role Transition Using Failover

Graceful Failover

Forced Failover

Determining A Suitable Standby Database For Role Transition

Disadvantages Of Transitioning To Logical Standby Database

Switchover Operation

Preparing Primary Database For Switchover

Preparing Standby Database For Switchover

Physical Standby Database

Logical Standby Database

Switchover To A Physical Standby Database

Switchover To A Logical Standby Database

Verify Switchover Operation

Failover Operation

Failover To A Physical Standby Database

Failover To A Logical Standby Database

Verify Failover Operation

Impact On Other Standby Database In Configuration

Transparent Application Failover

DAY 3

07 - Management Using Data Guard Broker

Creating Data Guard Configuration

Managing Data Guard Configuration

Managing Site

Managing Database Resources

Switchover & Failover using DG Broker

Gathering Statistic using BG Broker

08 - Performance Tuning Of Data Guard Configuration

Understanding Tuning Requirements

Monitoring Data Guard Performance

Tuning Log Transfer Service

Determining Optimal Network Bandwidth

Gathering Oracle Net Related Statistics

Network Tuning for Log Transport Service

I/O Activity on the Standby Host

Tuning Log Apply Services

Understanding Memory Usage during Log Apply

Tuning Memory Usage

Wait Events Specific to Standby Database

Tuning SQL Apply Operation

Configuring Standby Database for high performance

09 - Oracle10g Data Guard New Features

10 - Using RMAN for Standby Database