Oracle 11G OCP 1Z0-053 574

（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部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1319570/，如需轉載，請註明出處，否則將追究法律責任。