Oracle
1Z0-067 · Question #129
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…
The correct answer is D. 7, 6, 1, 2, 9, 10, 4. https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245 "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…
New Features for Availability
Question
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.
Options
- A7, 6, 1, 2, 3, 5, 4
- B7, 2, 1, 3, 5, 8
- C7, 6, 1, 2, 9, 10, 8
- D7, 6, 1, 2, 9, 10, 4
How the community answered
(35 responses)- A6% (2)
- B14% (5)
- C3% (1)
- D77% (27)
Explanation
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmadvre.htm#i1006245 "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."
Topics
#RMAN recovery#control file restore#data file restore#RESETLOGS sequence
Community Discussion
No community discussion yet for this question.