Oracle Database 19c Backup and Recovery with RMAN - 4 days Online Classroom
3.450,00 EUR
- 4 days
Protect your critical Oracle databases with confidence through the Oracle Database 19c Backup and Recovery with RMAN course. Designed for Oracle database administrators, this hands-on training teaches you how to create reliable backup strategies, recover from database failures, and minimise downtime using Oracle Recovery Manager (RMAN). You'll gain practical experience with backup automation, Flashback technologies, recovery catalogues, database duplication, and disaster recovery scenarios. By the end of the course, you'll be equipped to safeguard business-critical data, restore databases efficiently, and maintain high availability in enterprise Oracle environments.
Key Features
Language
Course and materials are in English
Level
Intermediate level
4 days (8 hours / day) live classroom
with accredited trainers
50+ recommended study hours
Exercises and solutions
Downloadable PDF documents with detailed content (slides, explanations)
Certificate
Certificate of completion available
Learning Outcomes
At the end of this course, you will be able to:
Recover
Learn how to recover Oracle databases from a wide range of failure scenarios using RMAN.
Perform
Perform full, partial, and point-in-time recoveries, restore lost datafiles and tablespaces, recover databases in Noarchivelog mode, and use Oracle Flashback features to quickly reverse user errors without a full database restore.
Create
Master Oracle database cloning with RMAN for development, testing, and disaster recovery. You'll create duplicate databases from backups or live systems, configure auxiliary instances, manage database files, and simplify duplication using Oracle Enterprise Manager.
Analyze
Develop the skills to monitor, optimize, and troubleshoot RMAN backup and recovery operations. Learn to analyze logs, identify performance bottlenecks, improve backup efficiency with tuning techniques such as multiplexing, and apply best practices to ensure reliable recovery processes.
Course timeline
Day 1: Backup, Recovery and RMAN Fundamentals
Lesson 01
- Plan backup, recovery, and disaster recovery strategies for Oracle databases.
- Explore Oracle database architecture, recovery components, redo logs, and the Flash Recovery Area (FRA).
- Configure and use Flashback technologies for fast data and database recovery.
- Recover tables, transactions, and deleted objects using Flashback features.
- Understand RMAN architecture, components, commands, and administration.
- Connect to RMAN, execute SQL commands, and manage database startup and shutdown.
Day 2: RMAN Backup Administration
Lesson 02
- Create and manage RMAN Recovery Catalogs and configure backup settings.
- Perform full, incremental, and image copy backups with RMAN.
- Implement advanced backup techniques, including multisection, compressed, and duplexed backups.
- Maintain backup repositories through validation, reporting, crosschecks, and cleanup.
- Configure encrypted RMAN backups using transparent and password-based encryption.
- Apply retention policies and automate backup management for enterprise environments.
Day 3: Database Restore and Recovery
Lesson 03
- Diagnose database failures using Oracle diagnostic tools and RMAN error analysis.
- Understand complete, incomplete, and point-in-time recovery strategies.
- Restore databases, tablespaces, and datafiles using RMAN.
- Recover databases in both ARCHIVELOG and NOARCHIVELOG modes.
- Restore critical components including control files, SPFILEs, and encrypted backups.
- Perform disaster recovery and database restoration on new servers.
Day 4: Advanced Recovery and Database Duplication
Lesson 04
- Perform Tablespace Point-in-Time Recovery (TSPITR) for targeted data restoration.
- Transport tablespaces and databases between Oracle environments.
- Clone and duplicate Oracle databases using RMAN for testing and disaster recovery.
- Configure auxiliary instances and perform target-based or targetless duplication.
- Monitor, tune, and troubleshoot RMAN backup and recovery performance.
- Optimise backup efficiency using Oracle best practices and performance tuning techniques.
Who Should Enroll in this Program?
Oracle Database Administrators (DBAs)
Database Support Engineers
Oracle Infrastructure and Operations Engineers
Database Consultants and Technical Specialists
System Administrators responsible for Oracle database maintenance
IT professionals preparing for Oracle Database Administration II certification
Prerequisites
- A working knowledge of Oracle Database administration
- Experience using Oracle SQL
- Familiarity with Oracle Database 19c administration tasks
- Basic understanding of database architecture and storage concepts
- Experience managing Oracle databases in production or equivalent hands-on experience
Licensing
and equality policy
Licensing and accreditation
This course is offered according to Partner Program Agreement and complies with the License Agreement requirements.
Equity Policy
AVCdoes not provide accommodations due to a disability or medical condition of any students. Candidates are encouraged to reach out to AVC for guidance and support throughout the accommodation process.
Frequently Asked Questions
Need a Custom In-company or Group Training?
Request for in-company training program tailored specifically to your team. We offer flexible customization options to align with your business goals, alongside competitive group rates for larger teams. Fill out the form below, and our corporate training experts will design the perfect solution for you.