Course Title:
Fundamentals of RMAN

Duration: 1 day

Course Overview
This course focuses on Oracle’s backup and recovery utility Recovery Manager (RMAN). The delegates will learn about the architecture of RMAN and how to use it both with a catalogue and without a catalogue. They will look at running RMAN scripts from the prompt, from stored files and from shell scripts. They will be exposed to a wide range of backups, from a complete online backup using the tool, to simply backing up individual tablespaces, data files and control files. To compliment the backup procedures associated with RMAN, delegates will also learn the different recovery methods, from complete database recovery to point-in-time recovery.

Target Audience


This course is suitable for database administrators.

Course Objectives


By the end of the course attendees will:

• Understand the architecture of the RMAN utility
• Be aware of the different backup and recovery strategies available using the tool
• Be able to perform a full online database backup using RMAN
• Be able to perform a full offline database backup using RMAN
• Be able to perform partial online database backups using RMAN
• Be able to perform a full online database recovery using RMAN
• Be able to perform a full offline database recovery using RMAN
• Be able to point-in-time recovery using RMAN
• Know the advantages and disadvantages of using the RMAN catalogue

Prerequisites


A good knowledge of the Oracle database is essential, together with knowledge of basic operating system commands (e.g. copy, delete, move). Ideally delegates will have attended the Fundamentals of Database Administration course.

Course Content


Introduction
• Terminology
• Prerequisites of Your Target Database
• To Catalogue or Not To Catalogue?

Executing Commands
• Executing from the Command Prompt
• Executing from a File
• Using Scripts

Implementing a Catalogue
• Advantages and Disadvantages
• Catalogue Issues
• Creating a Catalogue
• Registering a Target Database

Storing Scripts in the Catalogue
• Storing a Script
• Executing a Script
• Viewing a Script
• Deleting a Stored Script

Backups
• Full Database Offline Backup
• Full Database Online Backup
• Tablespace Backup
• Data File Backup
• Control File Backup
• Archived Redo Log Files Backup
• Incremental Backups
• Backup Tips

Restoring
• Restoring Every Data File
• Restoring Specific Data Files/Tablespaces
• Restoring Read-Only Tablespaces
• Point-In-Time Recovery
• Restoring Control Files
• Restoring Archived Redo Log Files

We have used Pentland for a number of years to provide for our needs in a number of areas, including .NET, C Sharp and UML.

Pentland’s ability to provide training tailored to the needs of our group has been critical to our ongoing success.

Software Control Manager
Waters


Enter your email address to register for our newsletter:


IT Technical & End User
Course Listings

For further information, or to make a telephone booking, or to receive a competitive quotation for an in-house course, you can call Pentland Training now on 0800 328 2766.

All of our training courses can be delivered on your own site, at Pentland Training facilities, or at an off-site venue.

follow us on Twitter