Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN


Overview/Description
Target Audience
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/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.

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

Expected Duration (hours)
1.5

Lesson Objectives

Oracle Database 11g Release 2: Using, Monitoring and Tuning RMAN

  • perform a complete recovery using RMAN
  • identify alternatives to complete recovery
  • perform a tablespace point-in-time recovery
  • monitor RMAN progress
  • recognize the benefits of tuning RMAN
  • tune RMAN operations to prevent bottlenecks
  • configure RMAN to perform recoveries and monitored recovery operations
  • Course Number:
    od_odat_a04_it_enus

    Expertise Level
    Intermediate