ocp-419

来源:互联网 发布:九龙朝圣兽数据 编辑:程序博客网 时间:2024/06/07 11:28

QUESTION NO: 419
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


你的数据库运行在归档记录模式。您正在执行一个数据1表空间的用户
管理的备份。您发出下列语句放置数据1表空间于备份模式: 修改表空间数据1开始备份;
当您执行备份时,发生一个错误,导致实例异常终止。哪个描述的数据1表空间是真的?

D.如果重新启动数据库,该数据库将无法打开。

如果重新启动数据库,该数据库将无法打开该数据库将达到MOUNT状态,但不会被打开。表明需要介质恢复,
将会产生一个错误。要顺利打开数据库,你应该采取的表空间出备份模式,您可以通过发出ALTER TABLESPACE 数据1 END
BACKUP语句,或者您也可以发出ALTER DATABASE END BACKUP语句,将采取所有表中所有数
据文件的备份模式。所有其他选项都是不正确的。 DATA1表空间的备份模式中自动取出当实例中止,打开实例时, 或当实例安装。


0 2
原创粉丝点击