Course Topics
1. Introduction
- Oracle Maximum Availability Architecture
- Oracle Secure Backup
- Basic Workshop Architecture
- Oracle backup and recovery solutions
- Curriculum Context
- Categories of failures
- Benefits of using Oracle Data Guard
- Assess your recovery requirements
2. Backup Strategies and Terminology
- Additional Backup Terminology
- Backing Up Read-Only Tablespaces
- Backup Solutions Overview and Terminology
- Data Warehouse Backup and Recovery: Best Practices
- Balancing Backup and Restore Requirements
3. Using RMAN-Encrypted Backups
- Using Dual-Mode Encryption
- Using Password-Mode Encryption
- Using Transparent-Mode Encryption
- Creating RMAN-Encrypted Backups
4. Performing Recovery, Part I
- RMAN Recovery in NOARCHIVELOG Mode
- Performing Point-in-Time (PITR) or Incomplete Recovery
- Recovery with Image Files
- Performing Complete Recovery (of critical and noncritical data files)
- Restoring ASM Disk Groups
5. Using Flashback Technologies
- Using Flashback Technology to Query Data
- Flashback Drop and the Recycle Bin
- Flashback Transaction (Query and Backout)
- Flashback Technology: Overview and Setup
- Flashback Table
- Flashback Data Archive
6. RMAN Troubleshooting and Tuning
- Interpreting RMAN Message Output
- Tuning Principles
- RMAN Multiplexing
- Diagnosing Performance Bottlenecks
- Restore and Recovery Performance Best Practices
7. Getting Started
- Oracle DBA Tools for Backup and Recovery
- Connecting to Oracle Recovery Manager (RMAN)
- Quick Start: A Problem-Solution Approach
- Core Concepts of the Oracle Database, critical for Backup and Recovery
8. Performing Backups
- RMAN Backup Types
- Oracle-Suggested Backup
- Reporting on Backups
- Block Change Tracking
- Fast Incremental Backup
- Incrementally Updated Backups
- Managing Backups
9. Diagnosing Failures
- Automatic Diagnostic Repository
- Handling Block Corruption
- Reducing Problem Diagnosis Time
- Data Recovery Advisor
10. Performing Recovery, Part II
- Redo Log File Loss and Recovery
- Restoring RMAN Encrypted Backups
- Recovery of Server Parameter File, Control File (One and All)
- Restoring the Database to a New Host
- Disaster Recovery
- Index, Read-Only Tablespace, and Tempfile Recovery
- Password Authentication File Re-creation
11. Using Flashback Database
- Configuring Flashback Database
- Flashback Database Architecture
- Best Practices for Flashback Database
- Performing Flashback Database
12. Performing Point-in-Time Recovery
- Performing RMAN TS Point-in-time Recovery
- When to use TSPITR
- Recovering Tables from Backups
- TSPITR Architecture
13. Cloud Tooling for Backup and Recovery
- Customize Backup Configuration
- Backup Destinations
- Installing the Backup Module
- Oracle Backup Cloud Service
- On-Demand Backup and Recovery
14. Configuring for Recoverablility
- Control File
- RMAN commands
- Using the Fast Recovery Area (FRA)
- Archiving Logs
- Configuring and managing persistent settings
- Redo Log File
15. Using the RMAN Recovery Catalog
- Creating and Configuring the Recovery Catalog
- Using RMAN Stored Scripts
- Managing Target Database Records in the Recovery Catalog
- Maintaining and Protecting the Recovery Catalog
- Virtual Private Catalogs
16. Improving Your Backups
- Creating RMAN Multisection Backups, Proxy Copies, Duplexed Backup Sets and Backups of Backup Sets
- Creating and Managing Archival Backups
- Cataloging Additional Backup Files
- Compressing Backups
- Backup and Restore for Very Large Files
- Backing Up Recovery Files
- Backing Up the Control File to a Trace File
- Using a Media Manager
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. RMAN and Oracle Secure Backup
- Configuring Oracle Secure Backup for RMAN
- RMAN Backup and Restore Operations
- RMAN and OSB: Overview and Basic Process Flow
- Displaying OSB log files and transcripts for RMAN activities
- Starting with Oracle Secure Backup
- Oracle Secure Backup Jobs
- Oracle Secure Backup Overview and Interface Options
19. Transporting Data
- Transporting Data Across Platforms
- Database Transport: Using Data Files
- Transporting Data with Backup Sets
20. Duplicating a Database
- Duplicating Database with push anpull techniques
- Understanding the RMAN Duplication Operation
- Choosing Database Duplication Techniques
- Creating a Backup-up Based Duplicate Database
- Using a Duplicate Database
21. Backup and Recovery Workshop
- Workshop Structure and Approach
- Diagnosing the Failures
- Business Requirements for Database Availability and Procedures