Oracle Database 11g: Configuring for Backups

Overview/Description
To identify the steps for preparing a database for backup and then for performing various types of RMAN backups and monitoring them using reports and dynamic performance views, and also for performing user-managed backups and recoveries.

Target Audience
Database Administrators, Database Designers, Developer Support Engineers, and Technical Administrators.

Prerequisites
Working knowledge of SQL. Oracle Database 11g: Introduction to SQL. Oracle Database 11g: Administration Workshop I

Expected Duration (hours)
2.7

Lesson Objectives

Oracle Database 11g: Configuring for Backups

recognize the steps for preparing and optimizing a database for a backup.

recognize the steps for creating fast incremental backup and duplex backup sets using RMAN.

recognize the steps for creating archival and multisection backups and also for compressing and encrypting backups using RMAN.

recognize the steps for backing up to sequential media, such as tape drives, and for using reports and views to monitor backups.

identify the different types of file loss that can occur and the steps for restoring the files and recovering the database in a given scenario.

recognize the steps involved in a complete and an incomplete recovery, and identify the steps for performing a user-managed backup.

recognize the steps for performing different types of user-managed recoveries.

back up a database and recover a lost online redo log file in a given scenario.