Oracle Database: Backup and Recovery Workshop Course Overview

This Oracle Database 12c: Backup and Recovery Workshop will teach each you how to evaluate your own recovery requirements. You will develop appropriate strategies for backup, restore and recovery procedures from provided scenarios. In this course, you will be introduced to Oracle Database Cloud Service.

Learn To:

  • Develop backup and recovery procedures to address your business needs.
  • Implement backup and recovery settings and perform backup operations to disk and tape.
  • Employ Oracle Database recovery procedures to recover from media and other failures.
  • Diagnose and repair data failures.
  • Use Flashback Technologies and data duplication to complement backup and recovery procedures.
  • Secure the availability of your database by appropriate backup and recovery strategies.
  • Gain an understanding of the Oracle Database Cloud Service.

Benefits to You

Ensure fast, reliable, secure and easy to manage performance. Optimize database workloads, lower IT costs and deliver a higher quality of service by enabling consolidation onto database clouds.

Perform Backup and Recovery

Expert instructors will begin by helping you gain a deeper understanding of possibly the most important job of a Database Administrator, backup and recovery. The concepts and architecture that support backup and recovery, along with the steps required to carry it out in various ways and situations, are covered in detail.

Recovery Manager Command Line and Graphical Interfaces

This course will teach you about Recovery Manager (RMAN) command line and graphical interfaces for various backup, failure, restore and recovery scenarios.

Participate in Hands-on Practices and Workshops

Participating in extensive hands-on practices and workshops will help you gain experience in a realistic technical environment. Interactive workshops give you the opportunity to diagnose and recover from numerous failure scenarios, based on backup and recovery case studies.

Key Takeaways

Upon completing this course, you will know how to evaluate your own recovery requirements. You'll have the skills to develop an appropriate strategy for backup and recovery procedures.

Audience :

  • Administrator
  • Database Administrator



  • 1. Do you have limited Window for training?
  • 2. Can you only spend 4-hours per day?
  • 3. Do you want to start training immediately?
  • If your answer is yes to any one of the above, you need 1-on-1- Training
The 1-on-1 Advantage
Flexible Dates
4-Hour Sessions
  • View video
  • The course will be free if we are not able to start within 7 days of booking.
  • Only applicable for courses on which this logo appears.

Your will learn:

Module 1: Backup and Recovery: Overview
  • DBA Responsibilities
  • Separation of DBA Duties
  • Assessing Your Recovery Requirements
  • Categories of Failure
  • Statement Failure
  • User Process Failure
  • Network Failure
  • User Error
  • Instance Failure
  • Media Failure
  • Data Failures
  • Instance Recovery
  • The Checkpoint (CKPT) Process
  • Redo Log Files and the Log Writer (LGWR) Process
  • Database Log Mode
  • Automatic Instance Recovery or Crash Recovery
  • Phases of Instance Recovery
  • Tuning Instance Recovery
  • Using the MTTR Advisor
  • Restoring and Recovering
  • Comparing Complete and Incomplete Recovery
  • The Complete Recovery Process
  • The Point-in-Time Recovery Process
  • Oracle Data Protection Solutions
  • Flashback Technology
  • Objectives
  • Configuring for Recoverability
  • Configuring the Fast Recovery Area
  • Monitoring the Fast Recovery Area
  • Multiplexing Control Files 2-6Redo Log Files
  • Multiplexing the Redo Log
  • Creating Archived Redo Log Files
  • Archiver (ARCn) Process
  • Archived Redo Log Files: Naming and Destinations
  • Configuring ARCHIVELOG Mode
  • Summary
  • Practice Overview
  • Objectives
  • Integrated Oracle Recovery Manager (RMAN)
  • Connecting to RMAN and a Target Database
  • Using SQL in RMAN
  • Types of RMAN Commands
  • Job Commands: Example
  • Configuring Persistent Settings for RMAN
  • Viewing Persistent Settings
  • Managing Persistent Settings
  • Specifying a Retention Policy
  • Recovery Window Retention Policy: Example
  • Summary
  • Practice Overview
  • Objectives
  • Understanding Types of Backups
  • Backup Terminology
  • Understanding Types of Backups
  • RMAN Backup Types
  • Backup Solutions: Overview
  • Balancing Backup and Restore Requirements
  • Comparing Backup Strategies
  • Option 1: Full and Incremental Backups
  • Option 2: Incrementally Updated Disk Backups
  • Option 3: Offloading Backups to Physical Standby Database in Data
  • Guard Environment
  • Objectives
  • Using RMAN Commands to Create Backups
  • Syntax and Clauses in RMAN
  • Creating Backup Sets
  • Creating Image Copies
  • Creating a Whole Database Backup
  • CDB Backup: Whole CDB Backup
  • CDB Backup: Partial CDB Backup
  • PDB Backup: Partial PDB Backup
  • Review: RMAN Backup Types
  • Incrementally Updated Backups
  • Incrementally Updated Backups: Example
  • Fast Incremental Backup
  • Maintaining the Block Change Tracking File
  • Monitoring Block Change Tracking
  • Automatic Disk-to-Disk Backup and Recovery
  • Oracle-Suggested Backup
  • Backing Up the Control File to a Trace File
  • Cataloging Additional Backup Files
  • Reporting on Backups
  • Using Dynamic Views
  • Summary
  • Practice Overview
  • Objectives
  • Saving Backup Space with Unused Block Compression
  • Compressing Backups
  • Using RMAN Backup Compression
  • Using a Media Manager
  • Configuring Backup and Restore for Very Large Files
  • Backing Up and Restoring Very Large Files
  • Creating RMAN Multisection Backups
  • Creating Proxy Copies
  • Creating Duplexed Backup Sets by Using BACKUP COPIES
  • Creating Backups of Backup Sets
  • Archival Backups: Concepts
  • Creating Archival Backups with RMAN
  • Managing Archival Database Backups
  • Backing Up Read-Only Tablespaces: Considerations
  • Data Warehouse Backup and Recovery: Best Practices
  • Summary 4-17Backing Up Recovery Files
  • Summary
  • Practice Overview
  • Is There a Problem?
  • Diagnosing Performance Bottlenecks
  • Diagnosing Performance Bottlenecks: Read Phase
  • Is There a “Write” Problem?
  • Diagnosing Performance Bottlenecks: Write or Copy Phase
  • Using Dynamic Views to Diagnose RMAN Performance
  • Monitoring RMAN Job Progress
  • Identifying Backup and Restore Bottlenecks
  • Asynchronous I/O Bottlenecks
  • Synchronous I/O Bottlenecks
  • Tuning RMAN Backup Performance
  • Parallelization of Backup Sets
  • RMAN Multiplexing
  • RMAN Repository Data Storage: Comparison of Options
  • Storing Information in the Recovery Catalog
  • Reasons to Use a Recovery Catalog
  • Creating the Recovery Catalog: Three Steps
  • 1.  Configuring the Recovery Catalog Database
  • 2.  Creating the Recovery Catalog Owner
  • 3.  Creating the Recovery Catalog
  • Summary
  • Practice Overview
  • Managing Target Database Records in the Recovery Catalog
  • Registering a Database in the Recovery Catalog
  • Unregistering a Target Database from the Recovery Catalog
  • Recovery Catalog Resynchronization: Concepts
  • Manually Resynchronizing the Recovery Catalog
  • Using RMAN Stored Scripts
  • Executing RMAN Stored Scripts
  • Maintaining RMAN Stored Scripts
  • Objectives
  • Creating and Using Virtual Private Catalogs
  • Creating a Virtual Private Catalog
  • Managing Virtual Private Catalogs
  • Upgrading Virtual Private Catalogs
  • Summary
  • Practice Overview
  • Objectives
  • File Loss
  • Data Repair Techniques
  • Restoring and Recovering
  • Using RMAN RESTORE and RECOVER Commands
  • Instance Failure
  • Instance Recovery
  • Phases of Instance Recovery
  • Media Failure
  • Comparing Complete and Incomplete Recovery
  • Complete Recovery Process
  • Point-in-Time Recovery Process
  • Recovery with the RESETLOGS Option
  • Restore and Recovery Performance: Best Practices
  • Summary
  • Objectives
  • Reducing Problem Diagnosis Time
  • Automatic Diagnostic Workflow
  • Automatic Diagnostic Repository
  • ADR Command-Line Tool (ADRCI)
  • V$DIAG_INFO View
  • Data Recovery Advisor
  • Data Failure: Examples
  • Data Recovery Advisor RMAN Command-Line Interface
  • Listing Data Failures
  • Advising on Repair
  • Executing Repairs
  • Classifying (and Closing) Failures
  • Data Recovery Advisor Views
  • Objectives
  • Ensuring Backups Are Available
  • Restoring in NOARCHIVELOG Mode
  • Recovery with Incremental Backups in NOARCHIVELOG Mode
  • Performing Complete Recovery
  • Review: Recovering Image Copies
  • Recovering Image Copies: Example
  • Performing a Fast Switch to Image Copies
  • Using SET NEWNAME for Switching Files
  • Using Restore Points
  • PDB Tempfile Recovery
  • PDB SYSTEM or UNDO Tablespace Recovery
  • PDB Non-SYSTEM Tablespace Recovery
  • Summary
  • Practice Overview
  • Objectives
  • Point-in-Time Recovery
  • PITR Terminology
  • Performing Point-in-Time Recovery
  • When to Use TSPITR
  • Table space Point-in-Time Recovery: Architecture
  • Preparing for TSPITR
  • Determining the Correct Target Time
  • Determining the Table spaces for the Recovery Set
  • Identifying Objects That Will Be Lost
  • Performing RMAN TSPITR
  • Performing Fully Automated TSPITR
  • Improving TSPITR Performance
  • Performing RMAN TSPITR with an RMAN-Managed Auxiliary Instance
  • Performing RMAN TSPITR by Using Your Own Auxiliary Instance
  • Troubleshooting RMAN TSPITR
  • PITR of PDBs
  • Recovering Tables from Backups
  • Table Recovery: Graphical Overview
  • Prerequisites and Limitations
  • Specifying the Recovery Point in Time
  • Process Steps of Table Recovery
  • Summary
  • Practice Overview
  • What Is Block Corruption?
  • Block Corruption Symptoms: ORA-01578
  • How to Handle Corruption
  • Setting Parameters to Detect Corruption
  • Block Media Recovery
  • Prerequisites for Block Media Recovery
  • Recovering Individual Blocks
  • Best Practice: Proactive Checks
  • Checking for Block Corruption
  • Recovery from Loss of Server Parameter File
  • Restoring the Server Parameter File from the Control File Autobackup
  • Loss of a Control File
  • Recovering from the Loss of All Control File Copies: Overview
  • Restoring the Control File from Autobackup
  • Restoring the SPFILE and the Control File
  • Recovering NOLOGGING Database Objects
  • Loss of a Redo Log File
  • Log Group Status: Review
  • Recovering from the Loss of a Redo Log Group
  • Clearing a Log File
  • Re-creating a Password Authentication File
  • Practice Overview
  • Flashback Technologies Error Detection and Correction
  • Review: Transactions and Undo
  • Flashback Technology
  • Summary
  • Using Flashback Technology to Query Data
  • Flashback Query
  • Flashback Version Query
  • Flashback Table: Overview
  • Flashback Table
  • Flashback Table: Considerations
  • Flashback Transaction Query
  • Flashback Transaction Query: Considerations
  • Flashback Transaction Backout
  • Flashing Back a Transaction
  • Best Practices: Undo-Based Flashback Query, Flashback Table
  • Flashback Drop and the Recycle Bin
  • Recycle Bin
  • Bypassing the Recycle Bin
  • Using Flashback Data Archives
  • Creating a Temporal History and Enabling Archiving
  • How the Flashback Data Archive Works
  • Collecting User Context in Temporal History
  • Transparent Schema Evolution
  • Full Schema Evolution
  • Temporal Validity and History
  • Using the PERIOD FOR Clause
  • Filtering on Valid-Time Columns: Example
  • Filtering on Valid-Time Columns: Example
  • Preparing Your Database for Flashback
  • Guaranteeing Undo Retention
  • Flashback Database: Continuous Data Protection
  • Flashback Database
  • Flashback Database Architecture
  • Configuring Flashback Database
  • Flashback Database: Examples
  • CDB and PDB Flashback
  • Flashback Database Considerations
  • Monitoring Flashback Database Information
  • Guaranteed Restore Points
  • Flashback Database and Guaranteed Restore Points
  • PDB Flashback and Clean Restore Point
  • Best Practices: Flashback Database
  • Objectives
  • PDB Snapshot Carousel
  • Creating PDB Snapshots
  • Creating PDBs by Using PDB Snapshots
  • Dropping PDB Snapshots
  • Flashing Back PDBs by Using PDB Snapshots
  • Summary
  • Objectives
  • Using a Duplicate Database
  • Choosing Database Duplication Techniques
  • Duplicating an Active Database with “Push”
  • Comparing the “Push” and “Pull” Methods of Duplication
  • Duplicating a Database with a Target Connection
  • Duplicating a Database with a Recovery Catalog
  • Duplicating a Database Without a Recovery Catalog or Target Connection
  • Summary
  • Objectives
  • Creating a Backup-Based Duplicate Database
  • Creating an Initialization Parameter File for the Auxiliary Instance
  • Specifying New Names for Your Destination
  • Using the SET NEWNAME Clauses
  • Substitution Variables for SET NEWNAME
  • Specifying Parameters for File Naming
  • Starting the Instance in NOMOUNT Mode
  • Ensuring That Backups and Archived Redo Log Files Are Available
  • Allocating Auxiliary Channels
  • Understanding the RMAN Duplication Operation
  • Specifying Options for the DUPLICATE Command
  • Using Additional DUPLICATE Command Options
  • Duplicating Selected PDBs in a CDB
  • Cloning an Active PDB into an Existing CDB
  • Example: Duplicating PDB1 from CDB1 to CDB2 as PDB1
  • Example: Duplicating PDB1 from CDB1 to CDB2 as PDB2
  • Practice Overview
Live Online Training (Duration : 40 Hours)
Group Training 3050 Per Participant Incl. Official Courseware
06 - 10 Jun 09:00 AM - 05:00 PM CST
(8 Hours/Day)
04 - 08 Jul 09:00 AM - 05:00 PM CST
(8 Hours/Day)
1-on-1 Training 6100 3500 + If you accept merging of other students. Incl. Official Courseware
8 Hours
Week Days

Start Time : At any time

12 AM
12 PM

1-On-1 Training is Guaranteed to Run (GTR)
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Classroom Training is available. Enquire for the fee Click
Ultra-Fast Track

If you can't spare 40 hours. We can offer you an Ultra-Fast Track for 20 hours for only USD 2,800

Course Prerequisites

Suggested Prerequisite

  • CDT Using Oracle Enterprise Manager Cloud Control 12c

Required Prerequisite

  • Knowledge of SQL and PL/SQL
  • Knowledge of Oracle Database 12c


After completion of this course, you will learn how to : 

  • Introduction
  • Getting Started
  • Configuring for Recoverability
  • Using the RMAN Recovery Catalog
  • Backup Strategies and Terminology
  • Performing Backups
  • Improving Your Backups
  • Using RMAN-Encrypted Backups
  • Diagnosing Database Failures
  • Restore and Recovery Concepts
  • Performing Recovery, Part 1
  • Performing Recovery, Part 2
  • RMAN and Oracle Secure Backup
  • Performing Tape Backups and Restores
  • Using Flashback Technologies
  • Using Flashback Database
  • Managing Backup Space or Transporting Data
  • Duplicating a Database
  • RMAN Performance and Tuning
  • Backup and Recovery Workshop
  • Oracle Database Cloud Service: Overview


Request More Information

Add Name and Email Address of participant (If different from you)


No, the published fee includes all applicable taxes.
The Fee includes:
  • Official courseware
  • Testing Via Qubits
Yes, Koenig Solutions is a Oracle Learning Partner