Course Topics
1. Introduction
- Oracle Maximum Availability Architecture
- Assess your recovery requirements
- Categories of failures
- Basic Workshop Architecture
- Curriculum Context
- Oracle backup and recovery solutions
- Overview of Oracle Secure Backup and Oracle Data Guard
2. Improving Your Backups
- Creating and Managing Archival Backups
- Cataloging Additional Backup Files
- Using a Media Manager
- Compressing Backups
- Backing Up Recovery Files
- Backing Up the Control File to a Trace File
- Backup and Restore for Very Large Files
3. Performing Complete Recovery
- Using RMAN for Recovery in NOARCHIVELOG Mode
- Performing Complete Recovery
- Using Restore Points
- Using Image Files for Recovery
4. Using Flashback Technologies
- Flashback Transaction Query
- Using Flashback Technology to Query Data
- Flashback Table
- Flashback Data Archive
- Flashback Technology: Overview
- Flashback Drop and the Recycle Bin
5. Duplicating a Database
- Understanding the RMAN Duplication Operation
- Comparing the “Push” and “Pull” Methods
- Choosing Database Duplication Techniques
- Creating a Backup-Based Duplicate Database
- Using a Duplicate Database
6. Getting Started
- Oracle DBA tools for backup and recovery
- Connecting to Oracle Recovery Manager (RMAN)
- Review of Oracle Database architecture
7. Using the RMAN Recovery Catalog
- Creating and Configuring the Recovery Catalog
- Using RMAN Stored Scripts
- Using Virtual Private Catalogs
- Managing Target Database Records in the Recovery Catalog
- Maintaining and Protecting the Recovery Catalog
8. Using RMAN-Encrypted Backups
- Using Dual-Mode Encryption
- Creating RMAN-Encrypted Backups
- Restoring Encrypted Backups
- Using Password-Mode Encryption
- Using Transparent-Mode Encryption
9. Performing Point-in-Time Recovery
- Performing Database Point-in-Time Recovery
- Performing Fully Automated TSPITR
- When to use Tablespace Point-in-Time Recovery (TSPITR)
- TSPITR Architecture
- Recovering Tables from Backups
11. Using Flashback Database
- Configuring Flashback Database
- Performing Flashback Database
- Flashback Database Architecture
- Creating Guaranteed Restore Points
- Best Practices for Flashback Database
12. RMAN Troubleshooting and Tuning
- Interpreting RMAN Message Output
- Tuning RMAN Backup Performance
- Configuring RMAN Multiplexing
- Diagnosing Performance Bottlenecks
13. Configuring for Recoverablility
- Configuring and managing persistent settings
- Multiplexing the control file
- RMAN commands
- Archiving redo log files
- Using the Fast Recovery Area (FRA)
- Multiplexing redo log files
14. Backup Strategies and Terminology
- Backing Up Read-Only Tablespaces
- Balancing Backup and Restore Requirements
- Backup Terminology
- Data Warehouse Backup and Recovery: Best Practices
15. Performing Backups
- RMAN Backup Types
- Oracle-Suggested Backup
- Reporting on Backups
- Managing Backups
- Fast Incremental Backup
- Incrementally Updated Backups
- Block Change Tracking
16. Diagnosing Failures
- Automatic Diagnostic Repository
- Performing Block Media Recovery
- Using the Data Recovery Advisor
- Reducing Problem Diagnosis Time
17. Restore and Recovery Concepts
- Complete Recovery (Overview)
- Instance Failure and Instance/Crash Recovery
- Restoring and Recovering
- Point-in-Time Recovery (Overview)
- Recovery with the RESETLOGS Option
- Media Failure
18. Additional Recovery Operations
- Recovery of Server Parameter File (SPFILE)
- Performing Disaster Recovery
- Recovering from the Loss of a Redo Log File Group
- Restoring the Database to a New Host
- Restoring the Control File
19. Transporting Data
- Transporting Data Across Platforms
- Database Transport: Using Data Files
- Transporting Data with Backup Sets
20. Performing Point-in-Time Recovery
- Performing RMAN TS Point-in-time Recovery
- When to use TSPITR
- Recovering Tables from Backups
- TSPITR Architecture
21. Backup and Recovery Workshop
- Workshop Structure and Approach
- Diagnosing the Failures
- Business Requirements for Database Availability and Procedures