Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Database Data Guard Administration (12c and 19c)

Name: Oracle Database Data Guard Administration (12c and 19c)
Rating: 4.6 (754 reviews)

Learn hands-on Oracle Data Guard administration and manage standby databases with confidence

Highest Rated

Created byAhmed Baraka

Last updated 4/2023

English

What you'll learn

Understand the concepts of Oracle Data Guard architecture
Create, manage, and monitor Physical and Logical Standby databases
Implement and manage Data Guard Broker
Perform Role Transitions: Switchover and Failover
Implement Fast-Start Failover
Implement Oracle Active Data Guard
Create and manage Snapshot Standby database
Implement client failover in a Data Guard Configuration
Use RMAN in a Data Guard environment
Implement Rolling Upgrade using DBMS_ROLLING
Understand the advanced options in Oracle Data Guard

Course content

14 sections • 52 lectures • 12h 35m total length

Introducing the Course7:14
This lecture introduces the course to you. It covers the following topics:

About the Instructor
Course Goal
Who should and should not take the course
Course prerequisites knowledge
Skills you will learn in the course
Course layout
Practice environment requirements
Course curriculum overview
Practice: Create an Oracle 12c Database with ASM (part 1)18:03
In this practice, you will create an Oracle 12c single-instance database with ASM in a virtual machine. This database will be used in the practices of this course. If you already have your own virtual machine that has Oracle dabase 12c installed in it, you can use it and skip this practice. However, I recommend building up this machine because all the examples in the course were taken from a database with configuration and naming similar to the one built in this practice.

The practice document is attached to the lecture extras.

Note: you do not actually need to watch the video. You can go ahead and perform the steps in the attached installation document straight away. The video is there for reference.

Total practice expected duration: 60 minutes
Practice: Create an Oracle 12c Database with ASM (part 2)19:19
This practice is to continue the practice in the previous lecture.
Practice: Create an Oracle 12c Database with ASM (part 3)14:46
This practice is to continue the practice in the previous lecture.
Download Course Documents0:07
This is to download the course documents, including the course slides and practices, all from one place.
Just download them from the downloadable resources section on this lecture.

Introduction to Oracle Data Guard13:46
This lecture introduces Oracle Data Guard. It explains the benefits of Data Guard and its limitations.

By end of this lecture, you should be able to describe and understand the following:

What Is Oracle Data Guard?

Data Guard Usages

Data Guard Limitations
Data Guard Basic Concepts ( Part 1 )15:20
This lectures discusses the fundamental concepts of Oracle Data Guard.

After completing this lecture, you should be able to describe and understand the following topics:

Oracle Data Guard Process Architecture

Types of Data Guard Services

Types of Standby Databases

Data Guard Protection Modes
Data Guard Basic Concepts ( Part 2 )12:30
This lectures discusses the fundamental concepts of Oracle Data Guard.

By end of this lecture, you should be able to describe and understand the following:

Role Transitions: Switchover and Failover

Data Guard Management Tools

Oracle Data Guard Broker Benefits

Flashback Database and Data Guard
Data Guard Concepts

Creating a Physical Standby Database (Part 1)13:24
In this lecture you will learn the procedure you should follow to build a Physical Standby database. By the end of this lecture, you should be able to do the following:

Understand Oracle Data Guard requirements
Plan for creating a physical standby database
Configure LOG_ARCHIVE_DEST_n parameter
Create a physical standby databas
Creating a Physical Standby Database (Part 2)11:43
This lecture is part 2 of the previous lecture.
Practice1: Creating a Physical Standby Database (Part 1)18:19
This practical lecture will take you through a hands-on tutorial that will show you the procedure to create a Physical Standby database.

You do not have to watch the video. You can download the guide document and follow the steps straight away. However, in case you found a stop unclear for you, you can refer to the video to observe how the step could be practically performed.
Practice 1: Creating a Physical Standby Database (part 2)9:30
This is a continuation of the practice # 1, Part 2 of 3.
Practice 1: Creating a Physical Standby Database (part 3)19:51
This is a continuation of the practice # 1, Part 3 of 3.
Creating a Logical Standby Database15:42
This lecture guides you on how to create a logical standby database. After completing this lecture, you should be able to do the following:
Describe the benefits of logical standby database
Describe the drawbacks of logical standby database
The logical standby database practical usages
Understand the unsupported objects and data types
Perform the procedure to create a logical standby database
Practice 2: Creating a Logical Standby Database17:49
This lecture will take you through a tutorial that will show you the hands-on practical procedure to create a Logical Standby database.

Note: as in all the practices in this course, you do not have to watch the video. You can just download the practice document and implement the steps yourself straight away. You can still refer to the video clip to clarify how a step could be practically implemented.

Using the Data Guard Broker (Part 1)17:20
In this lecture you will learn about the Data Guard Broker concepts and how to practically configure it. By the end of the lecture, you should be able to do the following:

Understand the Broker capabilities, benefits, and limitations
Describe the Data Guard Broker components
Understand the Data Guard Broker Configuration Files
Use the DGMGRL command-line interface
Understand the Broker Properties
Perform the procedure to configure the Data Guard Broker
Using the Data Guard Broker (Part 2)15:30
This lecture is to continue the previous lecture.
Practice 3 Creating a Data Guard Broker Configuration18:44
This hands-on tutorial describes the steps to enable the Broker in an Oracle Data Guard environment that have a primary and a physical standby databases.

Managing Physical Standby Database16:10
In this lecture you will learn the management considerations for the physical standby database.

For a physical standby database, you will learn how to do following:

Start or stop redo apply services
Specify time delay in the redo apply
Upgrade or downgrade protection mode
Handle NOLOGGING operations
Describe how to use physical standby database for recovering from data corruption
Practice 4 Changing the Data Guard Protection Mode14:48
In this practice we will upgrade the Protection Mode in our Data Guard configuration twice, first to Maximum Availability and second to Maximum Protection. We will study the how the primary database will respond in each case when the standby database becomes unavailable.
Managing Logical Standby Database17:07
For a logical standby database, in this lecture you will learn how to do the following:
Start and stop SQL Apply service
Define the dataset replicated from the primary database
Protect replicated tables on a logical standby database
Handle unsupported tables
Set the size of memory used by the SQL Apply processes
Practice 5 Managing Logical Standby Database13:59
In this practice we will perform the following tasks on a logical standby database:
Skip and un-skip specific object
Handle unsupported datatypes
Protect replicated tables on the logical standby database
Monitoring Data Guard Configuration14:01
This lecture will guide you through the tools that you would use to monitor a Data Guard configuration. You should learn how to do the following:
Use the alert log file and the V$DATAGUARD_STATUS to monitor the Data Guard
Obtain the archive log gaps, transport lag, apply lag and active apply rate using SQL*Plus and the Broker
Obtain information about the standby processes
Obtain statistics about the logical standby database
Practice 6: Monitoring Data Guard Configuration16:56
In this practice you will use the tools to monitor a Data Guard configuration.

Perform Role Transition Switchover11:39
By completing this lecture, you should be able to do the following:

Describe Data Guard Switchover
Switchover to a physical standby database using the SQL*Plus
Switchover to a logical standby database using the SQL*Plus
Switchover using the Broker
Perform Role Transition Failover8:32
By the end of this lecture, you should be able to do the following:
Describe Data Guard Failover
Failover to a physical standby database using the SQL*Plus
Failover to a logical standby database using the SQL*Plus
Failover using the Broker
Reinstate the primary database after failover using SQL*Plus
Reinstate the primary database after failover using the Broker
Practice 7: Perform Role Transitions16:51
In this practice we will go through the full procedure to perform switchover and failover in the Data Guard using the Broker.
Enabling Fast-Start Failover13:19
After you complete the lecture, you should be able to do the following:
Describe the advantages and drawbacks of Fast-Start Failover (FSFO)
Describe the architecture of the Fast-Start Failover
Configure the Fast-Start Failover
Define the Fast-Start Failover conditions
Enable the Fast-Start Failover
Start the FSFO Observer
Disable the Fast-Start Failove
Practice 8: Enabling the Fast-Start Failover16:44
In this practice we will implement and test the fast-start failover in a Data Guard configuration.

Implementing Active Data Guard9:45
In this lecture you will learn how to do the following:
Describe the Active Data Guard and its advantages
Enable Active Data Guard and use real-time query
Configure Apply Lag Tolerance
Configure zero lag between the primary and standby databases
Force redo apply synchronization in a Real-time Query Environment
Managing Snapshot Standby Databases7:15
This lecture describes how to create and then manage a snapshot standby database. The lecture will teach you how to do the following:

Describe the snapshot standby databases and their benefits
Convert a physical standby into a snapshot standby database
Use a snapshot standby Database
Convert a snapshot standby back to a physical standby database
Practice 9 Implement Active Data Guard and Snapshot Standby Database9:16
In this practice you will learn how to enable and test the Active Data Guard option. You will also create a snapshot standby database.

Managing Client Connectivity (Part 1)15:20
In this lecture you will learn how to describe the following concepts:

The meaning of client or application failover.
The categories of the service failure that you might face in a data center.
The challenges faced by a client failover
The options to implement the client failover
The procedure to implement client failover
Managing Client Connectivity (Part 2)12:36
By completing this lecture, you should be able to do the following:
Create Oracle Database Services
Configure the Outbound Connect Timeout
Configure the OCI Client for Connect-time Failover
Configure Transparent Application Failover (TAF)
Practice 10: Implement Client Failover11:01
In this practice we will enable the automatic client failover on a SQL*Plus client session.

RMAN Considerations in Data Guard Configuration14:21
In this lecture you should learn how to do the following:
Describe the general best practices of using RMAN in a Data Guard configuration
Manage the Data Guard databases in the Recovery Catalog
Make the Data Guard related configuration in RMAN
Recover a missing datafile in the primary database from a standby backup
Refresh a physical standby database with changes made to the primary database
Practice 11 Using RMAN in Data Guard Environment16:26
In this practice you will examine the considerations of using RMAN in a Data Guard environment

Performing Rolling Upgrade using DBMS_ROLLING19:56
In this lecture, you will learn how to do the following:
Describe the benefits of rolling upgrade
Describe the benefits of using DBMS_ROLLING
Understand the actions performed by the DBMS_ROLLING
Perform the rolling upgrade process using the DBMS_ROLLING
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 1 of 3 )17:44
In this tutorial, you will use rolling upgrade package (DBMS_ROLLING) to apply a patch set (PSU) on a Data Guard environment.
Practice Expected Time: 3 hours
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 2 of 3 )14:13
The is part 2 of the practice 12.
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 3 of 3 )11:33
This is part 3 (and the last part) of practice 12.

Requirements

We assume the audience have the basic knowledge of the Oracle Database Administration fundamentals. We do not expect you to be an expert DBA, basics are fair enough.

Description

Master Oracle Data Guard administration with a strong focus on real-world DBA tasks.

In this course, you will learn how to administer Oracle Data Guard environments in Oracle Database 12c and 19c, covering both concepts and hands-on implementation. The course is designed to help you confidently manage standby databases and high-availability configurations in production environments.

Each topic starts with a clear conceptual explanation, followed by practical demonstrations where you see every task performed step by step. You will not be left alone to guess the implementation—every practice is fully demonstrated using real examples.

The course includes:

Practical Data Guard administration tasks used by DBAs
Step-by-step video demonstrations
Downloadable scripts and configuration examples
Clear explanations of concepts before implementation

In addition, you will understand how Data Guard fits into enterprise disaster recovery strategies, how DBAs monitor and maintain standby databases, and how to respond to common operational scenarios. The course emphasizes best practices, common mistakes to avoid, and practical tips gained from real administration experience.

If your goal is to learn Oracle Data Guard administration with a strong hands-on focus, build confidence working with standby databases, and apply your skills in real production-like environments, then this course is just for you.

Who this course is for:

This course is designed for Oracle Database Administrators who would like to use Oracle Data Guard
Those DBAs who already have experience on Oracle Data Guard, this course is NOT for them.

Oracle Database Data Guard Administration (12c and 19c)

What you'll learn

Explore related topics

Course content

Introducing the Course5 lectures • 59min

Introduction to Oracle Data Guard3 lectures • 42min

Implementing Oracle Data Guard using SQL*Plus7 lectures • 1hr 46min

Oracle Data Guard Broker3 lectures • 52min

Managing Physical and Logical Standby Databases6 lectures • 1hr 33min

Perform Role Transitions5 lectures • 1hr 7min

Active Data Guard and Snapshot Standby Databases3 lectures • 26min

Managing Client Connectivity3 lectures • 39min

RMAN Considerations in Data Guard Configuration2 lectures • 31min

Performing Rolling Upgrade using DBMS_ROLLING4 lectures • 1hr 3min

Requirements

Description

Who this course is for: