This four-day immersive course builds essential skills in Oracle Database backup and recovery using RMAN and Flashback. Designed for DBAs and support staff, it equips you with real-world techniques to protect, recover and duplicate Oracle databases across versions 12cR2, 18c and 19c.
Oracle Database 12cR2 Backup and Recovery with RMAN
Gain confident Oracle database recovery skills
Over four active days, this instructor-led course helps you confidently manage Oracle backup, restore and disaster recovery tasks. You’ll work with RMAN, Flashback, recovery catalogues and encryption, all in live labs. This course will support you to sharpen your DBA skills and reduce risk across Oracle 12cR2, 18c and 19c systems.
Learning objectives
- Plan a backup and disaster recovery strategy
- Use RMAN for backups and recovery
- Create and manage a recovery catalogue
- Perform encrypted backups
- Configure Flashback features
- Monitor and tune RMAN
- Restore tablespaces and datafiles
- Create duplicate databases
- Handle failures with Data Recovery Advisor
What you’ll learn
Boost your practical knowledge for keeping Oracle databases safe and recoverable. From core RMAN commands to advanced restore techniques, this course gives you experience in managing catalogue databases, flashback options and duplication processes. Everything you need to be an indispensable DBA when it comes to backup and recovery.
RMAN essentials
This course gives you a solid foundation in using Recovery Manager (RMAN), Oracle’s core tool for backup and recovery. You’ll learn how to perform full and incremental backups, manage image copies, and use retention policies to keep your system clean and efficient. Whether you’re backing up to disk or tape, RMAN reduces complexities. You’ll also gain useful experience with configuring control file auto backups, allocating channels, and integrating with media management systems, all key tasks for any Oracle DBA handling backup and recovery duties.
Flashback technology
On this course, you’ll learn how to rewind your database to a previous state without restoring from backup. You’ll explore Flashback Table, Flashback Database, and Flashback Query, all designed to recover from accidental deletes or updates. You'll also understand how to use restore points and monitor flashback logs for space management. This practical knowledge is important for Oracle DBAs who want to reduce downtime and recover quickly from user errors.
Advanced recovery scenarios
Beyond the basics, this course takes you through complex recovery situations, from restoring lost control files to rebuilding your database on a new host. You’ll practise disaster recovery steps, including encrypted backup restores, point-in-time recovery, and duplicating a database for testing or reporting. You’ll also use tools like the Data Recovery Advisor to diagnose and respond to issues.
What’s included
- Four days of live virtual classroom training
- Real-time practice with hands-on live labs
- Led by experienced Oracle-certified instructors
- Comprehensive course materials for ongoing reference
- Certificate of completion
- Access to flexible dates and private group bookings
- Practical, job-ready skills aligned to Oracle 12cR2, 18c and 19c
Key facts
Ideal for
DBAs, technical support staff and data warehouse administrators responsible for Oracle database backup and recovery in 12cR2, 18c or 19c environments.
Prerequisites
A working knowledge of Oracle SQL and database administration is essential. Familiarity with UNIX or Linux systems is helpful but not obligatory.
Learning experience
Our experienced trainers and interactive labs create a focused, practical environment – so you can put theory into practice from day one. (Do not change this copy)
FAQs
If you're an Oracle DBA, this focused course is a great way to expand your understanding of RMAN, Flashback and disaster recovery. You'll build the skills to confidently back up, restore and duplicate databases across 12cR2, 18c and 19c.
Will this course help me handle real recovery issues at work?
Yes, it’s all about real situations you’re likely to face. You’ll learn how to back up and restore with RMAN, fix problems like lost files or corrupted blocks, and recover from system failures. You’ll also try out disaster recovery steps in the labs, so you’re not just learning theory, you’re acquiring your new skills as you learn.
Do we get to use encryption for backups?
Definitely. You’ll use both transparent and password-based encryption to secure your backups; a must if you're dealing with sensitive or regulated data. The course has many practical elements, so you’ll practise setting it up and restoring encrypted backups too.
What’s covered with Flashback?
Flashback features enable the ability to fix mistakes without needing a full restore. You’ll learn how to roll back tables, undo dodgy transactions, recover dropped tables and even rewind the whole database to a previous point in time. Plus, you’ll get to reinforce your new skills in live labs.
Can I practise duplicating a database?
Yes. We’ll guide you through using RMAN to create duplicate databases, effective for test environments or cloning production for reporting. You’ll even look at how to do this without needing a connection to the original system.
What our customers say
‘Very well laid out and John does an amazing job of explaining things in detail.’
John, Operations Technical Service Analyst – Utilities
‘This is now my second course with John at StayAhead and once again the delivery was simply excellent. I was a little bit worried coming in that I wouldn't have the requisite knowledge, however, I found that it was just about the perfect level between being able to understand the concepts and stretching the grey matter.’
Ashley, AppOps Engineer (Jr DBA) - 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