Oracle Database 11g: Backup and Recovery Workshop

3 Day Course
Hands On
Official Oracle Curriculum
Code OC11GDBABRW

This course has been retired. Please view currently available Oracle 11G Training Courses.

Modules

Hide all

Introduction (8 topics)

  • 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 (6 topics)

  • 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 (8 topics)

  • 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 (7 topics)

  • 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 (7 topics)

  • 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 (8 topics)

  • 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 (7 topics)

  • 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 (4 topics)

  • 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 (8 topics)

  • 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 (8 topics)

  • Flashback Technologies Overview
  • Preparing to use Flashback Technologies
  • Flashback Query & Flashback Version Query
  • Flashback Table
  • Flashback Transaction Query
  • Flashback Transaction
  • Flashback Drop
  • Best Practices for Undo-Based Flashback Technologies

Flashback Database (4 topics)

  • Flashback Database Architecture
  • Configuring Flashback Database
  • Performing Flashback Database
  • Best Practices for Flashback Database

RMAN Performance and Tuning (4 topics)

  • Tuning Principles
  • RMAN Multiplexing
  • Diagnosing Performance Bottlenecks
  • Restore and Recovery Performance Best Practices

Backup and Recovery Workshop Scenarios (3 topics)

  • Workshop Structure
  • Workshop Approach to Solving Failure Scenarios
  • Business Requirements for Database Availability and Procedures

Prerequisites

  • Knowledge of Oracle Database administration
  • Oracle Database 11g: Administration Workshop I DBA Release 2
  • Oracle Database 11g: Administration Workshop II DBA Release 2

Suggested Prerequisites:

  • Knowledge of RMAN and Enterprise Manager

Additional Learning

The courses below may help you meet the knowledge level required to take this course. If you are unsure please ask a training advisor .

Course PDF

Print

Sections