Skip to Scheduled Dates
Course Overview
What happens when disaster strikes your Oracle database? Do you have the tools and techniques to recover fast and minimize downtime? The Oracle Database 19c Backup and Recovery course equips you with critical skills to protect and restore enterprise data using Oracle’s most powerful tools—including RMAN, the Recovery Catalog, and Data Recovery Advisor. Learn to perform reliable backup and recovery operations, configure flashback database features, and use Oracle Data Guard to ensure business continuity.
Through hands-on labs and real-world scenarios, you'll gain the confidence to back up the database and recover from failure efficiently and effectively. Oracle Database 19c: Backup and Recovery course is aligned with Oracle's certification path and supports preparation for the Oracle Database Administration II (1Z0-083) certification exam
Who Should Attend
- Oracle Database Administrator
- Data Warehouse Administrator
- Support Engineer
- Technical Consultant
- Technical Administrator
Course Objectives
In this training, you’ll learn how to implement a backup and recovery strategy using Oracle Database 19c’s built-in tools. You’ll gain hands-on experience with Oracle Recovery Manager (RMAN), configure the Fast Recovery Area (FRA), manage recovery catalog metadata, and use Data Recovery Advisor to automate diagnosis and resolution of issues. The course also covers physical backups, flashback database, block media recovery, disaster recovery techniques with Oracle Data Guard, and how to manage backup retention and performance. By the end, you’ll be prepared to perform backup and recovery tasks with confidence—whether you're responding to media failure or restoring the entire database.
Course Outline
Introduction to Backup and Recovery
- Concepts and importance of a solid backup and recovery strategy
- Overview of Oracle Database backup and recovery tools
Getting Started with Oracle Database 19c
- Architecture and storage structures
- Preparing your target database for recovery operations
Configuring for Recoverability
- Using Oracle Secure Backup
- Configuring the Fast Recovery Area (FRA)
RMAN and Recovery Catalog
- Setting up and using Recovery Manager (RMAN)
- Creating and managing the recovery catalog
Backup Strategies and Tasks
- Full, incremental, and image copy backups
- Automating RMAN backup tasks
Encrypted and Compressed Backups
- Performing secure disk backups with RMAN
- Managing backup sets and backup destinations
Restore and Recovery Techniques
- Complete and point-in-time recovery operations
- Block media recovery and flashback database
Using Data Recovery Advisor
- Diagnosing failures
- Initiating automated recovery
Duplicate and Transportable Databases
- Cloning databases for testing
- Transporting data across platforms
RMAN Troubleshooting and Optimization
- Monitoring and tuning RMAN performance
- Troubleshooting common backup and recovery issues