• Online, Self-Paced
Course Description

Reconstructing the contents of all or part of a database from a backup typically involves two phases. The first phase is the retrieval of a copy of the data file from the backups. The second involves reapplying changes to the file that occurred since the backup, using archived and online redo logs. To effectively administer an Oracle Database 11g database, recovery should be performed when critical or non-critical files are lost. Once you configure RMAN to perform recovery operations, it is important to have measures in place to monitor RMAN jobs. This course explains how to use RMAN to perform recovery operations, such as recovering a database from an incremental backup, switching to image copies for fast recovery, restoring a database to a new host, and using a backup control file for recovery and performing an automatic tablespace point-in-time recovery (TSPITR) are also covered. It also discusses how to monitor the progress of RMAN jobs, including how to interpret RMAN output such as messages and error stacks. This course is one of a series in the Skillsoft learning path that covers the objectives for the Oracle Database 11g: Administration II (1Z0-053) exam.

Learning Objectives

Using RMAN to Perform Recovery

  • perform a complete recovery using RMAN
  • identify alternatives to complete recovery
  • perform a tablespace point-in-time recovery


Monitoring and Tuning RMAN

  • monitor RMAN progress
  • recognize the benefits of tuning RMAN
  • tune RMAN operations to prevent bottlenecks
  • configure RMAN to perform recoveries and monitored recovery operations


Framework Connections

The materials within this course focus on the NICE Framework Task, Knowledge, and Skill statements identified within the indicated NICE Framework component(s):

Specialty Areas

  • Data Administration
  • Systems Development