Oracle Database 11g Release 2: Performing Restore and Recovery Tasks

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

Prerequisite
Please contact us for information about prerequisites.

Expected Duration
60 minutes

Description
As a database administrator it is very important to understand how to restore and recover your database in the event of a loss of a file due to media, hardware, or user error. The restoration process involves moving a backup into place to be used by the database when a file is damaged. The recovery process involves applying redo to bring the file forward in time to before the failure or up to the failure point. This course discusses the type of failures that can occur and how to recover from them. It also discusses how to perform user-managed backup and recoveries. 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

Restore and Recovery Tasks

  • identify the causes of file loss
  • recover log files and indexes
  • identify the major recovery processes
  • recover a read-only tablespace
  • recover an Oracle database

Performing User-Managed Backup and Recovery

  • recognize the different types of user-managed backup and recovery practices
  • perform different types of user-managed recoveries

MONTHLY SUBSCRIPTION

$129/month
 

ANNUAL SUBSCRIPTION

$1295/year

Multi-license discounts available for Annual and Monthly subscriptions.