In this Oracle Database 12c R2: Backup and Recovery Workshop, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are provided so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.
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)
What to learn next?
