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