Oracle Database 12c: Backup and Recovery

Course details

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.

Learning objectives
Complete vs. incomplete recovery
Point-in-time recovery
Failure categories
Preparing the virtual machine
Performing user-managed backups
Restoring from manual backups
Performing full and incremental backups with RMAN
Recovering a PDB and CDB
Exporting and importing data with Oracle Data Pump
Performing logical backups with Data Pump
Using Flashback Query, Table, and Database
Creating restore points

Concepts

0. Introduction

01 - Welcome
02 - What you need to know
03 - Exercise files

1. Backup and Recovery Core Concepts

04 - Complete vs. incomplete recovery
05 - Role of archived redo logs in backups
06 - Point-in-time recovery
07 - Requirements for PITR

2. Failure Categories and Backup Types

08 - Database failure scenarios
09 - Logical and Physical backups
10 - Oracle Backup technologies

3. Preparing the Course VM

11 - Download the course VM
12 - Enable Archivelog Mode
13 - Configure the Fast Recovery Area

4. User-Managed Backups

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

5. Recovery Manager (RMAN)

18 - RMAN concepts
19 - Configuring RMAN parameters
20 - Full backups using RMAN
21 - Incremental backup using RMAN
22 - Viewing and reporting on RMAN backups
23 - Managing obsolete RMAN backups
24 - Managing expired RMAN backups
25 - Using RMAN to delete backups
26 - Using RMAN for backups of archived redo log
27 - Using RMAN for deleting archived redo logs
28 - Using RMAN to check for data corruptions
29 - Using RMAN scripts
30 - RMAN recovery concepts
31 - Recovering a PDB
32 - Performing point-in-time recovery of a PDB
33 - Recovering the entire CDB
34 - Performing point-in-time recovery of the CDB

6. Oracle Data Pump

35 - Exporting data using Data Pump
36 - Specifying export directory
37 - Exporting a PDB in Oracle 12c
38 - Viewing Data Pump log files
39 - Importing data using Data Pump
40 - Object filtering during import and export
41 - Advanced object filtering
42 - Using parameter files
43 - Monitoring and controlling Data Pump jobs

7. Oracle Flashback

44 - Flashback Query requirements
45 - Flashback Database requirements
46 - Using Flashback Query
47 - Using Flashback Table
48 - Using Flashback Database
49 - Creating Restore Points

Conclusion

50 - What's next