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)
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
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
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
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
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
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
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
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
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
Flashback Database
- Flashback Database Architecture
- Configuring Flashback Database
- Performing Flashback Database
- Best Practices for Flashback Database
RMAN Performance and Tuning
- Tuning Principles
- RMAN Multiplexing
- Diagnosing Performance Bottlenecks
- Restore and Recovery Performance Best Practices
Backup and Recovery Workshop Scenarios
- Workshop Structure
- Workshop Approach to Solving Failure Scenarios
- Business Requirements for Database Availability and Procedures