Your database is running in noarchivelog mode. One of the data files belonging to the
system tablespace is corrupted. You notice that all online redo logs have been overwritten
since the last backup.
Which method would you use to recover the data file?
A.
Shut down the instance if not already shut down, restore all 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, 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, restore all data files for the entire
database from the last backup, and restart the instance.
D.
Mount the database, restore all data files belonging to the system tablespace from the last
backup, and open the database.
C
C
C
C
C but why no restore controlfile
These are steps from oracle training slide
If the database is in NOARCHIVELOG mode and if any data file is lost, perform the following tasks:
1. Shut down the instance if it is not already down.
2. Restore the entire database—including all data and control files—from the backup.
3. Open the database.
4. Have users re-enter all changes that were madesince the last backup.
But here control file restore not needed
https://docs.oracle.com/database/121/BRADV/rcmadvre.htm#BRADV89841
C, C and only C => noarchivelog + all redo logs overwritten!
C