Oracle Database 12c: Backup & Recovery Workshop

Oracle Database 12c: Backup & Recovery Workshop

In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.

Suggested Prerequisites:

Knowledge of Oracle Database 12c

Knowledge of SQL and PL/SQL (for DBA use)

Required Prerequisites:

Oracle Database 12c R2: Install and Upgrade Workshop

Oracle Database 12c R2: Administration Workshop

You will learn how to:

  • Use Oracle Flashback Technologies to recover from human error
  • Use Recovery Manager (RMAN) to create backups and perform recovery operations
  • Use the Data Recovery Advisor to diagnose and repair failures
  • Plan effective backup and recovery procedures
  • Describe the Oracle Database architecture components related to backup and recovery operations
  • Perform an encrypted database backup and restore
  • Perform tablespace point-in-time recovery
  • Configure the database for recoverability
  • Describe Cloud Tooling for Backup and Recovery
  • Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure

This course covers the following;

  • Configuring for Recoverability
  • Using the Fast Recovery Area (FRA)
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Failures
  • Restore and Recovery Concepts
  • Performing Recovery, Part I
  • Performing Recovery, Part II
  • RMAN and Oracle Secure Backup
  • Using Flashback Technologies
  • Using Flashback Database
  • Transporting Data
  • Performing Point-in-Time Recovery
  • Duplicating a Database
  • RMAN Troubleshooting and Tuning
  • Cloud Tooling for Backup and Recovery
  • Backup and Recovery Workshop

This course prepares you for the following certifications:

  • Oracle Certified Profession (OCP) – (Database Admin)

How you will be assessed?



7th Feb 2020


7th March 2020


7th Sept 2020

E-learning Portal