Oracle Backup & Recovery Training
Backups are the one part of the DBA job you cannot get wrong. In 8 live sessions you'll master RMAN end to end — take production-grade backups, then break the database and bring it back, again and again, until recovery is muscle memory. On Oracle 26ai and 19c, taught by a production DBA.
- Weekend or weekday batches · morning or evening slots · check upcoming schedule →
- Hands-on labs on a real database — RMAN Architecture, Full & Incremental Backups, Complete & Point-in-Time Recovery, Data Pump, Flashback & Real Failure Drills
- Certificate + lifetime recordings in your student portal
What this course is about
Ask any hiring manager what separates a junior DBA from a senior one and the answer is always the same: recovery. Anyone can run a backup script — the DBA who gets hired, promoted and trusted is the one who can restore a database under pressure. This course makes RMAN second nature: its architecture, full and incremental backups, retention policies, the Fast Recovery Area, and every recovery scenario you'll actually face — from a lost datafile to a full point-in-time recovery after someone truncates the wrong table.
This is a live, instructor-led course built around breaking and fixing a real database. Across 8 sessions (16 hours) you'll configure RMAN properly, design a production backup strategy, perform complete recovery with zero data loss, rescue data with Flashback, move and clone databases with Data Pump (expdp/impdp) and RMAN DUPLICATE, and handle CDB/PDB and RAC backup nuances — on Oracle 26ai and 19c. Every session is taught live by our senior Oracle DBA instructors, who have restored real production databases for over a decade.
What you'll be able to do
- Explain RMAN architecture — target database, channels, catalog and autobackups
- Configure retention policies, parallelism and the Fast Recovery Area (FRA)
- Design and run a production backup strategy with full, incremental and compressed backups
- Speed up incrementals with Block Change Tracking
- Perform complete recovery of datafiles, tablespaces and control files with zero data loss
- Carry out point-in-time recovery at database, tablespace and table level
- Rescue dropped or corrupted data with Flashback Query, Drop and Database
- Move data with Data Pump (expdp/impdp) and clone databases with RMAN DUPLICATE
- Back up and recover CDB/PDB multitenant and RAC databases
- Diagnose block corruption and fix it with block media recovery
Course syllabus — 8 sessions · 16 hours
1RMAN Architecture & Configuration1 session · 2 hrs
- Why backup & recovery is the DBA's first responsibility — RPO and RTO
- RMAN architecture: target database, channels and the snapshot control file
- Recovery catalog vs control-file-only — when to use each
- CONFIGURE settings: retention policy, device type, parallelism
- Control file and spfile autobackup
- Archivelog mode — why every production database runs in it
2Backup Types & Strategy1 session · 2 hrs
- Full vs incremental level 0/1 — what actually gets copied
- Backup sets vs image copies
- Backing up datafiles, archivelogs, control file and spfile
- Hot (online) vs cold (offline) backups
- Designing a production backup schedule that meets your RPO
- Validating backups: BACKUP VALIDATE and RESTORE ... PREVIEW
3Incremental, Compressed & FRA1 session · 2 hrs
- Differential vs cumulative incremental backups
- Block Change Tracking for fast incrementals
- Incrementally updated image copies — the roll-forward strategy
- Backup compression options and their trade-offs
- Fast Recovery Area — sizing, monitoring and housekeeping
- Deleting obsolete backups and managing archivelogs
4Complete Recovery Scenarios1 session · 2 hrs
- Instance recovery vs media recovery — what happens at startup
- Losing a datafile — restore and recover with zero data loss
- Recovering SYSTEM vs non-system tablespaces
- Loss of all control files — restoring from autobackup
- Recovering after redo log loss
- Disaster restore of the whole database to a new host
5Point-in-Time Recovery & Flashback1 session · 2 hrs
- When complete recovery isn't the goal — bad DML and logical corruption
- Database point-in-time recovery (DBPITR) with UNTIL TIME / SCN
- Tablespace point-in-time recovery (TSPITR)
- Table-level recovery from backup (RECOVER TABLE)
- Flashback Query, Flashback Drop and the recycle bin
- Flashback Database and guaranteed restore points
6Data Pump (expdp/impdp) & Cloning1 session · 2 hrs
- Data Pump architecture — directories, jobs and the master table
- expdp/impdp in full, schema, table and tablespace modes
- Filtering, remapping, PARALLEL and NETWORK_LINK
- Monitoring, attaching to and restarting Data Pump jobs
- Cloning a database with RMAN DUPLICATE — active and backup-based
- Refreshing test environments from production the safe way
7CDB/PDB & RAC Backup Nuances1 session · 2 hrs
- Multitenant refresher — CDB, PDBs and where the files live
- Backing up a whole CDB vs an individual PDB
- Restoring and recovering a single PDB — including PDB point-in-time recovery
- RAC backup: channels, instances and the shared FRA
- Archivelog handling and recovery in RAC
- What changes (and what doesn't) when you move from 19c to 26ai
8Real-World Failure Drills + Interview Prep1 session · 2 hrs
- Live drill: critical table dropped in production — choose the fastest recovery path
- Live drill: datafile corruption during business hours
- Live drill: full restore after losing the server
- Block corruption — detection with RMAN and block media recovery
- Building your own backup & recovery runbook
- Interview Q&A — the recovery scenarios interviewers always ask
Who it's for
This course is for DBAs who want to own backup and recovery with confidence — junior DBAs who run backups but have never done a real restore, mid-level DBAs preparing for senior roles and interviews, and developers or support engineers moving into database administration. You should be comfortable with basic Oracle administration — starting and stopping an instance, tablespaces and users. No prior RMAN experience is required; we start from architecture and configuration and build up to full failure drills. If a production restore still makes you nervous, this course was built for you.
Program benefits
- Live instructor-ledLive sessions taught by our senior Oracle DBA instructors, not recordings
- Session recordingsEvery session saved to your student portal
- Module assignmentsHands-on tasks after each module to lock in skills
- Session documentationDetailed notes provided for every session
- WhatsApp supportFast doubt-clearing help between sessions
- Software & patchesEverything you need for hands-on practice
- Interview prepCurated Q&A to get you interview-ready
- Completion certificateAwarded when you finish the course
Frequently asked questions
Do I need prior RMAN experience?
Will we practise real recovery scenarios?
Are the live sessions recorded?
When do batches run, and how do I pay?
Be the DBA who brings it back
Join the next live Backup & Recovery batch and master RMAN the production way — real backups, real failures, real recoveries — with lifetime recordings and real mentorship.