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. It is a more complicated procedure than recovering a NOARCHIVELOG database because you must perform recovery by applying the archived and redo logs after the damaged datafiles are restored. This module investigates different methods of performing complete media recovery on an ARCHIVELOG database.
After completing this module, you will 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

The next lesson explains the implications of instance failure with ARCHIVELOG databases.