Oracle Database Data Guard

Prerequisites:

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

Course Description:

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.

This course is suitable for users of Oracle 9i, Oracle Database 10g and Oracle Database 11g.

This course is designed for database administrators and technical support staff who are required to plan and implement Oracle Data Guard configurations.

This course includes the following modules:

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

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