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.

Keeping the information in an Oracle database safe from failure is one of the most important tasks of a successful Oracle DBA. In this course, Oracle instructor and consultant David Yahalom covers the theoretical concepts as well as the practical knowledge required to design and implement bulletproof Oracle backup and recovery strategies. Learn how human errors, hardware failures, and even storage loss can affect your database, and how you can leverage the technologies and features built into Oracle 12c to ensure you will never suffer any data loss. Discover how to use various Oracle tools and technologies, including RMAN, Data Pump, Flashback, and hot and cold backups, to protect your database from the inevitable crash.

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?