Rolling upgrades are discussed in the following white paper witch can be found on OTN: 'Database Rolling Upgrades Made Easy by Using a Data Guard Physical Standby Database'. Oracle Maximum Availability Architecture (MAA) is the Oracle best practices blueprint for implementing Oracle high availability technologies. Oracle Data Guard Online Training Data Guard Administration training helps you develop the skills to use Oracle Data Guard to help protect your Oracle database against planned and unplanned downtime. Explore how Data Guard standby databases can be used to support production functions such as reporting, querying and testing, while in a standby role. Introduction Oracle Active Data Guard provides several new PL/SQL packages and DDL commands to automate the previous manual steps of performing a database rolling upgrade to a new Oracle patch set, database release, or to perform other planned maintenance.
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.
Lg dvd player problems. Total practice expected duration: 60 minutes
This practice is to continue the practice in the previous lecture.
Practice: Create an Oracle 12c Database with ASM (part 2)
This practice is to continue the practice in the previous lecture.
Practice: Create an Oracle 12c Database with ASM (part 3)
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.
00:05
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
Preview13: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
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
OracleData Guard Broker Benefits
Flashback Database and Data Guard
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.
10 questions
7 lectures01: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
13:24
Creating a Physical Standby Database (Part 2)
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)
This is a continuation of the practice # 1, Part 2 of 3.
Practice 1: Creating a Physical Standby Database (part 2)
This is a continuation of the practice # 1, Part 3 of 3.
Practice 1: Creating a Physical Standby Database (part 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:
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
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. Yip drivers of globalization.
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.
17:49
3 lectures51: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
17:20
Using the Data Guard Broker (Part 2)
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
6 lectures01: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
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
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
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
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
14:01
In this practice you will use the tools to monitor a Data Guard configuration.
16:56
5 lectures01: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
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
08:32
In this practice we will go through the full procedure to perform switchover and failover in the Data Guard using the Broker.
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
13:19
In this practice we will implement and test the fast-start failover in a Data Guard configuration.
Preview16:44
+–Active Data Guard and Snapshot Standby Databases
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
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
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
3 lectures38: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
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)
12:36
In this practice we will enable the automatic client failover on a SQL*Plus client session.
Oracle Data Guard Cost
11:01
2 lectures30: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
14:21
In this practice you will examine the considerations of using RMAN in a Data Guard environment
16:26
4 lectures01: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
19:56
In this tutorial, you will use rolling upgrade package (DBMS_ROLLING) to apply a patch set (PSU) on a Data Guard environment.
Oracle Data Guard Licensing
Practice Expected Time: 3 hours
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 1 of 3 )
Oracle Data Guard Tutorial
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 2 of 3 )
This is part 3 (and the last part) of practice 12.
Rolling Patch Oracle Data Guard Download
Practice 12: Performing Rolling Upgrade using DBMS_ROLLING ( Part 3 of 3 )