Oracle Database Data Guard — A 3-Day Course

Synopsis

This course introduces the delegate to the main architectural concepts of Data Guard. Delegates will learn how to use Oracle Data Guard to protect Oracle Databases against planned and unplanned downtime. They will also learn how to create and manage physical and logical standby databases. Note that this course is suitable for users of Oracle 9i, Oracle Database 10g and Oracle Database 11g.

Objectives

After completion of this course, delegates will be able to:

Preparing a Primary Database for a Data Guard Configuration
Monitoring a Standby Database Configuration
Managing a Data Guard Configuration
Creating a Physical Standby Database
Creating a Logical Standby Database
Troubleshooting Standby Database Configurations

Suitable For

This course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations. The course is suitable for users of Oracle 9i, Oracle Database 10g and Oracle Database 11g databases.

Prerequisites

A working knowledge of Oracle Database Administration is required. This can be obtained by attendance on the pre-requisite course:

Oracle Database 10g or 11g DBA - Part I

Publicly scheduled dates, locations, and prices

A schedule of dates for this course is not currently available. Please call 0800 651 0338 or use our contact form to enquire about places and availability.

Outline Course Contents

Data Guard Overview

Requirements for Maintaining a Standby Database
Data Guard Terminology
Levels of Protection
Data Guard Monitor
Physical and Logical Standby Databases
Role Management Services
Failover and Switchover
Data Guard Interfaces
Standby Database Creation
Data Guard Installation

Data Guard Architecture

Data Guard Configurations
Data Guard Architecture
Log Transport Services
Log Apply Services
Processes Active in Standby Configurations
Data Guard Architecture and Initialization Processes

Create a Physical Standby Database with SQL Commands

Prepare the Primary Database
Datafile and Controlfile Duplication
Initialization Parameters for a Standby Database
Create the Standby Instance
Networking Issues
Verify Primary and Standby Databases are Working
Archive Log Loss
Database Switchover
Run the Data Guard Configuration
Shut Down and Start Up the Data Guard Environment
Monitor the Primary and Standby Databases

Redo Transport Services

How Data Guard Sends Redo Data
Control when Redo Data is Sent
Handle Transmission Errors
Manage Archive Gaps
Levels of Protection

Redo Apply Services

Apply Services Configuration Options
Terminate Redo Apply Services

Role Transition Using SQL Commands

Preparing the Primary Database
Preparing the Standby Database
Switchover
Failover
The Failed Primary

Change Management

Adding Datafiles or Tablespaces
Dropping Datafiles or Tablespaces
Transportable Tablespaces
Renaming Datafiles
Adding or Dropping Redo Log Files
Nologging Operations

Create a Standby Database with Recovery Manager

Create a Suitable Backup with RMAN
Standby Path and File Names
Build the Standby Instance
Build the Standby Database with RMAN

Creating a Logical Standby Using SQL Commands

Preparing the Primary
Convert Physical Standby to Logical Standby
Rebuild the Password File
Start the Standby Instance
Verify Primary and Standby Databases are Working
Real Time Apply
Useful Dictionary Views
Monitoring SQL Apply Progress

Managing a Logical Standby Database

SQL Apply Architecture
Transaction Size Considerations
DML and DDL Apply Considerations
Intercept DDL Statements
Skip DML and DDL on the Standby
Modify a Logical Standby Database
Materialized Views
Table Instantiation
Restart SQL Apply
Customize DBA_LOGSTDBY_EVENTS

Tuning a Standby Database

Overview of Tuning a Standby Database
Tables without Primary Keys
Statistics on the Logical Standby
Transaction Consistency
Adjusting the Number of Applier Processes
Adjusting the Number of Preparer Processes
Tuning the Memory for the LCR Cache

Backup and Recovery Considerations

Backup and Recovery Strategy
Backup the Primary Database with a Physical Standby Database
Backup a Logical Standby Database
Recovery from Loss of Datafiles
Recovery from Loss of Control Files
Loss of Online Redo Logs
Flashback Database Features in a Data Guard Configuration

Data Guard Broker Overview

Oracle Enterprise Manager
Command Line Interface
Data Guard Monitor
Installing Data Guard
Using the Data Guard Broker
Starting up the Data Guard Broker

Build a Configuration using the Broker

Preparation
Configuring the Primary System
Configuring the Standby System
Enable and Disable the Configuration

Manage a Configuration using the Broker

Database Properties
Set the Configuration Protection Mode
Configure Fast Start Failover
Execute a Switchover
Execute a Failover
Alter the state of a Database
Monitor the Configuration

Data Guard and Oracle Enterprise Manager

Access the Data Guard User Interface
Configure fast Start Failover
Execute a Switchover
Execute a Failover
Alter the state of a Database
Monitor the Configuration

Printer-friendly version

Oracle Training training UK enquiries

UK Training enquiries and feedback form.

Oracle Training training UK prices

For publicly scheduled training (individual places), see our UK training schedule.

For current special offers on courses, see our Special Offers section.

In-house training for company groups is charged at a daily rate per group — see our In-House UK Training Guidelines.

Publicly Scheduled Training Locations

We currently run public training courses across the UK including following locations:

London, UK
Leeds, West Yorkshire, UK
Aberdeen, Scotland, UK
Bradford, West Yorkshire, UK
Birmingham, West Midlands, UK
Bournemouth, Dorset, UK
Bristol, South West
Carshalton, Surrey, UK
Chester, North West, UK
Cheshire, North West, UK
Coventry, West Midlands, UK
Crawley, West Sussex, UK
Derby, East Midlands, UK
Dublin, Ireland
Edinburgh, Scotland, UK
Exeter, South West, UK
Glasgow, Scotland, UK
Harrogate, North Yorkshire, UK
Harwell, Oxfordshire, UK
Hinckley, Leicestershire, UK
Lancashire, North West, UK
Liverpool, North west, UK
Maidenhead, Berkshire, UK
Manchester, North West, UK
Milton Keynes, Buckinghamshire, UK
Nottinghamshire, East Midlands, UK
Reading, Berkshire, UK
Sheffield, South Yorkshire, UK
Slough, Berkshire, UK
Stevenage, Hertfordshire, UK
Swindon, South West, UK
Tyne and Wear, North East, UK
Wakefield, West Yorkshire, UK
Wokingham, Berkshire, UK
Wiltshire, South West, UK
Wirral, North West, UK

Most UK public training courses are available on a monthly basis.

Please see the individual course outlines or our public training schedule for details.

In-house (on-site) training locations

We deliver in-house courses at client premises and/or training facilities in any part of the world which is practically and commercially accessible.

Our In-house training guidelines outline our basic requirements and our UK pricing structure. To estimate costs for training in other countries, simply convert to your local currency and then make a rough calculation of our tutor's costs for travelling to and staying at your location.