The data file for the users tablespace is corrupt.
Which command must you execute before starting the recovery of this tablespace ?
A) SWITCH DATAFILE ALL;
B) ALTER TABLESPACE users OFFLINE TEMPORARY;
C) STARTUP FORCE
D) ALTER TABLESPACE users OFFLINE IMMEDIATE;
E) ALTER TABLESPACE users OFFLINE NORMAL;
Answer:D
(解析:由于数据文件损坏,所以表空间无法正常 offline,会报错,只能用 immediate 选项。
来自ocp3群:1015267481)
原文:https://blog.51cto.com/13854012/2383085