Module 1. Introduction
- Assessing Your Recovery Requirements
- Data Failures Examples
- Failure Categories
- Oracle Data Protection Solutions
- Oracle Backup and Recovery Solutions
- Oracle Maximum Availability Architecture
- Oracle Secure Backup (overview only)
- Oracle Active Data Guard (overview only)
Module 2. Using Recovery Manager (RMAN) and Enterprise Manager
- Oracle Recovery Manager (architecture overview)
- Enterprise Manager (backup and recovery interface overview)
- Using the RMAN Command-Line
- RMAN Commands (overview)
- Configuring RMAN Persistent Settings
- Viewing and Managing RMAN Persistent Settings
Module 3. Configuring for Recoverability
- Fast Recovery Area (overview)
- Fast Recovery Area Sizing and Configuration Control File Multiplexing & Autobackup Redo Log Files and the LGWR Process Redo Log File Multiplexing
- RCHIVELOG Mode and the Archiver Process Archived Redo Log Files
- Undo Retention
Module 4. Using the RMAN Recovery Catalog
- Repository Comparison
- Recovery Catalog Overview
- Creating the Recovery Catalog
- Managing Records in the Catalog
- Registering the Database
- Catalog Resynchronization
- Backing Up the Recovery Catalog
Module 5. Backup Concepts and Strategies
- Backup Solutions Overview Backup Terminology RMAN Backup Types
- Understanding RMAN Backup Data Flow Balancing Backup and Restore Requirements Comparing Backup Strategies
- Best Practices for Data Warehouse Backups
Module 6. Creating Backups
- Oracle Suggested Backup Strategy Backups Sets & Image Copies (RMAN) Whole Database Backups
- Read-Only Tablespace Backups Checking for Block Corruption
- Block Change Tracking/Fast Incremental Backups Backup Compression & RMAN Encrypted Backups Control File Backups & Cataloging Backups Files
Module 7. Restore and Recovery Concepts
- Employing the Best Oracle Technology for Recovery Instance Failure and Instance/Crash Recovery Media Failure
- Complete Recovery (Overview) Point-in-Time Recovery (Overview) Recovery Through RESETLOGS Recovery to an Abandoned Incarnation
Module 8. Using Data Recovery Advisor
- Data Recovery Advisor Overview
- Using the Data Recovery Advisor (overview)
- Using the Data Recovery Advisor in Enterprise Manager
- Using the Data Recovery Advisor RMAN Command-Line Interface
Module 9. Performing Recovery
- Data File Loss (file system and ASM)
- RMAN Recovery: NOARCHIVELOG Mode, Complete, Image Files & Point-in-Time (Incomplete recovery) Control File Loss and Recovery & RMAN Recovery: Backup Control File
- Redo Log File Loss and Recovery, Index Tablespace Recovery & Read-Only Tablespace Recovery Password Authentication File Re-creation, Server Parameter File Recovery & Tempfile Recovery Restoring RMAN Encrypted Backups
- Block Media Recovery
- Restore and Recovery Performance Best Practices
Module 10. Using Flashback Technologies
- Flashback Technologies Overview
- Preparing to use Flashback Technologies
- Flashback Query & Flashback Version Query
- Flashback Table
- Flshback Transaction Query
- Flashback Transaction
- Flashback Drop
- Best Practices for Undo-Based Flashback Technologies
Module 11. Flashback Database
- Flashback Database Architecture
- Configuring Flashback Database
- Performing Flashback Database
- Best Practices for Flashback Database
Module 12. RMAN Performance and Tuning
- Tuning Principles
- RMAN Multiplexing
- Diagnosing Performance Bottlenecks
- Restore and Recovery Performance Best Practices
Module 13. Backup and Recovery Workshop Scenarios
- Workshop Structure
- Workshop Approach to Solving Failure Scenarios
- Business Requirements for Database Availability and Procedures