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)
