ocp-174

QUESTION NO: 174
A user sends you an email with the following error message:
create table idtable(id number)
*ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: ?/oracle01/oradata/orcl/users01.dbf‘
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3
You can choose from the following steps:
a. Restore the missing database datafiles.
b. Take the missing datafile offline.
c. Shut down the database.
d. Issue the recover tablespace USERS command.
e. Issue the Startup Mount command to mount the database.
f. Bring the USERS tablespace online.
g. Issue the alter database open command.
Which is the correct order of these steps in this case?
A. b, a, d, f
B. c, a, e, b, d, f, g
C. c, e, d, g
D. b, d, f
E. e, d, g
Answer: A

---

某用户向您发送一封电子邮件包含以下错误消息：
创建IDTABLE表（ ID号）

*ERROR at line 1:
ORA-01116: error in opening database file 4
ORA-01110: data file 4: ?/oracle01/oradata/orcl/users01.dbf‘
ORA-27041: unable to open file
Linux Error: 2: No such file or directory
Additional information: 3

选择正确的步骤

b. Take the missing datafile offline. 将丢失的数据文件脱机。

a. Restore the missing database datafiles. 恢复丢失的数据库数据文件。

d. Issue the recover tablespace USERS command.发出恢复用户表空间命令。

f. Bring the USERS tablespace online. 将用户表空间联机，

A. b, a, d, f

将丢失的数据文件脱机。还原丢失的数据库数据文件，发出恢复用户表空间命令，将用户表空
间联机

---