Multiple choice

A media failure occurred causing NOARCHIVELOG mode database to crash. It was discovered that two of the data files are corrupt. The last whole closed database backup was taken one week ago with a online redo log sequence number of 83. At the time the data files were corrupted, the online redo log sequence number was 85. Although there were few committed transactions after the last backup, as much data as possible has to be recovered. Which recovery process should be used?

  1. Shut down the instance, restore all of the Oracle files from the most recent backup, and restart the instance.

  2. Manually restore and recover the two corrupt data files from the most recent backup.

  3. Shut down the instance, restore the two corrupt data files from the most recent backup, and restart the instance.

  4. Shut down the instance, restore all of the Oracle files from the most recent backup, restart the instance, and open the database using the 'ALTER DATABASE OPEN RESETLOGS' statement.
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

In NOARCHIVELOG mode, you cannot apply redo logs for recovery since archived logs are not maintained. The only recovery option is to restore the entire database from the last consistent backup - partial restoration would create an inconsistent database state because redo logs from sequence 83 to 85 cannot be applied. Any committed transactions after the backup will be lost. Option B is incorrect because restoring only corrupt files without applying redo leaves the database inconsistent. Option C has the same issue. Option D's RESETLOGS is only valid in ARCHIVELOG mode after recovery.

Keep practicing — related questions