1z0-067 Free Dumps Study Materials
Question 18: Your database is running in archivelog mode. You are taking a backup of your database by
using RMAN with a recovery catalog. Because of a media failure, one of the data files and all the
control files are lost.
Examine the steps to recover the database:
1. Restore the control files by using the RMAN restore controlfile command.
2. Mount the database.
3. Restore the data files by using the RMAN restore database command.
4. Open the database with the resetlogs option.
5. Recover the data files by using the RMAN recover using backup controlfile command.
6. Start the database instance in nomount state.
7. Connect to the target database by using a recovery catalog.
8. Open the database.
9. Restore the data file.
10. Recover the data file.
Identify the required steps in the correct order.
A. 7, 6, 1, 2, 3, 5, 4
B. 7, 6, 1, 2, 9, 10, 8
C. 7, 6, 1, 2, 9, 10, 4
D. 7, 2, 1, 3, 5, 8
Correct Answer: C
Explanation
"If all copies of the current control file are lost or damaged, then you must restore and mount a
backup control file. You must then run the RECOVER command, even if no datafiles have been
restored, and open the database with the RESETLOGS option."
