O10401 - Oracle 10g Recovery Manager

Availability

Training Course Objectives

This course is designed to give the Oracle 9i/10g database administrator a firm foundation in recovery methods using RMAN. Running as a combined course and workshop, we aim to provide the DBA with the necessary skills to backup, restore, recover, and understand the use of the RMAN tool.

Enhancements and changes introduced up to and including 10g will be discussed and covered during this course.

While applicable to those using Oracle 9i systems, the course is delivered using Oracle 10g unless specified.

Training Course Contents

Training Course Contents

Overview

• Understanding the structures and processes involved in backup and 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
• Creating the Recovery Catalog
• Recovery Manager Commands
• Connecting with and without a Recovery Catalog
• Controlfile Information

Recovery Catalog Maintenance

• Registering a Database
• Resynch Catalog Command
• Reset Database Command
• Catalog Command
• Re-creating the Recovery Catalog
• Change Command
• Crosscheck command
• Recovery Catalog Reporting
• Stored scripts
• Run Command

Physical Backups Using Recover

• Supported Backup Types
• Allocating a Channel
• Image Copies
• Backup Sets
• Full, Incremental, and Cumulative Backups
• Backup Constraints
• SPFILE and Controlfile Backups
• Persistent Parameters
• Duplication of databases using RMAN

Restore & Recovery Using RMAN

• Restore a Database in NOARCHIVELOG Mode
• Complete recovery in open and closed databases
• Relocation of Datafiles: Disk Corruption
• Incomplete Recovery of a Database to time, change or log sequence
• Block Level Recovery

Enterprise Manager Utilities

• Catalog Maintenance Using Enterprise Manager
• Creating an OEM Backup Configuration
• OEM backup and recovery

Crash Recovery Workshop

• Troubleshoot and recover Oracle databases using RMAN