Data Guard Administration

  • Available in Live training & Self Paced format

  • Impeccable Premium Quality

  • Hands-on Lab Practices

  • Slides & Lab Guide

  • 1 Year, 24/7 unlimited access to Course Recordings

  • Support for Doubts clarification

  • A must course for every Oracle DBA

About the Course

Oracle Data Guard Course teaches the students how to implement and manage Data Guard environments to provide high availability, data protection, and disaster recovery for enterprise data.

In this course, you will:

  • Understand Oracle Data Guard Architecture, Concepts, Components

  • Create and Manage Physical , Logical and Snapshot Standby Databases

  • Manage Data Guard Environment using - SQL Command Interface and DGMGRL interface

  • Manage Redo Apply Services , Transport Services and Role Transitions

  • Configure Fast-Start Failover

and more...

Course Curriculum

  • Introduction to Oracle Data Guard

    • What is Data Guard?

    • Data Guard Configuration

    • Primary Database

    • Standby Database

    • Types of Standby Databases

      • Physical Standby Database

      • Logical Standby Database

      • Snapshot Standby Database

    • Data Guard Architecture

    • Data Guard Benefits

    • Data Guard Services

      • Redo Transport Services

      • Apply Services

    • Role Transition Services

      • Switchover

      • Failover

    • Data Guard Protection Modes

      • Maximum Performance mode

      • Maximum Availability mode

      • Maximum Protection mode

    • Data Guard Operational Prerequisite

      • Hardware and Operating System Requirements

      • Oracle Software Requirements

    • Data Guard Broker

  • Creating and Managing Physical Standby Database

    • Preparing the Primary Database for Standby Database Creation

    • Step-by-Step of Creating Physical Standby Database

    • Post-Creation Steps

    • Starting/Stopping Physical Standby Database

    • Enabling Flashback Database on Physical Standby Database

    • Monitoring Realtime Apply

    • Opening Physical Standby in Read only

    • Configuring Active Data Guard

    • Monitoring Redo Apply

    • Performing Switchover

    • Performing Failover

    • Reinstating the Failed Primary Database

  • Oracle Data Guard Broker

    • Overview of Oracle Data Guard Broker

    • Benefits of Data Guard Broker

    • Components of Data Guard Broker

    • Data Guard Broker Interfaces

    • Data Guard Broker Monitor

    • Installing Data Guard Broker

    • Managing Broker Configurations

    • Managing the Members of a Broker Configuration

    • Switchover and Failover Operations

    • Configuring Fast-Start Failover (FSFO)

    • Enabling/Disabling FSFO

  • Creating and Managing Snapshot Standby Database

    • Converting a Physical Standby Database to Snapshot Standby Database

    • Converting Snapshot Standby back to Physical Standby

  • Creating and Managing Logical Standby Database (LSB)

    • Prerequisite Conditions for Creating a Logical Standby Database

    • Step-by-Step of Creating a Logical Standby Database

    • Post-Creation Steps

    • Starting/Stopping Logical Standby Database

    • Monitoring SQL Apply

    • Controlling User Access to Tables in a LSB

    • Protecting Replicated Objects

  • Data Guard Scenarios

  • and more...

Video Lessons

Materials

Slides
Lab Guide

Introduction to Oracle Data Guard

What is Data Guard?
Preview
Data Guard Configuration
Preview
Types of Standby Databases
Preview
Data Guard Services
Preview
Data Guard Protection Modes
Preview
Data Guard Architecture and Benefits
Preview

Setting up the Lab Environment

Link to download pre-built VM Images
Instructions to Setup Practice Lab Environment

Creating Physical Standby Database

Data Guard Operational Prerequisites
Overview of Creating a Physical Standby Database
Lab Practice: Creating a Physical Standby Database

Managing Physical Standby Database using SQL

Overview of Managing Databases in Data Guard Environment
Lab Practices: Managing Physical Standby Database using SQL

Using Oracle Data Guard Broker

Overview of Oracle Data Guard Broker
Installing Oracle Data Guard Broker
Configuring Member Databases
Creating Broker Configuration
Lab Practice: Configuring Member Databases and Creating Broker Configuration
Lab Practice: Using DGMGRL
Managing Data Guard Configurations
Lab Practice: Managing Data Guard Configurations
Fast Start Fail Over (FSFO)
Lab Practice - FSFO

Creating Snapshot Standby Database

Overview of Snapshot Standby Database
Lab Practice: Creating Snapshot Standby Database

Creating and Managing Logical Standby Database

Overview of Logical Standby Database
Creating and Managing Logical Standby Database