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

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

Course Curriculum

  • 1

    Introduction

    • Introducing the course

    • Introducing the Course (Resources)
  • 2

    Preparing the Course Practice Environment

    • Preparing the Course Practice Environment (Resources)

    • Practice 1 - Preparing the Course Practice Environment - Part 1

    • Practice 1 - Preparing the Course Practice Environment - Part 2

    • Practice 1 - Preparing the Course Practice Environment - Part 3

    • Practice 1 - Preparing the Course Practice Environment - Part 4
  • 3

    Introducing Backup and Recovery in RMAN

    • Introducing Backup and Recovery in RMAN (Resources)

    • Introduction to Oracle Backup and Recovery Solutions

    • Configuring Oracle Database for Backup and Recovery

    • Introduction to Recovery Manager (RMAN)

    • Practice 2 - Introducing RMAN
  • 4

    Performing Backups in RMAN

    • Performing Backups in RMAN (Resources)

    • Performing RMAN Full Backups - Part I

    • Practice 3 - Performing RMAN Backups - Part I

    • Performing RMAN Full Backups - Part II

    • Practice 4 - Performing RMAN Backups - Part II

    • Performing Incremental Backups

    • Practice 5 - Performing Incremental Backups - Part I

    • Practice 5 - Performing Incremental Backups - Part II

    • Configuring RMAN Persistent Settings

    • Practice 6 - Configuring RMAN Persistent Settings
  • 5

    Retrieve Information about RMAN Backups and Jobs

    • Retrieve Information about RMAN Backups and Jobs (Resources)

    • Reporting and Monitoring RMAN Backups and Jobs - Part I

    • Reporting and Monitoring RMAN Backups and Jobs - Part II

    • Practice 7 - Reporting and Monitoring RMAN Backups and Jobs - Part I

    • Practice 7 - Reporting and Monitoring RMAN Backups and Jobs - Part II

    • Practice 7 - Reporting and Monitoring RMAN Backups and Jobs - Part III
  • 6

    Improving Backups

    • Improving Backups (Resources)

    • Improving Backups - Part I

    • Improving Backups - Part II

    • Improving Backups - Part III

    • Practice 8 - Improving Backups
  • 7

    Managing RMAN Recovery Catalog

    • Managing RMAN Recovery Catalog (Resources)

    • Using RMAN Recovery Catalog - Part I

    • Using RMAN Recovery Catalog - Part II

    • Practice 9 - Using RMAN Recovery Catalog
  • 8

    Securing RMAN Backups

    • Securing RMAN Backups (Resources)

    • Using RMAN-Encrypted Backups

    • Practice 10 - Using RMAN-Encrypted Backups
  • 9

    Common Backup Practices

    • Common Backup Practices (Resources)

    • Common Backup Practices - Part I

    • Common Backup Practices - Part II
  • 10

    Performing Recovery Scenarios in RMAN

    • Performing Recovery Scenarios in RMAN (Resources)

    • Introducing RESTORE and RECOVER Commands

    • Performing Recovery Part I - Performing Full Recovery

    • Practice 11 - Performing Recovery Part I

    • Performing Recovery Part II - Switching Data Files and Performing PITR

    • Practice 12 - Performing Recovery Part II

    • Performing Recovery Part III - Performing PITR on Tablespaces and Tables

    • Practice 13 - Performing Recovery Part III

    • Performing Recovery Part IV - Recovering Control File and SPFILE

    • Practice 14 - Performing Recovery Part IV

    • Performing Recovery Part V - Recovering From Losing Redo Log Files

    • Practice 15 - Performing Recovery Part V - Part 1

    • Practice 15 - Performing Recovery Part V - Part 2

    • Performing Recovery Part VI - Miscellaneous Recovery Scenarios

    • Practice 16 - Performing Recovery Part VI
  • 11

    Using Data Recovery Advisor

    • Using Data Recovery Advisor (Resources)

    • Using Data Recovery Advisor

    • Practice 17 - Using Data Recovery Advisor

    • Handling Corrupted Blocks

    • Practice 18 - Handling Corrupted Blocks
  • 12

    Performing Cross-Platform Data Transportation

    • Introduction to Cross-Platform Data Transportation

    • Cross-Platform Data Transport Using Image Copies - Part 1

    • Cross-Platform Data Transport Using Image Copies - Part 2

    • Practice 19 - Cross-Platform Data Transport Using Image Copies - Part 1

    • Performing Cross-Platform Data Transportation (Resources)

    • Practice 19 - Cross-Platform Data Transport Using Image Copies - Part 2

    • Cross-Platform Data Transport Using Backupsets - Part I

    • Cross-Platform Data Transport Using Backupsets - Part II

    • Practice 20 - Cross-Platform Data Transport Using Backupsets
  • 13

    Duplicating a Database Using RMAN

    • Duplicating a Database Using RMAN (Resources)

    • Duplicating a Database using RMAN - Part I

    • Duplicating a Database using RMAN - Part II

    • Practice 21 - Duplicating a Database using RMAN
  • 14

    RMAN Troubleshooting and Performance Tuning

    • RMAN Troubleshooting and Performance Tuning (Resources)

    • RMAN Troubleshooting

    • RMAN Performance Tuning Part I

    • RMAN Performance Tuning Part II
  • 15

    Using RMAN in Oracle Multitenant Databases

    • Using RMAN in Oracle Multitenant Databases (Resources)

    • Using RMAN in Oracle Multitenant Databases

    • Practice 22 - Using RMAN in Oracle Multitenant Databases - Part I

    • Practice 22 - Using RMAN in Oracle Multitenant Databases - Part II
  • 16

    Using RMAN in Oracle RAC

    • Using RMAN in Oracle RAC (Resources)

    • Using RMAN in Oracle RAC

    • Using RMAN in Oracle RAC - Demonstration
  • 17

    Using Oracle Database Backup Cloud Service

    • Using Oracle Database Backup Cloud Service (Resources)

    • Using Oracle Database Backup Cloud Service

    • Practice 23 - Using Oracle Database Backup Cloud Service

About the instructor

IT Manager

Eric Chu

A proven and experienced IT Manager, customer-focused and equipped with a technical background. I have over 8 years’ experience in IT Service Delivery Management and leading small to medium crossfunctional teams, and over 15 years of experience in IT Training and Sales.Through my passion for technology, science, and innovation, I have fostered extensive practical knowledge of emerging technologies, complex networks, and data centre eco-systems.I have had the opportunity to work across the Asia Pacific region as an experienced Business Development Manager and IT Project Manager delivering end to end solutions.

What others have been saying about this course:

Use your Call To Action description to encourage students to sign up for your course

Sign up now!

You may also be interested in...