Multiple choice technology databases

Your database is running in NOARCHIVELOG mode. Every night there is a backup taken using RMAN. During your startup this morning you received an error regarding DISK 3 on your server.This is the location of your data file for the SYSTEM tablespace. Which option is open to you?

  1. The data file needs to be restored by using operating system commands, because a data file movement must take place, and then the database can be recovered from RMAN.

  2. The data file needs to be restored by using operating system commands, since a data file movement must take place, and then the database must be recovered manually.

  3. From RMAN you can issue the commands RESTORE and RECOVER. RMAN automatically restores the data file on DISK 3 to another disk, based upon utilization statistics.

  4. From RMAN you can issue a SET NEWNAME command to update the data file location information in the control file, and then issue the RESTORE and RECOVER commands to recover the database.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When a data file is lost in NOARCHIVELOG mode, you can only restore to the point of the last backup. If you need to restore to a different disk location, use SET NEWNAME in RMAN to tell the control file the new location, then RESTORE and RECOVER. Options A and B incorrectly suggest OS commands for restore - RMAN handles this. Option C is incorrect - RMAN doesn't automatically relocate files based on utilization; you must specify the location.

Keep practicing — related questions