Oracle OCP题库原创解析（49）

ITAA-OCM

Your database is running in the ARCHIVELOG mode. You placed a tablespace, tbs_1, offline with the

immediate option. Which statement is correct in this scenario?

A) The operation would fail if tbs_1 were a read-only tablespace.

B) The operation would fail if tbs_1 were a read/write tablespace.

C) The operation would fail if tbs_1 were the default tablespace for the database.

D) If the above operation were successful, media recovery would be required to bring the tablespace online.

E) If the above operation were successful, instance recovery would be required to bring the tablespace online.

Answer: D

将表空间offline有三种方式，NORMAL,TEMPORARY,IMMEDIATE

其中，OFFLINE NORMAL 是默认方式。Oracle会发出检查点，并将SGA中的相关数据写入数据文件，再次online时不需要media recovery。

OFFLINE TEMPORARY 会发出检查点，但不报这个所有SGA中的数据写入数据文件，发出这个命令后可能需要media recovery。

OFFLINE IMMEDIATE 立即离线表空间，不发出检查点，一定需要media recovery。