Oracle Database 19c Backup and Recovery

Gain core skills to implement appropriate solutions for backup and recover, moving data between databases, basic montoring and more. Available for Oracle 12c / Oracle 18c / Oracle 19c


Intermediate and Beyond

3 Days

Course Overview

Oracle Database 19c Backup and Recovery is a comprehensive, hands-on course that allows DBAs to develop appropriate backup and recovery procedures to address their business model and requirements. Students will explore how to implement basic backup and recover procedures, move data between databases and files, and employ basic monitoring procedures. Students will also learn how to secure the availability of their database by using appropriate backup and recovery strategies.

Course Objectives

Our engaging instructors and mentors are highly-experienced practitioners who bring years of current "on-the-job" experience into every classroom. Working within in a hands-on learning environment, guided by our expert team, attendees will learn to:

  • Implement backup and recovery settings and perform backup operations to the media of your choice.
  • Move data between databases and files
  • Use Oracle Database recovery processes 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 their database using backup and recovery strategies

Course Prerequisites

This hands-on course is geared for experienced DBAs already working with Oracle. Incoming students should possess:

  • Knowledge of SQL and PL/SQL (for DBA use)
  • Knowledge of Oracle Database 18c or newer
  • Linux skills, including familiarity with command-line options such as ls, cd, cp, and su

Course Agenda

  1. Introduction
  • Oracle Maximum Availability Architecture
  • Assess your recovery requirements
  • Categories of failures
  • Basic Workshop Architecture
  • Curriculum Context
  • Oracle backup and recovery solutions
  • Overview of Oracle Secure Backup and Oracle Data Guard
  1. Getting Started
  • Oracle DBA tools for backup and recovery
  • Connecting to Oracle Recovery Manager (RMAN)
  • Review of Oracle Database architecture
  1. Configuring for Recoverability
  • Configuring and managing persistent settings
  • Multiplexing the control file
  • RMAN commands
  • Archiving redo log files
  • Using the Fast Recovery Area (FRA)
  • Multiplexing redo log files
  1. Using the RMAN Recovery Catalog
  • Creating and Configuring the Recovery Catalog
  • Using RMAN Stored Scripts
  • Using Virtual Private Catalogs
  • Managing Target Database Records in the Recovery Catalog
  • Maintaining and Protecting the Recovery Catalog
  1. Backup Strategies and Terminology
  • Backing Up Read-Only Tablespaces
  • Balancing Backup and Restore Requirements
  • Backup Terminology
  • Data Warehouse Backup and Recovery: Best Practices
  1. Performing Backups
  • RMAN Backup Types
  • Oracle-Suggested Backup
  • Reporting on Backups 
  • Managing Backups
  • Fast Incremental Backup
  • Incrementally Updated Backup


Course Materials

Student Materials: Each student will receive a Student Guide with course notes, code samples, software tutorials, diagrams and related reference materials and links (as applicable). Our courses also include step by step hands-on lab instructions and and solutions, clearly illustrated for users to complete hands-on work in class, and to revisit to review or refresh skills at any time. Students will also receive the project files (or code, if applicable) and solutions required for the hands-on work.

Raise the bar for advancing technology skills

Attend a Class!

Live scheduled classes are listed below or browse our full course catalog anytime

Special Offers

We regulary offer discounts for individuals, groups and corporate teams. Contact us

Custom Team Training

Check out custom training solutions planned around your unique needs and skills.

EveryCourse Extras

Exclusive materials, ongoing support and a free live course refresh with every class.

New Site, BIG Savings!
We're celebrating the launch of our lonnngggg awaited new site with with *50% off all 2021 Public Classes* booked by April 30!  Check out our Current Offers for Individuals, Teams and Organizations to Learn for Less!

See our latest Offers and Promotions

Learn. Explore. Advance!

Extend your training investment! Recorded sessions, free re-sits and after course support included with Every Course
Trivera MiniCamps
Gain the skills you need with less time in the classroom with our short course, live-online hands-on events
Trivera QuickSkills: Free Courses and Webinars
Training on us! Keep your skills current with free live events, courses & webinars
Trivera AfterCourse: Coaching and Support
Expert level after-training support to help organizations put new training skills into practice on the job

The voices of our customers speak volumes

Special Offers
Limited Offer for most courses.

SAVE 50%

Learn More