【第6题】【063题库】2019年OCP12c认证1Z0-063考试题库大全

文章来源：更新时间:2019/5/24 11:03:14

在线老师点击咨询：

最新学讯：近期OCP认证正在报名中，因考试人员较多请尽快报名获取最近考试时间，报名费用请联系在线老师，甲骨文官方认证，报名从速！

我要咨询

OCP 12c考试考3科，分别是071、062、063，之前071和062都已经做过解析，这里开始063题库解析，希望对考063的同学有帮助，顺利通过063考试。

OCP解析公开课时间：【每周五晚8点】

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 打开数据库，控制文件没有损坏，无需恢复。