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:
Identify an incomplete recovery situation
List incomplete database recovery steps
Monitor recovery progress information using the alert log
Perform a time-based recovery
Perform a cancel-based recovery
Use a backup control file for recovery
Recover a database without the current redo log
Handle recovery through RESETLOGS
Perform tablespace point-in-time recovery
The next lesson describes the situations in which an incomplete recovery is required.