Teach on Udemy

Turn what you know into an opportunity and reach millions around the world.

Learn More

Your cart is empty.

Keep shopping

Oracle Database 12c Backup and Recovery using RMAN

Name: Oracle Database 12c Backup and Recovery using RMAN
Rating: 4.7 (424 reviews)

Master Oracle RMAN backup and recovery for single-instance, RAC, multitenant, and cloud databases

Created byAhmed Baraka

Last updated 2/2024

English

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

Course content

18 sections • 74 lectures • 20h 5m total length

Introduction6: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.

Practice 1 - Preparing the Course Practice Environment (Part 1 of 4)16:01
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.
Practice 1 - Preparing the Course Practice Environment (Part 2 of 4)21:24
This is part 2 of Practice 2.
Practice 1 - Preparing the Course Practice Environment (Part 3 of 4)18:10
This is part 2 of Practice 1.
Practice 1 - Preparing the Course Practice Environment (Part 4 of 4)28:08
This is the last part of practice 1.

Introduction to Oracle Backup and Recovery Solutions19:55
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
Configuring Oracle Database for Backup and Recovery23:31
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
Introduction to Recovery Manager (RMAN)25:04
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
Practice 2 - Introducing RMAN10:35
In this practice you will get familiar with starting and configuring RMAN.

Performing RMAN Backups - Part I22:33
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
Practice 3 - Performing RMAN Backups - Part I18:45
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
Performing RMAN Full Backups - Part II24:02
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
Practice 4 - Performing RMAN Backups - Part II11:40
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
Performing Incremental Backups22:31
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)
Practice 5 - Performing Incremental Backups (Part 1 of 2)15:02
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 2 of 2)13:32
This is to continue the previous lecture.
Configuring RMAN Persistent Settings29:35
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
Practice 6 - Configuring RMAN Persistent Settings10:01
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

Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 2 )15:32
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 2 of 2 )11:47
This is to continue the previous lecture.
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 1 of 3 )11:13
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 2 of 3 )9:14
This is to continue the previous lecture.
Practice 7 - Reporting and Monitoring RMAN Backups and Jobs ( Part 3 of 3 )9:32
This is to continue the previous lecture.

Improving Backups ( Part 1 of 3 )13:02
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 2 of 3 )14:57
This is to continue the previous lecture.
Improving Backups ( Part 3 of 3 )11:56
This is to continue the previous lecture.
Practice 8 - Improving Backups15:23
In this practice, you will perform the following tasks:
Enable compression when making backupsets
Take backups with multisection option
Create an archival backup

Using RMAN Recovery Catalog ( Part 1 of 2 )12:27
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 2 of 2 )16:23
This is to continue the previous lecture.
Practice 9 - Using RMAN Recovery Catalog12:13
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

Using RMAN-Encrypted Backups20:26
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
Practice 10 - Using RMAN-Encrypted Backups11:20
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

Common Backup Practices ( Part 1 of 2 )18:18
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 2 of 2 )15:38
This is to continue the previous lecture.

Introducing RESTORE and RECOVER Commands17:05
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
Performing Recovery Part I - Performing Full Recovery19:14
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
Practice 11 - Performing Recovery Part I26:01
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
Performing Recovery Part II - Switching Data Files and Performing PITR16:36
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
Practice 12 - Performing Recovery Part II20:04
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
Performing Recovery Part III - Performing PITR on Tablespaces and Tables24:26
In this lecture, you will learn how to do the following:
Perform tablespace point-in-time recovery TSPITR
Perform PITR on tables
Practice 13 - Performing Recovery Part III15:22
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.
Performing Recovery Part IV - Recovering Control File and SPFILE15:40
In this lecture, you will learn how to do the following:
Restore SPFILE
Restore control file
Restore objects with NOLOGGING operations
Practice 14 - Performing Recovery Part IV20:51
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
Performing Recovery Part V - Recovering From Losing Redo Log Files12:18
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
Practice 15 - Performing Recovery Part V ( Part 1 of 2 )11:37
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 2 of 2 )15:12
This is to continue the previous lecture.
Performing Recovery Part VI - Miscellaneous Recovery Scenarios19:15
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
Practice 16 - Performing Recovery Part VI23:56
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

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 Oracle RMAN to perform reliable backup and recovery operations on Oracle databases, with a strong focus on real-world DBA scenarios.

This course covers backup and recovery for single-instance databases, as well as Oracle RAC, multitenant environments, and Oracle Database Cloud Service. You will not only understand the concepts behind Oracle backup and recovery, but also gain hands-on experience implementing and testing them step by step.

You will learn how to:

Understand Oracle technologies involved in backup and recovery
Use RMAN to implement all backup strategies and types, including:
- Whole and partial backups
- Full and incremental backups
- Complete and incomplete recovery
- Online and offline backups
Implement advanced backup options, such as:
- Compression and encryption
- Multisection backups
- Duplexing and archival backups
Perform common recovery scenarios, including:
- Loss of critical database files
- Loss of application data
- Loss of non-critical database files
Manage RMAN Recovery Catalog
Perform cross-platform data transportation
Duplicate and clone databases using RMAN
Use Oracle Database Backup Cloud Service
Use RMAN in Oracle RAC and multitenant databases
Apply best practices when designing backup and recovery plans

The course starts with Oracle RMAN architecture and gradually moves to advanced backup configurations and recovery scenarios. Each concept is followed by a fully demonstrated hands-on exercise, supported by video demonstrations and downloadable guide documents.

By the end of the course, you will be able to design, implement, and validate backup and recovery strategies for Oracle databases in production environments, ensuring database protection against unexpected failures.

Join this learning journey and gain one of the most critical skills every Oracle DBA must have.

Who this course is for:

Oracle Database Administrators who to create and implement a backup and recovery plan of Oracle databases using RMAN

Oracle Database 12c Backup and Recovery using RMAN

What you'll learn

Explore related topics

Course content

Introduction1 lecture • 6min

Preparing the Course Practice Environment4 lectures • 1hr 24min

Introducing Backup and Recovery in RMAN4 lectures • 1hr 19min

Performing Backups in RMAN9 lectures • 2hr 48min

Retrieve Information about RMAN Backups and Jobs5 lectures • 57min

Improving Backups4 lectures • 55min

Managing RMAN Recovery Catalog3 lectures • 41min

Securing RMAN Backups2 lectures • 32min

Common Backup Practices2 lectures • 34min

Performing Recovery Scenarios in RMAN14 lectures • 4hr 18min

Requirements

Description

Who this course is for: