Learn all about administering Oracle Data Guard (12c and 19c) environments. You will gain hands-on experience on performing all the fundamental administration tasks a DBA may need to manage a Data Guard environment.
Learn all about administering Oracle Data Guard (12c and 19c) environments. 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.
This lecture introduces the course to you. It covers the following topics:
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
This practice is to continue the practice in the previous lecture.
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.
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:
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:
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:
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.
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:
This lecture is part 2 of the previous lecture.
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.
This is a continuation of the practice # 1, Part 2 of 3.
This is a continuation of the practice # 1, Part 3 of 3.
This lecture guides you on how to create a logical standby database. After completing this lecture, you should be able to do the following:
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.
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:
This lecture is to continue the previous lecture.
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.
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:
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.
For a logical standby database, in this lecture you will learn how to do the following:
In this practice you will use the tools to monitor a Data Guard configuration.
By completing this lecture, you should be able to do the following:
By the end of this lecture, you should be able to do the following:
In this practice we will go through the full procedure to perform switchover and failover in the Data Guard using the Broker.
In this practice we will implement and test the fast-start failover in a Data Guard configuration.
This lecture describes how to create and then manage a snapshot standby database. The lecture will teach you how to do the following:
In this practice you will learn how to enable and test the Active Data Guard option. You will also create a snapshot standby database.
In this lecture you will learn how to describe the following concepts:
By completing this lecture, you should be able to do the following:
In this practice we will enable the automatic client failover on a SQL*Plus client session.
In this lecture you should learn how to do the following:
In this practice you will examine the considerations of using RMAN in a Data Guard environment
In this lecture, you will learn how to do the following:
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
The is part 2 of the practice 12.
This is part 3 (and the last part) of practice 12.
In this lecture, you will learn how to describe the concepts of the following:
This tutorial demonstrates creating an Oracle 12c R2 Physical standby RAC database from a Primary RAC database.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.