Which three files would be used in the user-managed recovery process performed by the database administrator (DBA)?

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)

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

Explanation:
datafile backup + archived redo log + online redo log



Leave a Reply 0

Your email address will not be published. Required fields are marked *