Your database is running In ARCHIVELOG mode. One of the data files, USERDATA01.DBF,
in the users tablespace is damaged and you need to recover the file until the point of failure.
The backup for the data file is available.
Which three files would be used in the user-managed recovery process performed by the
database administrator (DBA)? (Choose three.)
A.
redo logs
B.
control file
C.
temporary files of temporary tablespace
D.
the latest backup of only the damaged data file
E.
the latest backup of all the data files In the USERS tablespace
Your database is running in ARCHIVELOG mode. One of the data files, USERDATA01.dbf, in the USERS tablespace is damaged and you need to recover the file until the point of failure. The backup for the datafile is available. Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)? (Choose Three)
A.
Redo logs
B.
Control file
C.
The latest backup of only the damaged data file
D.
The latest backup of all the data file in the USERS tablespace
E.
Temporary files of temporary tablespace
F.
Archive Logs since the latest backup to point of failure
Answer : ACF
If @spellblind version is correct then these files would be required to recover the database
A. Redo logs
C. The latest backup of only the damaged data file
F. Archive Logs since the latest backup to point of failure
However F above may not be sufficient, just because a failure occurred with a non critical datafile does not mean that the database stopped, therefore it is possible that more archive redo logs were generated after the point of failour so these will also be required to bring the database up to date along with the online redo logs.
Then it would be A,B,C,F. Since ControlFiles contain all the metadata.
^If we have four options to choose.
Yes, but you are not required to restore it from a backup or anything like that nor are you required to mention it during the restore and recover process of the datafile.