OCP-1Z0-053-200题-2题-86

QUESTION 2

Your production database is running in archivelog mode and you are using recovery manager (RMAN) with

recovery catalog to perform the database backup at regular intervals. When you attempt to restart the

database instance after a regular maintenance task on Sunday, the database fails to open displaying the

message that the data file belonging to the users tablespace are corrupted.

The steps to recover the damaged data files are follows:

1. Mount the database

2. Open the database

3. Recover the data file

4. Restore the data file

5. Make the data file offline

6. Make the data file online

Which option identifies the correct sequence that you must use to recover the data files?

A. 2, 4, 3

B. 1, 4, 3, 2

C. 2, 5, 4, 3, 6

D. 5, 2, 4, 3, 6

E. 1, 5, 4, 3, 6, 2

Answer: E

同86题：http://blog.csdn.net/rlhua/article/details/12372493

从题意中看出，数据库尝试打开数据库时，发生报错，故此时应该为mount状态，不是open状态。

故个人觉得，这道题应该为5, 2, 4, 3, 6，选D

在数据库mount时，先offline数据文件，在打开数据库，然后restore和recover，在online数据文件