Oracle 11g Backup and Recovery

Course code: O1032

3 days £1,185.00

iTrain's Oracle 11g Backup and Recovery training course is designed to give the Oracle 11g database administrator a firm foundation in the concepts of Backup & Recovery, along with various ways of how to implement and effectively maintain recovery proced

Course content >

Who Should Attend?

  • Database Administrators
  • System Administrators
  • Support Engineers


iTrain also offer all of these courses as closed courses on your site. Please call 020 7608 1835


Course Contents

Students will learn on this Oracle 11g Backup and Recovery training course the enhancements and changes that have been introduced with 11g.

Oracle 11g Backup and Recovery training course will demonstrate these changes for the benefit of all students attending with a hands on approach and given a good understanding of how to manage and administer Oracle data and give an in-depth knowledge of the tools to ensure optimal database availability.

Oracle 11g Backup and Recovery Training Course Contents

Backup and Recovery Overview

  • Understanding the structures and processes for backup and recovery.
  • Introduce the different methods for backup and recovery
  • Diagnose and troubleshoot database problems.
  • Understand Oracle Recovery Manager

Backup and Recovery

  • Recovery structures and processes
  • Backup and recovery configuration
  • Types of failure and troubleshooting
  • Complete recovery
  • Incomplete media recovery
  • Export and import utilities
  • Test Recovery

Oracle Recovery Manager

  • RMAN command line prompt
  • Recovery Manager architecture
  • Setting up Recovery Manager
  • Database space requirements and privileges
  • Creating and running backup and recovery scripts from RMAN
  • Using LIST and REPORT options from Recovery Manager
  • Crash Recovery workshop,
  • Persistent Parameters
  • Block Level recovery
  • Depreciated Commands

Create a recovery Catalog

  • Catalog Maintenance
  • Resync recovery Catalog
  • Create and store Backup scripts
  • Recovery Catalog views

Enterprise Manager Utilities

  • Creating an Backup Configuration
  • Configurable Parameters

Standby Databases & Data Guard

  • Data Guard Features
  • Creating the Standby Database
  • Maintaining the Standby Database
  • Altering the Physical Structure
  • Failover without Data Guard
  • Failover Using Data Guard
  • Role Transitions Using Data Guard
  • Data Guard Protection Modes


  • Flashback Features
  • Enabling Flashback
  • Flashback Query
  • Additional Query Functions
  • Flashback Version Query
  • Flashback Transaction Query
  • Flashback Table
  • Flashback Drop (Recycle Bin)
  • Flashback Database

Data Recovery Advisor

  • Repairing data failures
  • Executing repairs
  • Classifying and Closing failures
Contact us for more information