back to Course Categories | back | print
Oracle9i Advanced Recovery Manager Workshop          

Duration: 3 days

Recovery Manager (RMAN) has become the primary tool for performing backup and recovery in large and complex environments. This class will teach experienced DBAs how to perform backup, restore and recovery operations using RMAN. Students will also learn how to troubleshoot RMAN, work with media managers, and diagnose operating system errors related to RMAN backup and recovery operations.


  • Recovery Manager Overview
  • Issues with Managing Backups
  • What is Recovery Manager?
  • RMAN Interfaces
  • Working with Recovery Manager
  • Recovery Manager Components
  • RMAN Compatibility
  • Using Recovery Manager
  • Using RMAN with Multiple Platforms
  • Advantages of RMAN
  • Disadvantages of RMAN
  • Oracle9i RMAN Enhancements
  • Improved Error Output
  • Recovery Manager Terminology
  • Recovery Manager without the Recovery Catalog
  • Contents of the Recovery Catalog
  • Catalog Considerations
  • Advantages of the Recovery Catalog
  • Disadvantages of the Recovery Catalog
  • Creating a Catalog Database
  • Connecting to a Catalog Database
  • Connecting without a Recovery Catalog
  • Connect to a Target Database with a Recovery Catalog
  • Connecting to an Auxiliary Instance
  • Connect Using a Script:
  • Register the Target Database with the Recovery Catalog
  • Unregister the Target Database with the Recovery Catalog
  • Resynching the Catalog and Target Databases
  • Managing Recovery Manager
  • Types of RMAN Commands
  • Standalone and Job Commands
  • More on RMAN Commands
  • Executing Recovery Manager Commands
  • Customizable Configuration Parameters
  • New SHOW Parameters
  • Channel Allocation
  • Persistent Channel Settings
  • NEW_FILE_SPEC Option
  • Server Parameter and Control File Autobackup
  • SPFILE Option
  • Cleaning Up Backups or Copies
  • Cleanup Commands
  • The Change Delete Command
  • Force Option of DELETE Command
  • Performing Trial Recovery
  • REPORT Command
  • REPORT Need Backup and Obsolete Commands
  • The LIST Command
  • Additional LIST Options
  • Recovery Manager Data Dictionary Views
  • Reserved words
  • Oracle9i Recommended Syntax
  • Types of RMAN Backups
  • Automatic Tags for Backups
  • RMAN Backup Integrity Check
  • Perform a Full Database Consistent Backup
  • Crosschecking the Backup
  • Retention Policies
  • Retention Policy Removal of Obsolete Backup Copies
  • RMAN Restore Capabilities
  • Restore Command
  • Restoring a Database
  • Restoring the Database to a New Location
  • Restoring the Database to a New Location without a Catalog
  • Restoring with a RAC Environment
  • Create a Stored Script
  • Backup a Datafile
  • Making Backups of Tablespaces
  • Views to Determine if Recovery is Needed
  • Recover a Tablespace that is Accessible
  • Recover an Inaccessible Tablespace
  • Backup Archived Redo Logs
  • Backups of Archived Logs Needing Backup
  • The Backup Archivelog Delete Input command
  • Backup Archived Redo Logs
  • Managing Space When Restoring Archived Logs
  • Backing up Archived Redo Logs Enhancements
  • Restore Archived Redo Logs
  • Archive Log Features
  • Catalog Operating System Backups
  • Image Copies
  • Incomplete Recovery Using Until Time
  • Incomplete Recovery Using SCN
  • Using Recovery Manager with a Media Manager
  • Backups to disk
  • Backups to tape
  • Media management interface
  • Default SBT interface
  • Linking with a Media Manager
  • Architecture for MML integrated with Oracle
  • Backup and restore operations using a Media Manager
  • Media Manager crosschecks
  • Debugging Recovery Manager
  • Identifying types of message output
  • The DEBUG option
  • RMAN error stack with RMAN error
  • RMAN error stack with Media Manager error
  • RMAN error stack with server error
  • Monitoring Recovery Manager jobs
  • Recovery Manager Performance Issues
  • Performance rules
  • Multiplexing
  • Proper implementation of parallelization
  • Performance monitoring
  • Bottlenecks with Synchronous and Asynchronous


  • Attendees must have previous Oracle database administration experience and a fundamental understanding of RMAN. This class is for DBAs who need to learn the advanced features of RMAN for backup and recovery in complex Oracle environments.


Trubix Inc. P.O. Box 2235 Littleton, CO 80161 | 1.866.4-TRUBIX • 303.730.6800

Training Service | Consulting / Mentoring | Public Schedule | Course Listings | Tru iLearning | About Us | Contact Us
Oracle DBA Classes | Oracle Dev Classes | Oracle App Server Classes | Linux / Unix Classes
SQL Server / .NET / Tools / DB2 Classes / Public Classes


all content property © 2006, 2007Trubix Inc.| site design by Art Z design