OCP-1Z0-053-200题-155题-218-CSDN博客

本文链接：https://blog.csdn.net/rlhua/article/details/18926493

在ARCHIVELOG模式下进行用户管理的DATA1表空间备份时，若实例异常终止，DATA1表空间不会自动退出备份模式。重启数据库时，数据库将不会打开并停留在MOUNT状态，提示需要进行介质恢复。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

QUESTION 155

Your database is running in ARCHIVELOG mode. You are performing a user-managed backup of the DATA1

tablespace. You place the DATA1 tablespace in backup mode by issuing the following statement:

ALTER TABLESPACE data1 BEGIN BACKUP;

While you are performing the backup, an error occurs that causes the instance to terminate abnormally.Which

statement about the DATA1 tablespace is true?

A. The DATA1 tablespace is automatically taken out of backup mode when the instance aborts.

B. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the

database is opened.

C. If you restart the database, the DATA1 tablespace will be automatically taken out of backup mode when the

database is mounted.

D. If you restart the database, the database will not be opened.

Answer: D

Explanation/Reference:

Section: Backup, Recovery & Recovery Manager (RMAN)

If you restart the database, the database will not be opened. The database will reach the MOUNT state,but will

not be opened. An error will be generated indicatingthat media recovery is required. To successfully open the

database, you should take the tablespace out of backup mode. You can do so by issuing the ALTER

TABLESPACE data1 END BACKUP;statement, or you can issue an ALTER DATABASE END BACKUP;

statement, which will take all datafiles in all tablespaces out of back up mode.

All of the other options are incorrect. The DATA1 tablespace is automatically taken out of backup mode when

the instance aborts, when the instance is opened, or when the instance is mounted.