【第6題】【063題庫】2019年OCP12c認證1Z0-063考試題庫大全
最新學訊：近期OCP認證正在報名中，因考試人員較多請盡快報名獲取最近考試時間，報名費用請聯系在線老師，甲骨文官方認證，報名從速！
我要咨詢OCP 12c考試考3科，分別是071、062、063，之前071和062都已經做過解析，這里開始063題庫解析，希望對考063的同學有幫助，順利通過063考試。
OCP解析公開課時間：【每周五晚8點】
OCP解析公開課地址：http://ke.qq.com/course/326223
OCP解析群資料分享：1015267481 驗證：ocp
-------------------------------------------------------
第6題.You are administering a database that supports data warehousing workload and Is running in
noarchivelog mode. You use RMAN to perform a level 0 backup on Sundays and level 1
Incremental backups on all the other days of the week.
One of the data files is corrupted and the current online redo log file is lost because of a media failure.
You want to recover the data file.
Examine the steps involved in the recovery process:
1. Shut down the database instance.
2. Start up the database instance in nomount state.
3. Mount the database.
4. Take the data file offline.
5. Put the data file online.
6. Restore the control file.
7. Restore the database.
8. Restore the data file.
9. Open the database with the resetlog option.
10. Recover the database withthe noredo option.
11. Recover the data file with the noredo option.
Identify the required steps in the correct order.
A. 4, 8, 11, 5
B. 1, 3, 8, 11, 9
C. 1, 2, 6, 3, 7, 10,9
D. 1, 3, 7, 10, 9
E. 1, 2, 6, 3, 8, 11,9
Answer: D
解析：因為是非歸檔數據庫，所以恢復的時候必須要恢復整個數據庫，然后 recovery 一下，用 resetlogs 打開數據庫，控制文件沒有損壞，無需恢復。
