Backup Options   «Prev  Next»

Lesson 8

Oracle Database Downtime

In this module, you learned how to minimize database downtime during the recovery process. You can achieve this by various methods including starting the database with the missing datafiles or performing parallel recovery. In addition, you learned how to perform read-only tablespace recovery and how to reconstruct the damaged or lost control file. If you take the time to plan recovery strategies before a media failure occurs, you can expedite the recovery process as well as recover damaged or lost files.
Having completed this module, you should be able to:
  1. List the methods for minimizing database downtime
  2. Start a database with missing datafiles and perform a recovery
  3. Describe a parallel recovery
  4. Reconstruct a lost or corrupted control file
  5. Recover a read-only tablespace
  6. Describe recovery issues related to read-only tablespaces


This module introduced you to the following terms:
  1. Parallel recovery: This recovery process allows several datafiles on different disks to be recovered at the same time. Parallel recovery is a very effective way to minimize recovery time.
  2. Control file: A control file is a binary file containing the name and creation time of the database, the names and locations of a database's datafiles and redo log files. Every time an instance of the database is started, its control file is used to identify the datafile and redo log file that must be open for the database to run properly.

Recovering read Only Tablespace - Quiz

Click the Quiz link below to review your understanding of the control file and the read-only tablespace.
Recovering read Only Tablespace - Quiz

Recover lost control File - Exercise

Click the Exercise link below to practice how to recover a lost control file.
Recover lost control File - Exercise