（574）A user sends you an email with the following error message:

create table idtable (id number)*

ERROR at line 1:ORA-01110:data file 4: '/oracle01/oradata/orcl/users01.dbf'

ORA-27041:

01116:error in opening database file 4 ORA-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

答案：（A）

解析：

脱机->还原->恢复->联机

注意：这里脱机的是数据文件, 联机的是表空间（实验一下）

ITPub博客

Oracle 11G OCP 1Z0-053 574