By using our website you agree to our use of cookies.

Oracle Database Data Guard

4 Day Course
Hands On
Code O18CDG

Book Now - 2 Delivery Methods Available:

Classroom Virtual Classroom Private Group - Virtual Self-Paced Online

Overview

This course introduces the main architectural concepts of Oracle Data Guard. The delegate will learn how to use Oracle Data Guard to protect an Oracle Database against planned and unplanned downtime.

The delegate will also learn how to create and manage physical, logical and snapshot standby databases and how to use standby databases for reporting, querying and testing purposes.

Versions supported 12cR2, 18c, 19c.

Objectives

The delegate will learn and acquire skills as follows:

  • Preparing a Primary Database for a Data Guard Configuration
  • Creating a Physical Standby Database
  • Creating a Logical Standby Database
  • Creating a Snapshot Standby Database
  • Monitoring a Standby Database Configuration
  • Managing a Data Guard Configuration
  • Troubleshooting Standby Database Configurations
  • Tuning a Standby Database
  • Backing up and Recovering a Data Guard Configuration
  • Using Flashback in a Data Guard Configuration
  • Using the Data Guard Broker
  • Managing a Configuration using the Broker
  • Overview of Patching and Upgrading
View detailed Course Modules

Target Audience

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

Additional Information

  • Course technical content is subject to change without notice.
  • Course content is structured as sessions, this does not strictly map to course timings. Concepts, content and practicals often span sessions.

Training Partners

We work with the following best of breed training partners using our bulk buying power to bring you a wider range of dates, locations and prices.

Modules

Hide all

Data Guard Overview (10 topics)

  • 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 (6 topics)

  • 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 (11 topics)

  • 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 (5 topics)

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

Redo Apply Services (2 topics)

  • Apply Services Configuration Options
  • Terminate Redo Apply Services

Role Transition Using SQL Commands (5 topics)

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

Change Management (6 topics)

  • 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 (4 topics)

  • 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 (8 topics)

  • 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 (10 topics)

  • 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 (10 topics)

  • 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 (7 topics)

  • 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 (7 topics)

  • 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 (6 topics)

  • 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 (4 topics)

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

Manage a Configuration Using the Broker (7 topics)

  • 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 (6 topics)

  • 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

Overview of Patching and Upgrading Databases In a Data Guard Configuration (7 topics)

  • Upgrade the Oracle Data Guard Broker Configuration
  • Upgrade the Oracle Database in a Data Guard Configuration with a Physical Standby Database
  • Upgrade the Oracle Database in a Data Guard Configuration with a Logical Standby Database
  • Use DBMS_ROLLING to Upgrade a Database
  • Leading Group Databases and Leading Group Master
  • Trailing Group Databases and Trailing Group Master
  • Use DBMS_ROLLING to Carry out a Rolling Database Upgrade

Data Guard Quick Setup Guide (11 topics)

  • Data Guard Physical Standby Setup using the Data Guard Broker
  • Primary Server Setup
  • Configure Initialization Parameters
  • Service Setup
  • Standby Server Setup
  • Create a Standby Database using DUPLICATE
  • Enable the Broker
  • Database Switchover
  • Database Failover
  • Read-Only Standby and Active Data Guard
  • Snapshot standby

Prerequisites

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

This course is run on a Linux operating system, a good working knowledge of UNIX/Linux is required. This knowledge can be gained by attendance on the pre-requisite Linux Introduction course.

Where Oracle 12c courses are listed in the Pre-requisite Courses section equivalent Oracle 18c or Oracle 19c courses would also suffice.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

Scheduled Dates

Please select from the dates below to make an enquiry or booking.

Pricing

Different pricing structures are available including special offers. These include early bird, late availability, multi-place, corporate volume and self-funding rates. Please arrange a discussion with a training advisor to discover your most cost effective option.

Code Location Duration Price Jan Feb Mar Apr May Jun
O18CDG 4 Days $2,860
O12CDG 4 Days $2,860
Next 6 Months
Oracle 12c Training Courses

Course PDF

Print

Share this Course

Share

Recommend this Course

Sections