Recovery with Archiving  «Prev  Next»

Lesson 8

ARCHIVELOG Database Recovery Conclusion

This module introduced you to various methods for performing ARCHIVELOG database recovery. You learned that the recovery method you use depends on the state of the database. You also leaned how to perform ARCHIVELOG database recovery using different methods.
Having completed this module, you should be able to:
  1. Describe the implications of instance failure with an ARCHIVELOG database
  2. Describe the different methods of recovery
  3. Describe a complete recovery operation
  4. Recover a closed database
  5. Recover an open database, initially open
  6. Recover an open database, initially closed


This module introduced you to the following terms:
  1. Instance failure: Instance failure means an abrupt end to an Oracle instance either due to a hardware or software problem. The system global area and background processes cease to function. Therefore, any data in the buffer that had not already been written to a datafile at the time of the instance failure will be lost.
    On the other hand, complete recovery recovers the damaged datafiles as well as all data that had been committed prior to the moment of instance failure.
  2. Complete recovery: Complete Oracle recovery, also known as complete media recovery, is applied to a database running in ARCHIVELOG mode. Complete recovery with archiving allows you to recover your database up to the time just prior to the occurrence of media failure.
  3. System global area: The Oracle database employs several memory structures that are contained with the System Global Area (SGA). The System Global Area contains three main in-memory structures. These memory structures may be tuned or modified by the DBA to improve performance. These memory structures include Shared Pool, Database Buffer Cache, and Redo Log Buffer.

In the next module, you learn how to perform incomplete Oracle recovery with archiving.

Complete Database Recovery - Quiz

Click the Quiz link below to test your knowledge about complete database recovery.
Complete Database Recovery - Quiz

Recover Open Database

Click the link below to learn about recovering an open database, initially open.
Recover Open Database