Skip To Content
Oracle Database 12c R2: Backup and Recovery Workshop is a Program

Oracle Database 12c R2: Backup and Recovery Workshop


Sorry! The enrollment period is currently closed. Please check back soon.

Full program description

Oracle Database 12c R2: Backup and Recovery Workshop

Course Overview

In this 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. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several failure situations.

Who Should Attend

  • Data Warehouse Administrator
  • Database Administrators
  • Support Engineer
  • Technical Administrator
  • Technical Consultant

Course Duration

5 Days, 35 Hours

Course Outline

  • Introduction
  • Getting Started
  • Configuring for Recoverablility
  • Using the RMAN Recovery Catalog
  • 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

Course Objectives

  • 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


Required Prerequisites

  • Knowledge of Oracle Database 12c
  • Knowledge of SQL and PL/SQL (for DBA use)
  • Oracle Database 12c R2: Install and Upgrade Workshop
  • Oracle Database 12c R2: Administration Workshop Ed 3


Suggested Prerequisites

  • Using Oracle Enterprise Manager Cloud Control 13c Ed 1
  • Using Oracle Enterprise Manager Cloud Control 13c Ed 2


Course Fee (before GST): SGD 4920.00

Course Fee (after GST): SGD 5264.40