Imagine a situation like this: Before you manage to complete an open database backup
, your system crashes and brings down the database.
You cannot open the database because the datafile in the hot backup mode is not synchronized with the database.
- Does this datafile need a recovery?
- What can you do?
Learning how to solve problems like the one above is the focus of this module.
You have already learned how to perform complete and incomplete recovery to an ARCHIVELOG database in various situations.
There are, however, other occasions when a database or datafiles may need some special attention. Although these situations do not occur frequently,
as a DBA you should be prepared for these events.
This module investigates recovery situations that can happen on occasion and provides possible solutions to handle these problems.
In addition, the maintenance of online redo logs is covered. It is important to remember that all topics in this module are
for a database running in ARCHIVELOG mode.
After completing this module, you will be able to:
Recover a datafile with no backup
Recover a file in backup mode
Clear a corrupted online redo log file
Perform a recovery with inactive online redo logs
Recreate online redo log files
Obtain recovery status information
The next lesson demonstrates how to recover a lost datafile with no backup.