Backup and Recovery with Oracle9i RMAN
- 21 Hour Online Class or 3 Day Classroom Workshop
Comprehensive, hands-on overview of Oracle’s Recovery Manager (RMAN) for Oracle DBAs or operators who are new to backup and recovery concepts, or currently using user-managed backup techniques. Covers an introduction to RMAN including new features through Oracle 9i Release 2; RMAN architecture and setup; executing RMAN commands; Channels; Backup, Restore and Recovery; debugging; scripting and reporting; media management concepts and the Media Manager; RMAN maintenance and tuning.
This hands-on class is intended for experienced Oracle technologists** who need to use or evaluate Recovery Manager, Oracle's utility for backup and recovery. Personnel new to backup and recovery or those currently using user-managed backup techniques will benefit from this class. This 9i Release 2 compatible course is a comprehensive and practical introduction to RMAN including architecture, setup, backup, restore and recovery, recovery catalog maintenance, debugging, tuning and reporting. Every chapter contains many working examples and at least one hands-on workshop (exception: Intro and Architecture chapters contain Q&A summary only) .
This course was recently updated (May 2005). All lessons were reviewed and updated to ensure most current and accurate information available is included.
Audience: Oracle DBAs or operators.
Prerequisites ** : Students must possess a working knowledge of:
Oracle architecture (e.g. What is archiving? What is the control file?)
Oracle startup and shutdown (e.g. What is the parameter file?)
Some DDL commands such as CREATE TABLESPACE
Backup and recovery concepts are helpful but not necessary (e.g. what is a point in time recovery?).
Objectives:
After successfully completing this course, you will be able to:
Use RMAN to backup all your 8.x and 9.x databases to disk or tape
Use RMAN to restore and recover all your 8.x and 9.x databases
Tune RMAN operations (disk and tape)
Setup RMAN to backup and restore from tape devices
Perform full and incremental backups (to disk or tape) of databases, tablespaces and datafiles
Perform complete and incomplete (point in time) recoveries
Backup and Recover the control file
Use the new Oracle9i features such as configurable channels, control file auto-backup and block media recovery
Create RMAN scripts
Allocate channels to employ parallelism and other tuning techniques
Generate RMAN reports to determine what can be recovered, what needs to be backed up and more.
Maintain the recovery catalog and target database control file
Use special features such as backup set duplexing, restore validation and more
