Backup Options   «Prev  Next»
Lesson 1

Incomplete Oracle Recovery with Archiving

Let us assume there is a media failure. You perform an ARCHIVELOG database recovery and get a message saying Oracle cannot find the archived log ARC_480.ora. In this case you cannot apply all of the redo information generated since your last backup to the restored datafiles. As a result, you have to terminate your recovery before the archived log ARC 480.ora is applied. The process you are performing is called incomplete recovery.
This module covers the basic concepts of incomplete recovery when archiving. It investigates the different situations in which incomplete recovery must be applied, the different types of incomplete recovery, and how to handle recovery in different situations.
After completing this module, you will be able to:
  1. Identify an incomplete recovery situation
  2. List incomplete database recovery steps
  3. Monitor recovery progress information using the alert log
  4. Perform a time-based recovery
  5. Perform a cancel-based recovery
  6. Use a backup control file for recovery
  7. Recover a database without the current redo log
  8. Handle recovery through RESETLOGS
  9. Perform tablespace point-in-time recovery
    The next lesson describes the situations in which an incomplete recovery is required.