ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
分类： Oracle
2019-04-23 10:44:13
1.One of your databases has archive logging enabled and RMAN backups are taken at regular intervals.
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)
