> > > D71862GC10 Detailed outline

Oracle Database 11g: Backup and Recovery Workshop (D71862GC10)

Course Description Schedule Course Outline

Detailed Course Outline

  • 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