• Online, Self-Paced
Course 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.

Learning Objectives

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

 

Framework Connections

The materials within this course focus on the Knowledge Skills and Abilities (KSAs) identified within the Specialty Areas listed below. Click to view Specialty Area details within the interactive National Cybersecurity Workforce Framework.