Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Introduction
Overview of Backup and Recovery Concepts
- Understanding the importance of backup and recovery
- Types of failures and their impact on databases
- Oracle Database 19c backup and recovery architecture
Configuring Backup and Recovery Settings
- Configuring the fast recovery area (FRA)
- Setting up backup and recovery policies
- Configuring the RMAN environment
Performing Backups Using RMAN
- Full database backups
- Incremental backups
- Multitenant database (CDB and PDB) backup strategies
- Archiving and managing archived redo logs
Backup Strategies and Best Practices
- Choosing the right backup strategy: full, incremental, differential
- Implementing Oracle-suggested backup strategies
- Best practices for backup retention and validation
Understanding Recovery Operations
- Recovering from user errors
- Media recovery: datafile, tablespace, and block recovery
- Point-in-time recovery (PITR)
Recovering from Database Failures
- Instance recovery and media recovery overview
- Recovering from control file and redo log file loss
- Multitenant environment recovery scenarios (CDB and PDB recovery)
Flashback Technology for Database Recovery
- Overview of Oracle Flashback technology
- Using Flashback Database, Flashback Table, and Flashback Drop
- Configuring and managing Flashback technology
Performing Disaster Recovery
- Planning and implementing disaster recovery strategies
- Data Guard integration with RMAN for disaster recovery
- Best practices for disaster recovery in Oracle Database 19c
Summary and Next Steps
Requirements
- Basic understanding of Oracle database administration
- Familiarity with SQL and PL/SQL
Audience
- Database administrators
- IT professionals
14 Hours
Testimonials (5)
I learned complex functions and how to apply them
Ana Alexandrescu - DB Global Technology
Course - Oracle SQL Advanced
Great comunication, Łukasz explained everything in easy and understandable way
Tomasz Wojciechowski - GP Strategies Poland sp. z o.o.
Course - ORACLE SQL Fundamentals
the trainer was very helpful , the pace of the training was really good and the exercises weren't too hard, also not too easy. whenever I got stuck he helped me out very well and made sure I understood everything.
Jade Stappaerts - KULeuven
Course - Oracle SQL Language
the exercises
Amna AlAli - Federal Demographic Council
Course - Oracle SQL for beginners
Bien preparado, apegado al temario, se revisó temario completo, ejemplos adecuados.