052-207(新增70题2018)

Due to media failure you lost one of the data files belonging to the USERS tablespace, and the tablespace is not available to use.

Which statement regarding the status of the database is true?

A. The database remains open.

B. The database gets dismounted.

C. The database becomes read only.

D. The database instance gets aborted.

E. The database gets shut down automatically.

F. The status of the database depends on the status of the USERS tablespace.

Answer: A
media failure 

 When Oracle detects media failure, it takes the affected files offline.
实验:

create tablespace GL
logging
datafile '/home/oracle/app/oracle/oradata/orcl/TSET101.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

在操作系统级别将TSET01.DBF移动到其他目录。
无报错。数据库正常打开。