Your database is in NOARCHIVELOG mode.
One of the two data files belonging to the SYSTEM tablespace is corrupt.
You discover that all online redo logs have been overwritten since the last backup.
Which method would you use to recover the data file using RMAN?
A.
Shut down the instance if not already shut down, restart in MOUNT state, restore both data files
belonging to the SYSTEM tablespace from the last backup, and restart the instance.
B.
Shut down the instance if not already shut down, restart in mount state, restore the corrupted
data file belonging to the system tablespace from the last backup, and restart the instance.
C.
Shut down the instance if not already shut down, restart in mount state, restore all data files for
the entire database from the last backup, and restart the instance.
D.
Shut down the instance if not already shut down, restart In MOUNT state, restore all data files
belonging to the SYSTEM tablespace from the last backup, and restart the instance.
E.
Shut down the instance if not already shut down, restart In NOMOUNT state, restore all data
files for the entire database from the last backup, and restart the instance.
Explanation:
Reference: http://docs.oracle.com/cd/B10501_01/server.920/a96566/rcmrecov.htm (restoring the
server parameter file)