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, no archived redo logs are maintained, making point-in-time recovery impossible. When media failure occurs, you can only restore from the last whole closed backup - you cannot apply incremental changes. Restoring only corrupt files won't work because the database would be in an inconsistent state. RESETLOGS is for archived log recovery scenarios. The only option is to restore all files from backup, accepting data loss since the last backup.

Keep practicing — related questions