Course Introduction

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

Session 1: BACKUP 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
• Data Recovery Strategy
• Backup Strategy
• Validate the Recovery Strategy

Session 2: ORACLE RECOVERY STRUCTURES AND PROCESSES

• Architectural Components of Backup and Restore
• Redo logs, Checkpoints and Archives
• Multiplexing Control files and Redo Logs
• Types of Failure in an Oracle Database
• Flash Recovery Area

Session 3: USING ARCHIVELOG AND NOARCHIVELOG MODES

• The Archive Modes of a Database
• Configure a Database in Archivelog Mode
• Configure a Database in Noarchivelog Mode
• Configure Multiple Redo Log Archive Processes
• Configure Multiple Archival Destinations

Session 4: 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
• Oracle Total Recall

Session 5: RECOVERY MANAGER OVERVIEW

• RMAN Features and Components
• Connect to RMAN
• Start Up and Shut Down a Target Database Using RMAN

Session 6: CREATE AND CONFIGURE A RECOVERY CATALOG

• Create a Recovery Catalog
• Register a Database
• Unregister a Database
• Control File Information
• RESYNC CATALOG Command
• Virtual Private Catalogs
• Merge Catalogs
• Backup a Recovery Catalog
• Use a Flashback Recovery Area
• Configure Persistent RMAN Settings
• Set Retention Policies
• Configure Control File Autobackups

Session 7: BACKUP WITH RMAN

• Channel Allocation
• Types of RMAN Backup
• Backup Commands
• Backup Sets Parallelization
• Compressed Backups
• Performing Backups
• Full Closed and Open Backups
• Incremental and Cumulative Backups
• The Copy Command
• Block Change Tracking
• Backup Validate
• Troubleshooting

Session 8: MAINTAIN A RECOVERY CATALOG

• Reset Command
• 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

Session 9: RESTORE AND RECOVER WITH RMAN

• Perform Recovery in Noarchivelog Mode
• Perform Complete Recovery in Archivelog Mode
• Perform Incomplete Recovery
• 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
• Restore the Server Parameter File
• Restore the Control File from Auto-Backup
• Restore and Recover the Database on a New Host

Session 10: 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
• Create a Duplicate Database with Enterprise Manager
• Clone a Running Database
• Use EM to Clone a Running Database
• Targetless Duplication of a Database

Session 11: MONITOR, TUNE AND TROUBLESHOOT BACKUP AND RECOVERY

• Tune recovery Manager Overview
• Tune RMAN Backup Performance
• Instance Recovery Performance Tuning
• Understand RMAN Output Messages
• Troubleshoot RMAN

Appendix: OVERVIEW OF ORACLE SECURE BACKUP

• Oracle Secure Backup Overview
• Oracle Secure Backup Product Family
• Encrypted Backups
• Oracle Secure Backup Interfaces
• Oracle Secure Backup Web Tool
• Oracle Secure Backup Command Line Tool
• Oracle Enterprise Manager and Grid Control
• Recovery Manager Command Line Interface
• Media Management Expiration Policies
• Domain Security
• Overview of Backup to Amazon Simple Storage Service using OSB Cloud Computing