Oracle Database 12c Backup & Recovery with RMAN

Course ContentsCourse Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

• Plan and Implement a Backup and Recovery Strategy
• Define a Disaster Recovery Plan
• Test a Backup and Recovery Plan
• Advantages and Disadvantages of Different Backup Methods
• Data Recovery Strategy
• Backup Strategy
• Validate the Recovery Strategy
• Tools for Backup and Recovery
• The Privileges Required to Perform Backups

• Architectural Components of Backup and Restore
• Control Files
• Redo Log Files
• Archive Log Files
• Using the Flash Recovery Area (FRA)

• Configure and Use Flashback Database
• Monitor Flashback Database
• Flash Recovery Area Space Usage
• Flashback Query
• Retrieve Row History with Flashback Versions Query
• Audit or Recover From Transactions with Flashback Transactions Query
• Flashback Table
• Recover Dropped Tables with Flashback Drop
• The Recycle Bin
• Recover Tables to a Point In Time With Flashback Table
• Flashback Database
• Flashback Restore Points
• Flashback Transaction Backout
• Flashback Data Archive

• RMAN Features and Components
• RMAN Commands
• Connect to RMAN
• Start Up and Shut Down a Target Database Using RMAN
• Issue SQL Commands in RMAN

• Create a Recovery Catalog
• Register a Database
• Unregister a Database
• Control File Information
• Virtual Private Catalogs
• Backup a Recovery Catalog
• Use a Flashback Recovery Area with RMAN
• Configure Persistent RMAN Settings
• Set Retention Policies
• Configure Control File Autobackups
• Integrate RMAN with a Media Manager

• Types of RMAN Backup
• Backup Commands
• Performing Backups
• Closed and Open Backups
• Incremental Backups
• Fast Incremental Backups using Block Change Tracking
• Oracle Suggested Backup
• Validate Backups
• Troubleshooting Backups
• Listing Backups

• Create Multisection Backups
• Create Duplexed Backup Sets
• Create Compressed Backups
• Backup the Control File to a Trace File
• Backup Recovery Files
• Backup up ASM Metadata

• Change the Availability Status of Backups and Copies
• Catalog Backups Made with Operating System Commands
• Generate Backup Reports and Lists
• Cross Check Backups and Copies
• Delete Backups
• Update the Repository after Backup Deletion
• Drop Database and Archival Backups
• Use Data Dictionary Tables

• Create an Encrypted RMAN Backup
• Use Different Encryption Modes

• The Automatic Diagnostic Repository
• The Data Recovery Advisor
• Understanding RMAN Messages and the Error Stack
• Diagnose Data File Loss
• Recovery with RESETLOGS
• Dealing with Block Corruption

• Restore and Recover
• Instance Failure and Crash Recovery
• Media Failure
• An Overview of Complete Recovery
• An Overview of Point in Time Recovery
• Recovery with RESETLOGS

• Perform Recovery in Noarchivelog Mode
• Perform Complete Recovery in Archivelog Mode
• Perform Incomplete Recovery (PITR)
• Use the Flash Recovery Area for Fast Recovery
• Restore and Recover a tablespace
• Automatic Tempfile Recovery
• Restore and Recover Datafiles
• Recover a Datafile Not Backed Up
• Table Recovery from Backups

• Restore the Server Parameter File
• Restore the Control File
• Re-create the Password File
• Handling Redo Log File Loss
• Restore and Recover the Database on a New Host
• Restore RMAN Encrypted Backups
• Disaster recovery

• Tablespace-Point-in-Time Overview
• Tablespace-Point-in-Time Example

• Transport Tablespaces
• Transport Databases

• Database Duplication
• Duplication Options
• Create Files for the Duplicate Database
• Prepare the Auxiliary Instance for Duplication
• Create a Duplicate Database
• Create a Duplicate Database with Enterprise Manager
• Clone a Running Database
• An Overview of Using Cloud Control to Clone a Running Database
• Targetless Duplication of a Database

• Tune Recovery Manager Overview
• Restore and Recovery Performance Best Practices
• Multiplexing in RMAN
• Diagnosing Performance Bottlenecks

• Oracle Secure Backup Overview
• Oracle Secure Backup Interfaces
• Oracle Secure Backup Jobs with RMAN
• Backup the Fast Recovery Area to Tape
• RMAN Backup to Tape
• Overview of Integration with Cloud Control

• Schedule Backups with Enterprise Manager
• Oracle Suggested Backup Strategy
• Perform Backups to Tape
• Manage Tape Backups
• Perform Recovery from Tape
• RMAN Automatic Failover to Previous Backup