Oracle 12C RAC Administration and Backup and Recovery RMAN

Oracle RAC, Oracle Database Administration, use RMAN, Oracle backup and recovery and become Oracle Database master

4.30 (81 reviews)
Udemy
platform
English
language
Other
category
instructor
Oracle 12C RAC Administration and Backup and Recovery RMAN
550
students
9.5 hours
content
Apr 2024
last update
$79.99
regular price

What you will learn

Meet with Oracle RAC

Install Oracle Virtualbox

Setting Up Oracle Enterprise Linux

Install Oracle Software

Create Virtual Machines

Install Oracle RAC Database to Virtual Machines

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

Workload Management

Monitoring performance

Design and Deployment Techniques

Cloning Oracle RAC

Manage backup, and restore cluster database

Add and Delete Node from Cluster

Backup and recovery concepts in Oracle

Reporting on RMAN operations

Managing RMAN backups

Using Data Recovery Advisor of Oracle

Restoring and recovering database and database objects

Point-in-time recovery concept in Oracle

Perform all common recovery scenarios

Perform backups using RMAN

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.

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

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.

Oracle SQL extends the SQL standard with a procedural language PL/SQL and adds the ability to use the Java programming language.

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.

There are no prerequisites to learning Oracle SQL. Oracle SQL has a simpler syntax than many standard programming languages and reads almost like English.

Why take this course?

Hello there,

Welcome to the "Oracle 12C RAC Administration and Backup and Recovery RMAN" online course.

Oracle RAC, Oracle Database Administration, use RMAN, Oracle backup and recovery and become Oracle Database master

Oracle Database Administration, Oracle rac,  oracle rman, rman, rac, oracle database, oracle backup, oracle data recovery

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.

Whether you’re interested in preparing for an Oracle Administrator certification exam or simply using Oracle DB for your enterprise-grade application, Udemy has a range of top-rated courses to help you get the job done.

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

  • Do you want to become an Oracle DBA at an international company?

  • Do you want to learn how to perform backup and recovery activities using RMAN?

If you think so, you are at the right place.

This time I’ve designed for you the "Oracle 12C RAC Administration and Backup and Recovery RMAN” straight-forward course for the Oracle Database. In the course, you will have down-to-earth way explanations with hands-on examples. With my course, you will learn Oracle RAC and Backup and Recovery step-by-step. I made all the lectures simple and easy with real-life examples.

This course is expertly designed to teach everyone from complete beginners, right through to professionals ( as a refresher). 

In this course you will learn;

  • What is RAC ( Real Application Cluster )

  • Installing Oracle Virtualbox

  • Setting Up Oracle Enterprise Linux

  • Installing Oracle Software

  • Oracle RAC

  • Creating Virtual Machines

  • Installing Oracle RAC Database to VMs

  • Installing Grid Infrastructure, Database Software and Creating Database

  • 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

  • Oracle RAC

  • Oracle database administration

  • RMAN

  • Oracle 12c RAC

  • Oracle Backup

  • Oracle Data Recovery

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.

Why would you want to take this course?

Our answer is simple: The quality of teaching.

When you enroll, you will feel the OAK Academy`s seasoned developers' expertise.

This course will take you from a beginner to a more experienced level.

If you are a DBA or familiar to the Oracle Database / Oracle SQL or if you want to become an Oracle DBA at an international company or if you are a DBA that manages other RDBMS and wants to immigrate the Oracle or you are already in the field and active RAC user but you just need a refresher or learn how to perform backup and recovery activities using RMAN, you are also in the right place. You will learn step by step with hands-on examples.

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. But DBAs also should aware of the recent development and it’s no secret how technology is advancing at a rapid rate. New tools are released every day, Oracle updates its system, and it’s crucial to stay on top of the latest knowledge. With this course, you will always have a chance to follow the latest trends.

Video and Audio Production Quality

All our content is created/produced as high-quality video/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!

We offer full support, answering any questions.

See you in the course!

Content

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

Introduction to Oracle RAC

Intro to RAC

Oracle 12C R2 RAC Installation

Create Virtual Machine
Install Guest Operating System
Install Grid Prerequisites Part 1
Install Grid Prerequisites Part 2
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

Screenshots

Oracle 12C RAC Administration and Backup and Recovery RMAN - Screenshot_01Oracle 12C RAC Administration and Backup and Recovery RMAN - Screenshot_02Oracle 12C RAC Administration and Backup and Recovery RMAN - Screenshot_03Oracle 12C RAC Administration and Backup and Recovery RMAN - Screenshot_04

Reviews

Catlene
September 29, 2023
It is a very good training on Oracle RAC, Oracle Database Administration, RMAN usage, Oracle backup and recovery. The narration is very good.
Armando
May 5, 2023
Poor explanation on the most of the topics. Would be better if he can explains more detail on the commands he run during the course.
Ziyaaddin
June 29, 2022
This course has been great for me. I am at the beginning now and it is progressing very well. Thank for your efforts. Nice job.
Denis
February 9, 2022
Excellent course, very good to learn from Oracle DB the instructor explains well I would recommend it to anyone
Colin
February 9, 2022
A well organized Oracle database course from Oak Academy which is not only useful for beginner level students but for professionals to become database specialists. This course is structured to progress from basic level to more advanced level which allows students to learn every concept and method with more clear surroundings!
Sasika
February 9, 2022
This is great course for students and professional who likes specialize their knowledge about "Oracle Database Administration". This also one of the best "Oracle Database Administration" courses on Udemy.
Tako
October 14, 2021
Great that it includes a way to run your own lab. The teacher also has a good humored voice, easy to listen to.

Charts

Price

Oracle 12C RAC Administration and Backup and Recovery RMAN - Price chart

Rating

Oracle 12C RAC Administration and Backup and Recovery RMAN - Ratings chart

Enrollment distribution

Oracle 12C RAC Administration and Backup and Recovery RMAN - Distribution chart
3390116
udemy ID
8/3/2020
course created date
8/24/2020
course indexed date
Bot
course submited by