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 of the following recovery processes 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 from a restored backup, so any changes after the last backup are lost. The only option is to restore the entire database from the last whole closed backup. You cannot selectively restore individual data files without opening with RESETLOGS, and even then, NOARCHIVELOG mode prevents point-in-time recovery.

Keep practicing — related questions