Oracle 12c Data Guard Administration
4.6 (126 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
687 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Oracle 12c Data Guard Administration to your Wishlist.

Add to Wishlist

Oracle 12c Data Guard Administration

A comprehensive course with concentration on the practical side on Oracle Data Guard administration.
4.6 (126 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
687 students enrolled
Created by Ahmed Baraka
Last updated 7/2017
English
Current price: $20 Original price: $125 Discount: 84% off
30-Day Money-Back Guarantee
Includes:
  • 10 hours on-demand video
  • 18 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
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

With this comprehensive course you will learn all about administering Oracle Data Guard. You will gain hands-on experience on performing all the fundamental administration tasks a DBA may need to manage a Data Guard environment.

The course is built-up of lectures that describe the concepts of a subject and practice lectures that allow you to practically implement what you have learnt in the concepts lecture. They are all demonstrated by videos and supported with downloadable files, such as scripts and code examples. The practice lectures do not leave you implement the exercises alone, they are all accompanied with demonstration videos.

If your target is learning all about the fundamental Oracle Data Guard administration with concentration on the practical side, then you are in the right place.

Who is the target audience?
  • 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.
Curriculum For This Course
41 Lectures
09:51:37
+
Introducing the Course
4 Lectures 59:22

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


Preview 07:14

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

Preview 18:03

This practice is to continue the practice in the previous lecture.

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
+
Introduction to Oracle Data Guard
3 Lectures 41:36

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
Preview 13:46

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 1 )
15:20

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 Basic Concepts ( Part 2 )
12:30

This small quiz will test your understanding of the Data Guard configuration. This is important before you go on the practical procedure to create a Data Guard configuration.

Data Guard Concepts
10 questions
+
Implementing Oracle Data Guard using SQL*Plus
7 Lectures 01:46:18

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 1)
13:24

This lecture is part 2 of the previous lecture.

Creating a Physical Standby Database (Part 2)
11:43

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.

Practice1: Creating a Physical Standby Database (Part 1)
18:19

This is a continuation of the practice # 1, Part 2 of 3.

Practice 1: Creating a Physical Standby Database (part 2)
09:30

This is a continuation of the practice # 1, Part 3 of 3.

Practice 1: Creating a Physical Standby Database (part 3)
19:51

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


Creating a Logical Standby Database
15:42

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.

Practice 2: Creating a Logical Standby Database
17:49
+
Oracle Data Guard Broker
3 Lectures 51:34

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 1)
17:20

This lecture is to continue the previous lecture.

Using the Data Guard Broker (Part 2)
15:30

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. 

Practice 3 Creating a Data Guard Broker Configuration
18:44
+
Managing Physical and Logical Standby Databases
6 Lectures 01:33:01

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
Managing Physical Standby Database
16:10

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.


Practice 4 Changing the Data Guard Protection Mode
14:48

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


Managing Logical Standby Database
17:07

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
Practice 5 Managing Logical Standby Database
13:59

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
Monitoring Data Guard Configuration
14:01

In this practice you will use the tools to monitor a Data Guard configuration.

Practice 6: Monitoring Data Guard Configuration
16:56
+
Perform Role Transitions
5 Lectures 01:07:05

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 Switchover
11:39

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
Perform Role Transition Failover
08:32

In this practice we will go through the full procedure to perform switchover and failover in the Data Guard using the Broker.

Practice 7: Perform Role Transitions
16:51

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
Enabling Fast-Start Failover
13:19

In this practice we will implement and test the fast-start failover in a Data Guard configuration.

Preview 16:44
+
Active Data Guard and Snapshot Standby Databases
3 Lectures 26:16
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
Implementing Active Data Guard
09:45

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


Managing Snapshot Standby Databases
07:15

In this practice you will learn how to enable and test the Active Data Guard option. You will also create a snapshot standby database.

Practice 9 Implement Active Data Guard and Snapshot Standby Database
09:16
+
Managing Client Connectivity
3 Lectures 38:57

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 1)
15:20

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)
Managing Client Connectivity (Part 2)
12:36

In this practice we will enable the automatic client failover on a SQL*Plus client session.

Practice 10: Implement Client Failover
11:01
+
RMAN Considerations in Data Guard Configuration
2 Lectures 30:47

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
RMAN Considerations in Data Guard Configuration
14:21

In this practice you will examine the considerations of using RMAN in a Data Guard environment

Practice 11 Using RMAN in Data Guard Environment
16:26
+
Performing Rolling Upgrade using DBMS_ROLLING
4 Lectures 01:03:26

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
Performing Rolling Upgrade using DBMS_ROLLING
19:56

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 1 of 3 )
17:44

The is part 2 of the practice 12.

Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 2 of 3 )
14:13

This is part 3 (and the last part) of practice 12.

Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 3 of 3 )
11:33
1 More Section
About the Instructor
Ahmed Baraka
4.5 Average rating
195 Reviews
836 Students
2 Courses
Snr. Database Administrator

Ahmed Baraka has 19 years of extensive experience in the computer industry, with focus on Oracle database administration technologies used in complex and high available environments. Baraka's expertise is designing and maintaining database solutions for complex business needs using a wide selection of technologies, like Oracle RAC, ASM, Data Guard, GoldenGate, WebLogic, Database Appliance, and Enterprise Manager. He has worked with international firms in Australia and Abu Dhabi. His hobbies are soccer (football) and computer games.