Oracle Database 11g: Backup and Recovery Workshop

  • 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

Course Inquery Form