Using Oracle’s Recovery Manager (RMAN) and Flashback technologies, this course equips learners with the practical knowledge required to protect and restore data in complex environments. With a strong focus on real-world application, this course supports Oracle versions 12cR2, 18c and 19c, and is closely aligned with certification pathways.
Oracle Database 19c Backup and Recovery with RMAN
Protect your critical data with RMAN training
Learn how to plan, implement, and manage backup and recovery strategies using RMAN and Flashback technologies. Whether you're a database administrator, technical support professional or data specialist, this course prepares you to manage recovery confidently, reduce downtime, and add measurable value to your team or organisation.
Learning objectives
- Plan and test backup and disaster recovery strategies
- Use RMAN to perform and manage backups
- Restore and recover databases, tablespaces and files
- Work with encrypted and compressed backups
- Set up and manage a recovery catalogue
- Use flashback tools to recover from mistakes
- Duplicate databases for testing or recovery
- Monitor, troubleshoot and fine-tune backup processes
What you’ll learn
Learn how to plan and implement reliable backup and disaster recovery strategies tailored to Oracle environments. The course covers encrypted backups, database duplication, and performance tuning techniques, all reinforced through practical live labs that prepare you to confidently manage recovery challenges.
Backup and recovery planning
Learn how to assess your Oracle database environment and build a backup strategy that meets your business needs. Our experienced trainers will offer guidance on disaster recovery planning, so you can respond quickly when something goes wrong. You’ll also explore how to test and validate your strategy to ensure it performs effectively when required.
Understanding RMAN fundamentals
Oracle’s Recovery Manager (RMAN) is a powerful tool, and this course equips you to use it effectively in routine operations. You’ll learn how to connect RMAN to your Oracle 19c environment, run essential commands, and configure backup settings that suit your systems. We'll also show you how to set up and manage a recovery catalogue, helping you keep track of backups and simplify recovery.
Advanced backup options
Discover more advanced RMAN features that can enhance your Oracle database setup. You’ll learn how to create encrypted backups to keep data secure and understand how compression can save space without impacting processing speeds. The course also covers duplexed and multisection backups, providing options to improve performance and enhance data protection. These techniques are particularly useful for managing large-scale environments and strengthening security measures, helping you work more efficiently and maintain control over your backup processes.
What’s included
- 4 days of instructor-led training in a live virtual classroom
- Interactive hands-on live labs
- All relevant course materials
Key facts
Ideal for
Database administrators, support engineers, and other professionals responsible for ensuring reliable database backups and effective recovery processes.
Prerequisites
You should first have completed our Oracle SQL or Oracle Database 19c Administration courses or have a similar level of experience in database administration.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one.
FAQs
This course is designed to provide practical experience with Oracle RMAN and Flashback features. You’ll learn how to perform reliable database backups, recover from various failure scenarios, and develop a strategy that ensures ongoing data protection.
What is RMAN and why should I use it?
RMAN (Recovery Manager) is Oracle’s built-in tool for database backups, restoration, and recovery. It’s powerful, reliable, and designed specifically for Oracle environments. Unlike manual backup methods, RMAN keeps track of your backups, checks for corruption, and can automate complex recovery tasks, ensuring your data is protected and easily recoverable if something goes wrong.
Can I learn how to recover a dropped table using Oracle Flashback?
This course covers Oracle’s Flashback technologies in depth, including how to recover dropped tables using Flashback Drop. You’ll also learn how to use Flashback Table to restore data to a specific point in time, helping to reverse user errors without requiring full database restores.
Does this course cover encrypted backups with Oracle RMAN?
Yes, the course includes detailed guidance on creating encrypted RMAN backups. Explore different encryption modes, including transparent, password-based encryption, and learn how to secure sensitive data during backup and recovery operations.
How does this course prepare me for the Oracle Database Administration II: 1Z0-083 certification?
When combined with our Oracle Database 19c Install & Upgrade, Oracle Multitenant Administration and Oracle Database 19c Performance Tuning & Management, this course aligns closely with topics covered in the certification. It supports preparation, but you will also need to complete additional self-study and ensure you meet all other certification requirements before booking your exam.
NOTE: The exam is not included as part of this course.
What our customers say
“This is now my second course with John at StayAhead and once again the delivery was simply excellent. Best fun I've had at work for a while now and I would very highly recommend the course. Hoping to come back for more in the future!”
Ashley, AppOps Engineer (Jr DBA) - Government
“Very well laid out and John does an amazing job of explaining things in detail.”
Ali, Operations Technical Service Analyst - Utilities
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