Full Oracle Database High Availability Features

Oracle Database with Oracle 12C RAC, Oracle Data Guard, Oracle Backup and Oracle Data Recovery, and Oracle RMAN

4.34 (121 reviews)
Udemy
platform
English
language
Databases
category
instructor
1,118
students
15.5 hours
content
Mar 2024
last update
$89.99
regular price

What you will learn

This Oracle course introduces all the Oracle Database High Availability features fundamental to manage Oracle Database and designing a backup and recovery.

You will become an expert in subjects like Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard

Backup and recovery concepts in Oracle

Setting up the laboratory environment

Creating and managing recovery catalog

Using flashback Technologies in Oracle

Managing RMAN backups

Setting Up Oracle Enterprise Linux

What is Real Application Cluster?

Install Grid Infrastructure, Database Software and Create database

Administer Database Instances and Cluster Databases

Learn about Oracle RAC One Node

To convert RAC database to RAC One Node and administer it

Design and Deployment Techniques

Data Guard Administration for Oracle 12C R2

Creating Virtual Machines

Basic Usage of Data Guard Broker Utility

Switchover and Failover Operations on Physical Standby Database via both SQLPlus and Data Guard Broker

Creating Far Sync Instance

Configuring Primary and Standby Databases for far sync Instance

Switchover & Failover Operations on Logical Standby Database via both SQLPlus and Data Guard Broker

Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for ERP

Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data.

What is oracle SQL? SQL stands for Structured Query Language—the language developers use to interact with databases to create, read, update, and delete database

ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language.

Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system.

What careers use Oracle SQL? Having Oracle SQL skills can add value to many careers.

The most obvious is being a database administrator in enterprises that use the Oracle database management system.

Database developers also use Oracle SQL all day long to create new databases and table structures.

Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently.

Description

Hey there,

Welcome to my Full Oracle Database High Availability Features course.

Oracle Database with Oracle 12C RAC, Oracle Data Guard, Oracle Backup and Oracle Data Recovery, and Oracle RMAN

In this course, you will become an expert in subjects like Oracle 12C Release 2, Oracle 12C R2 Backup and Recovery ( using RMAN), Oracle Data Guard, and all High Availability features that you need to know about Oracle Databases in the real world. Oracle rac, oracle data guard, data recovery, oracle, rac, data guard, oracle rac 12c, oracle database, rman, oracle 19c, oracle 12c rac

If you are;

  • a junior Oracle DBA

  • DBA who is managing other RDBMS and want to immigrate to Oracle

You are at the right place!

In the course, you will have down-to-earth way explanations with hands-on examples. During the course, we focus more on the practical side of Oracle Databases. All my students will have a chance to learn not only the whats but also learn the whys and hows.

Oracle Database is an enterprise database that can handle online transaction processing needs, as well as data warehousing and workloads for enterprise resource planning (ERP). Oracle DB was designed to be a flexible way to handle large applications and massive amounts of structured data.

This course starts with the very basics. First, you will learn how to install the tools. Then the show will start and we will start with introducing the Oracle Database architecture, this course will take you all away from performing basic database operations up to implementing advanced operation options.

At the end of the course;

  • Backup and recovery concepts in Oracle

  • Setting up the laboratory environment

  • Creating and managing the recovery catalog

  • Using flashback Technologies in Oracle

  • Backing up the database

  • Reporting on RMAN operations.

  • Managing RMAN backups

  • Using Data Recovery Advisor of Oracle

  • Restoring and recovering database and database objects.

  • The point-in-time recovery concept in Oracle will be crystal clear for you.

  • What is RAC ( Real Application Cluster )

  • Creating Virtual Machines

  • Administer Database Instances and Cluster Databases

  • Oracle RAC One Node

  • How to Convert RAC Database to RAC One Node

  • Workload Management

  • Monitoring Performance

  • Design and Deployment Techniques

  • Cloning Oracle RAC

  • Managing backup, and restoring cluster database

  • Add and Delete Node From Cluster

  • What is Dataguard

  • Cloning Virtual Machines

  • Installing Database Software and Creating Database

  • Creating Physical Standby Database

  • Managing Physical Standby Database

  • Basic usage of Data Guard Broker Utility

  • Creating and managing snapshot databases

  • Switchover and failover operations on physical standby database via both SQLPlus and Data Guard Broker

  • Creating Far Sync Instance

  • Configuring primary and standby databases for far sync instance

  • Creating Logical Standby database

  • Managing Logical Standby database

What is oracle SQL?

SQL stands for Structured Query Language—the language developers use to interact with databases to create, read, update, and delete database records and manage other aspects of those databases. ANSI created the standard for SQL. Many database vendors, like Oracle, expand on this standard to create their version of the language. Oracle SQL is compliant with ANSI SQL standards, with features designed specifically for the Oracle database management system. This RDBMS was released as the first commercially available relational database management system in 1977 and holds the top market share worldwide for relational database management systems. Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language.

What careers use Oracle SQL?

Having Oracle SQL skills can add value to many careers. The most obvious is being a database administrator in enterprises that use the Oracle database management system. But SQL dialects are pretty similar, and knowledge of Oracle SQL can apply to many types of relational databases and doesn't limit you to Oracle. Database developers also use Oracle SQL all day long to create new databases and table structures. Most applications require a database to function, so software engineers and web developers also use Oracle SQL frequently. Data scientists must access data to create machine learning models and find trends, and a lot of this data will get stored in databases that require a knowledge of SQL to retrieve and transform. Business analysts also use Oracle SQL to generate reports that help businesses get to their next stage.

What skills should I have before learning Oracle SQL?

There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English. Most people can understand what a SQL query is trying to do before they even know the language. All you need is an interest in the language and a commitment to learning. That said, some things could help with your Oracle SQL education if you are already familiar with them. If you are familiar with Excel spreadsheets and understand how columns and rows work, you can apply that knowledge to Oracle database tables. It also helps to know at least the concepts of how a relational database management system works. Also, if you already know a programming language, that will help learn Oracle's extended features like PL/SQL.

Fresh Content

Oracle is a unique technology that provides high availability and scalability for all application types. It prevents the server from being a single point of failure. And this course introduces all the Oracle Database High Availability features fundamental to manage Oracle Database and designing a backup and recovery.

Why would you want to take this course? 

Our answer is simple: The quality of teaching.

When you enroll, you will feel our seasoned developers' expertise. 

Step-by-Step Way, Simple and Easy With Exercises

By the end of the course, you’ll have a firm understanding of the Oracle Database in all aspects and valuable insights on how things work under the hood and you'll also be very confident, and hungry to learn more.

Video and Audio Production Quality

All our videos are created/produced as high-quality video and audio to provide you the best learning experience.

You will be,

  • Seeing clearly

  • Hearing clearly

  • Moving through the course without distractions

You'll also get:

Lifetime Access to The Course

Fast & Friendly Support in the Q&A section

Udemy Certificate of Completion Ready for Download


Dive in now to our Full Oracle Database High Availability Features course

We offer full support, answering any questions.

See you in the course!

Content

Oracle 12C Release 2 Backup and Recovery Using RMAN

Let's See What We Will Cover In This RMAN Course

Downloads

Download Virtualbox
Download Linux
Download Oracle Software

Installation

Install Virtual Box
Create Virtual Machine
Install Guest Operating System
Prerequisites
Oracle Software Installation
Clone Virtual Machine
Create Primary Database
Create Catalog Database
Create Sample Data

Intro to Backup and Recovery

Introduction to Backup and Recovery

Starting and Interacting with the RMAN Client

Starting and Interacting with the RMAN Client

Create Recovery Catalog

Create Recovery Catalog

Flashback Database and Restore Points

Flashback Database and Restore Points Presentation
Flashback Database and Restore Points

Backup Database

Backup Database Concepts
Backup Database
Backup Database - Advanced Topics

Reporting on RMAN Operations

Reporting on RMAN Operations

Maintaining RMAN Backups and Repository Records

Maintaining RMAN Backups and Repository Records Presentation
Maintaining RMAN Backups and Repository Records

Managing Recovery Catalog

Managing Recovery Catalog Presentation
Managing Recovery Catalog

Data Repair Concepts

Data Repair Concepts
Data Recovery Advisor

Validating Database Files and Backups

Validating Database Files and Backups

Performing Complete Database Recovery

Performing Datafile Recovery
Performing Tablespace Recovery
Performing PDB Recovery
Performing Database Recovery

Performing Point-in-Time Recovery

Database Point In Time Recovery
Tablespace Point In Time Recovery

Performing Block Media Recovery

Performing Block Media Recovery

What We Have Learned In This RMAN Course?

Let's Wrap Up What We Covered In This RMAN Course

Introduction to Oracle RAC (Real Application Cluster)

Intro to RAC

Setting Up The Environment

Create Virtual Machine
Install Guest Operating System
Install Grid Prerequisites Part1
Install Grid Prerequisites Part2
Clone Virtual Machine
Create Shared Disk
Install Grid Infrastructure
Install Database Software
Create Database

Administration of Oracle RAC

Start Crs
Start Database
Stop Database & CRS
Disable CRS
Add & Delete Service
Kill a Session & Set Spfile Parameter

RAC One Node

Administration of RAC One Node

Workload Management

Workload Management

Monitoring Performance

Monitoring Performance

Design & Deployment Techniques

Design & Deployment Techniques
Clone Oracle RAC

Managing Backup & Recovery

Introduction to Recovery & RMAN
Backup Database
Restore Database

Add & Delete Node

Add Node to Cluster
Delete Node from Cluster

Tips & Tricks

First Controls of Day
Monthly Controls
Useful Scripts Usage
Opatch-AWR-ASH
ORA Errors Solutions

Let's Start to Learn Oracle Data Guard

What is Oracle Data Guard?
Understanding the Oracle Data Guard Administration
Redo Transport Services
Apply Services

Downloads

Download Virtualbox
Download Oracle Linux
Download Oracle Software

Installations

Install Virtualbox
Create Virtual Machine
Install Guest Operating System
Install Prerequisites
Install Oracle Software
Clone Virtual Machine
Create Database

Creating Physical Standby

Creating Physical Standby Presentation
Creating Physical Standby Practice

Managing Physical Standby

Managing Physical Standby

Managing Snapshot Database

Managing Snapshot Database

Role Transitions on Physical Standby

Role Transitions Presentation
Switchover on Physical Standby
Failover on Physical Standby

Far Sync Instance

What is Far Sync Instance?
Far Sync Instance Practice

Creating Logical Standby

Creating Logical Standby
Creating Logical Standby Practice

Managing Logical Standby

Managing Logical Standby

Role Transitions on Logical Standby

Switchover on Logical Standby
Failover on Logical Standby
BONUS

Screenshots

Full Oracle Database High Availability Features - Screenshot_01Full Oracle Database High Availability Features - Screenshot_02Full Oracle Database High Availability Features - Screenshot_03Full Oracle Database High Availability Features - Screenshot_04

Reviews

Volcano
July 8, 2023
I learned all the important features related to Oracle in a single tutorial. Thanks... Interactive and helpful.
Martin
May 7, 2023
course exceeded my expectations with its in-depth content and clear explanations. Highly recommended for anyone looking to master Oracle databases!
Tom
March 2, 2023
Oracle 12C RAC, Oracle Data Guard, Oracle Backup, Oracle Data Recovery and Oracle RMAN. All together. I learned all the important features related to Oracle in a single tutorial. Thanks...
Health
February 13, 2023
Faltam os scripts de cada aula. Outro ponto é que em todas aulas os comandos são copiados e colados, parecendo que o autor segue um "livro" e não são de seu conhecimento.
Hojung
February 10, 2023
Really poor explanation on download and installation. Web UI totally changed so cannot follow the video, and lecturer skips a lot of things.
Vitor
February 1, 2023
Course isnt updated and the downloads links aren't available with the versions of OS and database used in the course. Teacher should make available the necessary downloads in another source.

Charts

Price

Full Oracle Database High Availability Features - Price chart

Rating

Full Oracle Database High Availability Features - Ratings chart

Enrollment distribution

Full Oracle Database High Availability Features - Distribution chart
3573651
udemy ID
10/16/2020
course created date
11/7/2020
course indexed date
Bot
course submited by