Oracle Database 11g Release 2 DBA Backup & Recovery with RMAN

Follow-on Courses

• Oracle Database 11g Release 2 Data Guard
• Oracle Database 11g Release 2 DBA Performance & Tuning

Back-Up and Recovery Considerations

• 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
• Backup Methods Comparison
• Data Recovery Strategy
• Backup Strategy
• Validate the Recovery Strategy

Oracle Recovery Structures and Processes

• Architectural Components of Backup and Restore
• Physical Database Structures
• Logical Database Structures
• Dynamic Performance Views
• Redo logs, Checkpoints and Archives
• Use the Flash Recovery Area (FRA)
• The Archivelog Modes of a Database

Flashback

• 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

Recovery Manager Overview

• RMAN Features and Components
• The 12c sysbackup Privilege
• RMAN Commands
• Connect to RMAN
• Specify the Location of RMAN Output
• Start Up and Shut Down a Target Database Using RMAN
• Issue SQL Commands in RMAN

Create and Configure a Recovery Catalog

• 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

Back-Up with RMAN

• Channel Allocation
• Types of RMAN Backup
• Recovery Manager Commands
• Performing Backups
• Closed and Open Backups
• Incremental Backups
• Fast Incremental Backups using Block Change Tracking
• Backup File Image Copies
• Oracle Suggested Backup
• Validate Backups
• Listing Backups

Advanced Back-Up Techniques

• 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

Maintain a Recovery Catalog

• Change the Availability Status of Backups and Copies
• Catalog Backups Made with Operating System Commands
• Generate 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

Encrypted RMAN Back-Ups

• Create an Encrypted RMAN Backup
• Transparent Encryption
• Password Encryption
• Password Encryption
• Use Different Encryption Modes

Database Failure Diagnostics

• 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

Overview of Restore and Recovery

• 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

Basic Restore and Recover with RMAN

• Perform Recovery in Noarchivelog Mode
• Perform Complete Recovery in Archivelog Mode
• Use the Flash Recovery Area for Fast Recovery
• Automatic Tempfile Recovery
• Identify the Database Files to Restore and Recover
• Preview Backups used in Restore Operations
• Apply Incremental Backups to Restore Datafile Image Copies
• The Switch Command
• The Data Recovery Advisor
• Perform Incomplete Recovery (PITR)
• Restore and Recover a tablespace
• Restore and Recover Datafiles
• Recover a Datafile Not Backed Up
• The 12c Table Recovery from Backups
• Recover Individual Data Blocks
• The Data Recovery Advisor

Advanced Restore and Recover with RMAN

• 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 Recovery (TSPITR)

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

Transport Data

• Transport Tablespaces
• Transport Databases

Create a Duplicate Database with RMAN

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

Monitor, Tune and Troubleshoot Back-Up and Recovery

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

Overview of RMAN and Oracle Secure Back-Up

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

Overview of Back-Up and Restore to Tape

• 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