Oracle Database 12c: Backup and Recovery
The Oracle Database 12c: Backup and Recovery course is a practical, hands-on program designed to equip participants with the skills required to protect Oracle databases against data loss and recover them efficiently in the event of failures. Oracle Database is developed by Oracle Corporation, and Oracle Database 12c introduces features that enhance reliability, availability, and recoverability, including Multitenant architecture considerations (CDB/PDB) and advanced recovery options. This course focuses on backup strategies, recovery planning, and disaster scenarios using Oracle-recommended tools and best practices—primarily Recovery Manager (RMAN)—to ensure data integrity and business continuity in enterprise environments. Course Objectives By the end of this course, participants will be able to: Understand Oracle Database 12c backup and recovery architecture Design effective backup strategies aligned with business requirements Perform backups using RMAN Restore and recover databases from various failure scenarios Manage backup storage and retention policies Protect multitenant (CDB/PDB) environments Validate backups and recovery readiness
Course Curriculum
1
- Importance of backup and recovery
- Types of failures and recovery scenarios
- Oracle Database 12c recoverability concepts
- DBA responsibilities for data protection
2
- Physical and logical database structures
- Control files, datafiles, and redo logs
- Archived redo logs
- Role of checkpoints
3
- Backup types (full, incremental, cumulative)
- Online vs offline backups
- Consistent and inconsistent backups
- Recovery objectives (RPO and RTO)
4
- RMAN architecture and components
- Connecting to target and recovery catalog
- RMAN repository and metadata
- RMAN vs user-managed backups
5
- Database backups
- Tablespace and datafile backups
- Incremental backups
- Backup compression and encryption
6
- Backup retention policies
- Crosschecking and deleting obsolete backups
- Backup validation
- Backup reporting
7
- Restoring datafiles and control files
- Complete database recovery
- Incomplete recovery
- Recovering from loss of redo logs
8
- Time-based recovery
- SCN-based recovery
- Tablespace point-in-time recovery (TSPITR)
- Common use cases
9
- Backup strategies for CDBs and PDBs
- Restoring and recovering PDBs
- PDB point-in-time recovery (PDB PITR)
- Multitenant considerations
10
- Flashback Database
- Flashback Table
- Flashback Drop
- Use cases and limitations
11
- Backup role in disaster recovery planning
- Overview of standby databases
- Offsite backup strategies
- Media management considerations
12
- Backup encryption
- Secure storage of backup media
- Privilege management for RMAN
- Compliance considerations
13
- Monitoring backup jobs
- Analyzing RMAN logs
- Common backup and recovery errors
- Troubleshooting recovery failures
14
- Designing efficient backup strategies
- Balancing performance and protection
- Testing recovery procedures
- Documentation and audit readiness
15
- Creating RMAN backup scripts
- Performing restore and recovery scenarios
- Simulating failures and recovery
- Validation and readiness testing
16
- Instructor-led classroom or virtual training
- Hands-on lab sessions
- Guided recovery simulations
17
- Oracle Database Administrators (DBAs)
- System and infrastructure administrators
- Database engineers and support professionals
- IT professionals responsible for data protection
18
- Basic knowledge of Oracle Database architecture
- Familiarity with SQL and Oracle administration
- Prior Oracle Database administration experience is beneficial
19
- Hands-on RMAN exercises
- Practical recovery scenarios
- Knowledge checks and quizzes
This course includes
- 19+ Activity Modules
- 40 hours + lessons
- Lifetime access
- Certificate of completion
- Available on desktop and mobile
Some of Our Partners
