Oracle Database 19c: Backup and Recovery

Descripción

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 provided 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 failure situations.

Objetivos

Upon completion of this course, the student should be able to:

• Describe the Oracle Database architecture components related to backup and recovery operations.
• Plan effective backup and recovery procedures.
• Describe Oracle Database backup methods and recovery operations that can be used to resolve database failure.
• Configure the database for recoverability.
• Use Recovery Manager (RMAN) to create backups and perform recovery operations.
• Use the Data Recovery Advisor to diagnose and repair failures.
• Use Oracle Flashback Technologies to recover from human error.
• Perform an encrypted database backup and restore.
• Perform tablespace point-in-time recovery.

Contenidos del curso

1. Backup and Recovery: Overview
2. Backup and Recovery Configuration
3. Using Recovery Manager (RMAN)
4. Backup Strategies
5. Creating Database Backups
6. Using Optional Backup Features
7. Tuning RMAN Backup Performance
8. Recovery Catalog Overview
9. Creating a Recovery Catalog
10. Managing Target Database Records
11. Using Stored Scripts
12. Creating and Using Virtual Private Catalogs
13. Restore and Recovery Concepts
14. Diagnosing Failures
15. Performing Complete Recovery
16. Performing Point-in-Time Recovery
17. Performing Block Media Recovery
18. Performing Additional Recovery Operations
19. Oracle Flashback Technology: Overview
20. Using Logical Flashback Features
21. Using Flashback Database
22. Using PDB Snapshots
23. Database Duplication Overview
24. Creating a Backup-Based Duplicate Database