Oracle Database 19c: Backup & Recovery Workshop

40 HRS

Suggested Prerequisites: 

Knowledge of Oracle Database 19c 

Knowledge of SQL and PL/SQL (for DBA use) 

Required Prerequisites: 

Oracle Database 19c R2: Install and Upgrade Workshop 

Oracle Database 19c R2: Administration Workshop 

You will learn how to: 

• Use Oracle Flashback Technologies to recover from human error 
• Use Recovery Manager (RMAN) to create backups and perform recovery operations 
• Use the Data Recovery Advisor to diagnose and repair failures 
• Plan effective backup and recovery procedures 

• Describe the Oracle Database architecture components related to backup and recovery operations 
• Perform an encrypted database backup and restore 
• Perform tablespace point-in-time recovery 
• Configure the database for recoverability 
• Describe Cloud Tooling for Backup and Recovery 

• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure 

• Introduction 

• Getting Started 
• Configuring for Recoverability 
• Using the Fast Recovery Area (FRA) 
• Backup Strategies and Terminology 
• Performing Backups 

• Improving Your Backups 
• Using RMAN-Encrypted Backups 
• Diagnosing Failures 
• Restore and Recovery Concepts 
• Performing Recovery, Part I 

• Performing Recovery, Part II 
• RMAN and Oracle Secure Backup 
• Using Flashback Technologies 
• Using Flashback Database 
• Transporting Data 

• Performing Point-in-Time Recovery 
• Duplicating a Database 
• RMAN Troubleshooting and Tuning 
• Cloud Tooling for Backup and Recovery 
• Backup and Recovery Workshop 

This course prepares you for the following certifications: 

• Oracle Certified Profession (OCP) – (Database Admin)