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

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
90 minutes

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.

Objective

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

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.