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;

赞赏

长按二维码向我转账

受苹果公司新规定影响，微信 iOS 版的赞赏功能被关闭，可通过二维码转账支持公众号。

微信扫一扫
关注该公众号