Oracle Database 12c: Backup and Recovery

Learn how to design and implement backup and recovery strategies that keep the data stored in your Oracle 12c databases safe and secure.

Introduction

• Welcome
• What you need to know
• Exercise files

1. Backup and Recovery Core Concepts

• Complete vs. incomplete recovery
• Role of archived redo logs in backups
• Point-in-time recovery
• Requirements for PITR

2. Failure Categories and Backup Types

• Database failure scenarios
• Logical and Physical backups
• Oracle Backup technologies

3. Preparing the Course VM

• Download the course VM
• Enable Archivelog Mode
• Configure the Fast Recovery Area

4. User-Managed Backups

• User-managed backups overview
• Performing user-managed backups of datafiles
• Manual backup of control files and archived logs
• Steps to restore from manual backups

5. Recovery Manager (RMAN)

• RMAN concepts
• Configuring RMAN parameters
• Full backups using RMAN
• Incremental backup using RMAN
• Viewing and reporting on RMAN backups
• Managing obsolete RMAN backups
• Managing expired RMAN backups
• Using RMAN to delete backups
• Using RMAN for backups of archived redo log
• Using RMAN for deleting archived redo logs
• Using RMAN to check for data corruptions
• Using RMAN scripts
• RMAN recovery concepts
• Recovering a PDB
• Performing point-in-time recovery of a PDB
• Recovering the entire CDB
• Performing point-in-time recovery of the CDB

6. Oracle Data Pump

• Exporting data using Data Pump
• Specifying export directory
• Exporting a PDB in Oracle 12c
• Viewing Data Pump log files
• Importing data using Data Pump
• Object filtering during import and export
• Advanced object filtering
• Using parameter files
• Monitoring and controlling Data Pump jobs

7. Oracle Flashback

• Flashback Query requirements
• Flashback Database requirements
• Using Flashback Query
• Using Flashback Table
• Using Flashback Database
• Creating Restore Points

Conclusion

• What's next?