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:
Describe the implications of instance failure with an ARCHIVELOG database
Describe the different methods of recovery
Describe a complete recovery operation
Recover a closed database
Recover an open database, initially open
Recover an open database, initially closed
The next lesson explains the implications of instance failure with ARCHIVELOG databases.