Oracle Database 12c Backup and Recovery using RMAN
4.6 (184 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
952 students enrolled

Oracle Database 12c Backup and Recovery using RMAN

Master using RMAN in performing backup and recovery activities on Oracle Databases. No course covers the same topics!
4.6 (184 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
954 students enrolled
Created by Ahmed Baraka
Last updated 7/2020
English
English [Auto]
Current price: $106.99 Original price: $164.99 Discount: 35% off
13 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 20 hours on-demand video
  • 65 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Perform complete/incomplete, full/incremental and whole/partial backups using RMAN
  • Perform all common recovery scenarios
  • Use RMAN with Oracle Database Backup Cloud Service
  • Report and Monitor RMAN Backups and Jobs
  • Use RMAN backup advanced options
  • Perform all supported cross-platform transportation techniques
  • Perform all supported database duplication techniques
  • Manage RMAN Recovery Catalog
  • Produce encrypted backups
  • Use RMAN in a multitenant environment
  • Use RMAN in a RAC environment
  • Handle corrupted blocks
  • Use Data Recovery Advisor
Requirements
  • Familiarity with Oracle database administration
  • Familiarity with Linux operating system basics
  • PC with Windows 7,8, or 10 64-bit, Memory 16 GB, Fee HDD 280 GB, connection to the internet
Description

Learn how to master using RMAN to perform backup and recovery activities on Oracle databases. The course does not only cover the on-site single-instance databases, it also covers RAC, multitenant, and Oracle Database Cloud service as well.

Not only the course will demonstrate the concepts for you, you will also gain practical experience on implementing the them. 

  • Describe Oracle technologies involved in backup and recovery activities

  • Use RMAN to perform all Oracle database backup strategies and types: whole/partial, full/incremental, complete/incomplete, and online/offline

  • Implement advanced backup options: compression, encryption, multisection, duplexing backups, and archival backups

  • Perform all common recovery scenarios:

    - Loss of database critical files

    - Loss of application data

    - Loss of database non-critical files

  • Manage RMAN Recovery Catalog

  • Cross-platform data transportation

  • Duplicate a database using RMAN

  • Use Oracle Database Backup Cloud Service

  • Use RMAN in Oracle RAC and multitenant databases

  • Understand the best practices on developing backup and recovery plans

     

Content and Overview
Information presented in this course provides Oracle Database Administrators the knowledge and experience to perform  backup and recovery activities on Oracle databases.

Through this extensive course, you’ll learn all of the using RMAN to manage backup and recovery activities on Oracle databases. After every concepts lecture, you will implement a hands-on practical exercise. To guide you on implementing the practices, the practice lectures are supported by video-based demonstrations and the downloadable guide documents.

Starting with introducing the Oracle RMAN architecture, this course will take you all the away from performing basic database backup up to implementing advanced backup options on the produced backups.

You will understand and practically produce all the possible RMAN backup strategies and types, including  whole/partial, full/incremental, complete/incomplete, and online/offline backup. You will also implement advanced backup options, such as  compression, encryption, multisection, duplexing backups, and archival backups.

You will also simulate all known common recovery scenarios from losing database critical files, losing application data, and losing database non-critical files. You will cover the further RMAN capabilities, like RMAN Recovery Catalog, cross-platform data transportation, and cloning databases.

Beside all those technical practical skills, you will also understand the best practices on developing backup and recovery plans

This course covers the latest available backup and recovery technology provided by Oracle, that is Oracle Database Backup Cloud Service.

This is an opportunity for the students to gain practical experience on protecting the databases from future incidents.

Upon completing this course, you will be able to develop a practical backup and recovery for Oracle databases in production systems.

Join the author in this learning journey to experience this amazing technology!

Who this course is for:
  • Oracle Database Administrators who to create and implement a backup and recovery plan of Oracle databases using RMAN
Course content
Expand all 73 lectures 20:05:00
+ Introduction
1 lecture 06:04

This lecture will introduce the course to you. You will know what you will achieve in the course in addition to the course layout.

Preview 06:04
+ Preparing the Course Practice Environment
4 lectures 01:23:43

This practice guides you to prepare the environment that you will use in the course practices. The practices in the course were designed using virtual machines.   You will build two VirtualBox appliances. One is Linux-based and the other one is Windows-based.

Preview 16:01

This is part 2 of Practice 2.

Practice 1 - Preparing the Course Practice Environment (Part 2 of 4)
21:24

This is part 2 of Practice 1.

Practice 1 - Preparing the Course Practice Environment (Part 3 of 4)
18:10

This is the last part of practice 1.

Practice 1 - Preparing the Course Practice Environment (Part 4 of 4)
28:08
+ Introducing Backup and Recovery in RMAN
4 lectures 01:19:05

In this lecture, you should gain knowledge on the following:

  • The purpose of backup and recovery strategy

  • List of possible failure categories

  • Recovery point objective (RPO)

  • Recovery time objective (RTO)

  • Oracle data protection solutions

  • About Oracle Recovery Manager (RMAN)

  • Oracle database backup and recovery techniques


Introduction to Oracle Backup and Recovery Solutions
19:55

In this lecture you will learn how to describe the following topics:

  • Basics of Oracle database server architecture

  • Using Fast Recovery Area (FRA)

  • Multiplexing control files

  • Multiplexing redo log files

  • Enabling ARCHIVELOG mode

  • Database checkpoints

  • Database parameters that affect RMAN operations

Configuring Oracle Database for Backup and Recovery
23:31

In this lecture, you will learn how to perform the following:

  • Describe the advantages of using RMAN

  • Describe the terms used with explaining RMAN operations

  • Describe RMAN components

  • Start RMAN with connecting to target database

  • Use SYSBACKUP privilege

  • Use RMAN command-line arguments

  • Manage RMAN persistent settings


Preview 25:04

In this practice you will get familiar with starting and configuring RMAN.

Practice 2 - Introducing RMAN
10:35
+ Performing Backups in RMAN
9 lectures 02:47:41

In this lecture, you should learn how to perform the following:

  • Describe available backup strategies, backup types, and backup modes

  • Describe the possible RMAN backup types

  • Using RMAN to make a whole database backup 

  • Using RMAN to make partial backup


Performing RMAN Backups - Part I
22:33

In this practice, you will perform the following tasks:

  • Take a cold/consistent backup of the entire database (in NOARCHIVELOG mode)

  • Take a hot/inconsistent backup of the entire database

  • Take backups of specific tablespaces

  • Specify the backup destination of a BACKUP command

Practice 3 - Performing RMAN Backups - Part I
18:45

In this lecture, you will learn how to perform the following:

  • Use multiple options to backup control files

  • Backup SPFILE

  • Backup archived redo logs

  • Take backups as image copies

  • Define device type in BACKUP commands

  • Use TAGs in RMAN backups

Performing RMAN Full Backups - Part II
24:02

In this practice, you will perform the following tasks:

  • Use multiple options to take backup of the control file.

  • Produce backups as image copies

  • Use tags in the produced RMAN backups


Practice 4 - Performing RMAN Backups - Part II
11:40

In this lecture, you will learn how to perform the following:

  • Describe the difference between differential and cumulative incremental backups

  • Take incremental backup

  • Describe the incrementally updated backups

  • Make incrementally updated backups

  • Configure Block Change Tracking (BCT)


Performing Incremental Backups
22:31

In this practice, you will perform the following tasks:

  • Take incremental database backups, differential and cumulative

  • Enable Block Change Tracking (BCT) in ORADB database

  • Create database incrementally updated backup

  • Automate RMAN backup jobs in Linux and Windows platforms


Practice 5 - Performing Incremental Backups (Part 1 of 2)
15:02

This is to continue the previous lecture.

Practice 5 - Performing Incremental Backups (Part 2 of 2)
13:32

In this lecture, you will learn how to perform the following:

  • Configure RMAN backup retention policy

  • Specifying the FORMAT of RMAN backups in all levels

  • Configure parallelism in RMAN

  • Configure archived redo log deletion policy


Configuring RMAN Persistent Settings
29:35

In this practice, you will perform the following tasks:

  • Set RMAN retention policy

  • Modify the default FORMAT of RMAN backups

  • Enable the parallelism in the automatic and manual channels

Practice 6 - Configuring RMAN Persistent Settings
10:01
+ Retrieve Information about RMAN Backups and Jobs
5 lectures 57:18

In this lecture, you will learn how to perform the following:

  • Use LIST and REPORT commands to retrieve information about RMAN backup files

  • Use Dynamic Views to retrieve information about RMAN backup files

  • Cross-check RMAN backup files

  • Monitor current and past RMAN jobs

Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 2 )
15:32

This is to continue the previous lecture.

Reporting and Monitoring RMAN Backups and Jobs ( Part 2 of 2 )
11:47

In this practice, you will perform the following tasks:

  • Use LIST command to retrieve list of the following:

        - backupset file and image copies registered in RMAN repository

        - archived redo log files and their backups

        - expired backup files

  • Use CROSSCHECK to scan the backup files and check on their expiry status

  • Use REPORT command to perform the following:

       - display the physical structure of the database

       - report datafiles that do not satisfy retention policy

       - report datafiles that are affected by unrecoverable operations

       - report obsolete backup files

  • Monitor RMAN jobs using V$ views

Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 3 )
11:13

This is to continue the previous lecture.

Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 2 of 3 )
09:14

This is to continue the previous lecture.

Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 3 of 3 )
09:32
+ Improving Backups
4 lectures 55:18

In this lecture, you will learn how to perform the following:

  • Describe how blocks could automatically be skipped during backups

  • Describe the compression options and use them

  • Produce compressed backup sets

  • Configure multisection feature in RMAN

  • Configure duplexed backup sets in RMAN

  • Take backup of backupsets

  • Backup the entire FRA

  • Produce archival backups

Improving Backups ( Part 1 of 3 )
13:02

This is to continue the previous lecture.

Improving Backups ( Part 2 of 3 )
14:57

This is to continue the previous lecture.

Improving Backups ( Part 3 of 3 )
11:56

In this practice, you will perform the following tasks:

  • Enable compression when making backupsets

  • Take backups with multisection option

  • Create an archival backup


Practice 8 - Improving Backups
15:23
+ Managing RMAN Recovery Catalog
3 lectures 41:03

In this lecture, you will learn how to perform the following:

  • Compare between using control file and Recovery Catalog as RMAN repository

  • Create and manage recovery catalogs

  • Manually resynchronize recovery catalogs

  • Catalog files into RMAN repository

  • Create and manage stored scripts

Using RMAN Recovery Catalog ( Part 1 of 2 )
12:27

This is to continue the previous lecture.

Using RMAN Recovery Catalog ( Part 2 of 2 )
16:23

In this practice, you will perform the following tasks:

  • Create recovery catalog in ORAWIN database and register the database ORADB in it

  • Catalog recovery files in the recovery catalog

  • Create and manage RMAN stored scripts


Practice 9 - Using RMAN Recovery Catalog
12:13
+ Securing RMAN Backups
2 lectures 31:46

In this lecture, you will learn how to use the following encryption modes in RMAN backups:

  • Transparent Encryption

  • Password-based keystore

  • Auto-login keystore

  • Password Encryption

  • Dual mode Encryption


Using RMAN-Encrypted Backups
20:26

In this practice, you will perform the following tasks:

  • Configure Transparent Data Encryption

  • Produce backup sets encrypted with the following methods:

    -  Transparent mode encryption

    -  Password mode encryption

    -  Dual mode encryption

Practice 10 - Using RMAN-Encrypted Backups
11:20
+ Common Backup Practices
2 lectures 33:56

In this lecture, you will learn how to describe the following:

  • How RPO and RTO should be defined in backup plans?

  • General best practices in database backups

  • Best practices in backing up warehouse databases

  • The traditional layout of backing up databases

  • Modern layout of backing up the databases using the cloud

  • Third party solutions for protecting the data

  • Common scenarios in designing database backup plans


Common Backup Practices ( Part 1 of 2 )
18:18

This is to continue the previous lecture.

Common Backup Practices ( Part 2 of 2 )
15:38
+ Performing Recovery Scenarios in RMAN
14 lectures 04:17:37

In this lecture, you will learn how to perform the following:

  • Describe the difference between non-critical and critical data loss

  • Describe the actions performed by the commands RESTORE and RECOVER

  • Describe the steps to prepare a database for a recovery procedure


Introducing RESTORE and RECOVER Commands
17:05

In this lecture, you will learn how to do the following:

  • Perform the common pre-recovery actions

  • Recover the whole database when running in NOARCHIVELOG mode

  • Recover the whole database when running in ARCHIVELOG mode

  • Perform full recovery on a user tablespace

  • Perform recovery to a new location


Performing Recovery Part I - Performing Full Recovery
19:14

In this practice, you will perform the full recovery procedure to the following scenarios:

  • Complete recovery of the entire database in NOARCHIVELOG Mode

  • Complete recovery of the entire database in ARCHIVELOG Mode

  • Complete recovery of a user tablespace loss

Practice 11 - Performing Recovery Part I
26:01

In this lecture, you will learn how to perform the following:

  • Recover datafiles by switching to image copies

  • Describe the levels of implementing the Point-in-Time Recovery (PITR)

  • Perform database PITR


Performing Recovery Part II - Switching Data Files and Performing PITR
16:36

In this practice, you will perform the full recovery procedure to the following scenarios:

  • Recovery of datafiles loss by switching to image copies

  • Database point-in-time recovery (DBPITR):

    - without opening the database in read only state

    - with opening the database in read only state


Practice 12 - Performing Recovery Part II
20:04

In this lecture, you will learn how to do the following:

  • Perform tablespace point-in-time recovery TSPITR

  • Perform PITR on tables


Performing Recovery Part III - Performing PITR on Tablespaces and Tables
24:26

In this practice, you will implement the following recovery procedures:

  • Perform tablespace point-in-time recovery (TSPITR) on soetbs tablespace.

  • Recover specific tables using RMAN RECOVER command to a specific point-in-time in the past.


Practice 13 - Performing Recovery Part III
15:22

In this lecture, you will learn how to do the following:

  • Restore SPFILE

  • Restore control file

  • Restore objects with NOLOGGING operations


Performing Recovery Part IV - Recovering Control File and SPFILE
15:40

In this practice, you will implement the following recovery tasks:

  • Restore SPFILE from memory

  • Restore SPFILE from AUTOBACKUP

  • Recover from losing subset of control files

  • Recover from losing all control files

  • Recover objects with NOLOGGING operations


Practice 14 - Performing Recovery Part IV
20:51

In this lecture, you will learn how to recover from the following scenarios:

  • Loss of an inactive redo log group member

  • Loss of an redo log group on startup

  • Loss of an inactive redo log group while the database is in operation

  • Loss of an active redo log group

  • Loss of the current redo log group


Performing Recovery Part V - Recovering From Losing Redo Log Files
12:18

In this practice, you will implement the following recovery scenarios:

  • Recovery from loss of an inactive redo log group member

  • Recovery from loss of an inactive redo log group on database startup

  • Recovery from loss of an inactive redo log group while the database is in operation

  • Recovery from loss of an active redo log group

  • Recovery from loss of the current redo log group


Practice 15 - Performing Recovery Part V ( Part 1 of 2 )
11:37

This is to continue the previous lecture.

Practice 15 - Performing Recovery Part V ( Part 2 of 2 )
15:12

In this lecture, you will learn how to recover from the following scenarios:

  • Loss of the password file

  • Loss of tempfiles

  • Restoring encrypted backups

  • Restoring a database to a new host

Performing Recovery Part VI - Miscellaneous Recovery Scenarios
19:15

In this practice, you will implement the following recovery tasks:

  • Recovery from losing the password file

  • Recovery from losing temporary files

  • Restoring from a password-encrypted backupset

  • Restoring a database to a new host

Practice 16 - Performing Recovery Part VI
23:56