In this course, students learn how to perform backup and recovery based on the related Oracle Database architecture components. Various backup, failure, restore, and recovery scenarios are included so that students learn to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures. This course includes an interactive workshop, with scenarios that provide participants with opportunities to diagnose and recover from several database related failure situations.
The student begins by gaining a deeper understanding of possibly the most important job of a DBA – backup and recovery. The concepts and architecture that support backup and recovery, along with implementation in various ways and situations are covered in detail. Students gain knowledge of the Recovery Manager (RMAN) command-line interface for various backup, failure, restore, and recovery scenarios, including data duplication.
Extensive hands-on practices and workshop scenarios provide the student with experience in a realistic technical environment. This course includes an interactive workshop that provide participants with opportunities to diagnose and recover from several failure scenarios, based on backup and recovery case studies.
After completing this course, students should be able to evaluate their own recovery requirements and develop an appropriate strategy for backup and recovery procedures.
1. Introduction
2. Improving Your Backups
3. Performing Complete Recovery
4. Using Flashback Technologies
5. Duplicating a Database
6. Getting Started
7. Using the RMAN Recovery Catalog
8. Using RMAN-Encrypted Backups
9. Performing Point-in-Time Recovery
11. Using Flashback Database
12. RMAN Troubleshooting and Tuning
13. Configuring for Recoverablility
14. Backup Strategies and Terminology
15. Performing Backups
16. Diagnosing Failures
17. Restore and Recovery Concepts
18. Additional Recovery Operations
19. Transporting Data
20. Performing Point-in-Time Recovery
21. Backup and Recovery Workshop