ocp-178

QUESTION NO: 178
Your ARCHIVELOG-mode database has lost three datafiles and shut down. One is assigned to the
SYSTEM tablespace and two are assigned to the USERS tablespace. You can choose from the following
steps to recover your database:
a. Restore the three database datafiles that were lost.
b. Issue the Startup Mount command to mount the database.
c. Issue the alter database open command.
d. Issue the alter database open resetlogs command.
e. Recover the database using the recover database command.
f. Recover the datafiles with the recover datafile command.
g. Take the datafiles offline.
Which is the correct order of these steps in this case?
A. a, b, e, c
B. b, e, d
C. a, b, d, c
D. b, g, c, f
E. a, b, d, f
Answer: A

---

您归档模式的数据库已经失去了三个数据文件并关机。一个被分配到系统
表空间，两个被分配到用户表空间。您可以选择以下步骤来恢复你的数据库：

a. 还原这三个已丢失的数据库数据文件。
b. 发出启动挂载命令以挂载数据库
c. 发出修改数据库打开命令。
e.使用恢复数据库命令恢复数据库。

A. a, b, e, c

First you would want to restore the three datafiles that were lost. Then you would want to issue the
startup mount command to mount the database to prepare for recovery. You would then recover the
database (you could opt to recover just the datafiles if you wished). Finally, open the database with the
alter database open command.

---