Oracle Database 12c Data Guard — A 4 day course

contact usEnquire about this course


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 learn how to create and manage physical, logical and snapshot standby databases. They will also learn how to use standby databases in a standby role for reporting, querying and testing purposes.

The Oracle Database 12c Data Guard course is also suitable for users of Oracle Database 11g R2 Data Guard.


The Oracle Database 12c Data Guard course aims to provide the skills needed to plan, implement, manage and troubleshoot Oracle Data Guard standby database configurations.

The delegate will practise:

Suitable For

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

Follow-On Course


A working knowledge of Oracle Database Administration is required. This course is run in a Linux environment and a working knowledge of the UNIX operating system is therefore highly recommended. These skills can be obtained by attending the pre-requisite courses:-

Publicly scheduled dates, locations, and prices

Select a date to enquire about availability of places. For dates after 24 March 2020, please call 0333 210 0140 or use our contact form to enquire about places and availability.

London — £1995 (+VAT)


Data Guard Overview

Data Guard Architecture

Create a Physical Standby Database with SQL Commands

Redo Transport Services

Redo Apply Services

Role Transitiona Using SQL Commands

Change Management

Create a Standby Database with Recovery Manager

Creating a Logical Standby Using SQL Commands

Managing a Logical Standby Database

Tuning a Standby Database

Backup and Recovery Considerations in an Oracle Data Guard Configuration

Use Flashback Database in a Data Guard Configuration

Data Guard Broker Overview

Build a Configuration using the Broker

Manage a Configuration using the Broker

Overview of Patching and Upgrading Databases in a Data Guard Configuration