Gain practical skills for planning, implementing and managing Oracle Database backup and recovery using RMAN and Flashback Database. This course supports versions 12cR2, 18c and 19c, giving you the confidence to safeguard data, recover from errors, and meet business continuity needs.
Oracle Database 18c Backup and Recovery with RMAN
Gain control of your Oracle backup and recovery strategy
Over four days, you’ll learn to plan effective backup and disaster recovery strategies, manage recovery catalogs, and perform secure RMAN backups. You’ll also restore databases, use Flashback for error recovery, tune RMAN performance, and create duplicate environments for testing or migration.
Learning objectives
- Plan backup and disaster recovery strategies
- Create and manage a recovery catalog
- Perform and validate RMAN backups
- Restore and recover databases and tablespaces
- Use Flashback features to recover from errors
- Monitor and tune RMAN performance
- Perform encrypted backups and restores
- Create duplicate databases
What you’ll learn
Gain expertise in protecting and recovering Oracle Databases with RMAN and Flashback. Learn how to design recovery strategies, manage catalogs, perform secure backups, restore data, and create duplicates to ensure business continuity, minimise downtime and protect critical data during failures, migrations or development projects.
Backup strategy planning
Learn to assess organisational needs and create an effective Oracle Database backup and recovery strategy. You’ll develop disaster recovery plans, compare backup methods, and validate approaches while exploring archive log mode, checkpointing and Flash Recovery Area usage. You’ll also use dynamic performance views to monitor backup integrity, ensuring business continuity and safeguarding data from hardware failure or human error.
RMAN fundamentals and configuration
Gain practical skills in configuring Oracle Recovery Manager (RMAN) for efficient, reliable backups. Learn how to create and manage a recovery catalogue, register databases, and set retention policies and auto-backups. You’ll also explore media manager integration, encryption options, channel allocation, backup file types, recovery area setup, and backup validation a helping you confidently administer RMAN in production environments.
Advanced backup and recovery techniques
Enhance your RMAN expertise to manage complex recovery scenarios. Learn point-in-time recovery, incremental backups, switch operations, database duplication, and creating compressed or multi-section backups. You’ll also gain expertise in ASM metadata backups, Oracle Secure Backup, Enterprise Manager integration, RMAN performance tuning, troubleshooting, and using Data Recovery Advisor to diagnose and resolve issues quickly, ensuring optimal performance and resilience in high-availability Oracle Database environments.
Flashback and data recovery advisor
Discover how Oracle Flashback technology simplifies error correction and speeds up recovery. Gain experience in configuring Flashback Database, Table, and Drop to restore data instantly, and use queries and archives for auditing. You’ll also learn to monitor space, manage restore points, and apply Data Recovery Advisor to detect, diagnose, and repair issues, for reducing downtime and boosting database resilience.
What’s included
- Four days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
Oracle DBAs, data warehouse administrators and technical support staff who manage backup and recovery operations.
Prerequisites
Working knowledge of Oracle SQL and database administration. Familiarity with Linux or UNIX is beneficial but not required.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
Explore in-depth backup and recovery concepts, including tablespace recovery, Flashback, and RMAN features, with practical application tailored to Oracle Database 18c environments.
What versions of Oracle are covered in this course?
This course covers Oracle Database 12cR2, 18c and 19c, combining version-specific features with universally applicable RMAN and Flashback techniques. Through hands-on live labs, you’ll practice across all three versions, gaining skills to maintain legacy systems, support upgrades and meet the performance, reliability and recovery requirements of modern enterprise database environments.
Will I learn how to perform tablespace point-in-time recovery?
Yes. The course covers Tablespace Point-in-Time Recovery (TSPITR) in detail, showing you how to isolate and restore specific tablespaces without affecting the full database. Through practical RMAN exercises, you’ll configure backups, set up an auxiliary instance, and practice real-world recovery scenarios to minimise disruption, reduce downtime and maintain business continuity.
Does the course cover how to use Flashback features?
Yes. You’ll gain practical experience with Oracle Flashback technologies, including Flashback Database, Table, Drop, and Query. Learn to configure, monitor, and manage space usage, apply restore points, and use Flashback Transaction Query and Data Archive. Through exercises, you'll also be able to demonstrate how to identify, reverse, and document changes without a full restore, helping to reducing downtime and preserving resources.
Will this course help me prepare for Oracle certification?
Yes. This course supports preparation for the Oracle Database Administration II: 1Z0-083 exam, covering RMAN configuration, Flashback features, disaster recovery planning and error resolution. Following the official curriculum, it combines expert instruction with hands-on live labs, helping you strengthen core skills and bridge knowledge gaps as part of a broader certification study plan.
What our customers say
“Great course. Alan has been courteous and informative throughout. Highly recommended and will absolutely be coming back for more courses.”
Bradley, Software Engineer – Government
“The training was absolutely fantastic. Hats off to the trainer John.”
Jomon, Senior Specialist Engineer SRE - Government
Why study with StayAhead
96% customer satisfaction
We combine experience and passion to deliver training that meets the highest standards
30+ years’ experience
Industry-leading specialists delivering high-impact IT training
Experiential instructor-led training
Courses are delivered by experienced instructors using hands-on, practical live labs