首页 > 代码库 > OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON

OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON

17.You configure AUTOBACKUP to ON in an RMAN session. When will RMAN back up the control file?

(Choose all that apply.)
A. When you run an RMAN BACKUP command
B. When you run an RMAN ALLOCATE command
C. When you add or drop a table in the SYSTEM tablespace
D. When you change the physical structure of the database, such as dropping a tablespace

E. When you specify the INCLUDING CONTROLFILE clause


原答案:A  明显错误!

正确答案:  DE


【解析】

此处的atuobackup on 指:CONFIGURE CONTROLFILE AUTOBACKUP ON

此时有2种情况会触发自动备份控制文件:

1、数据库结构发生改变,如:新增或删除表空间操作。11g有控制文件自动延迟备份特性,详细参考:

  http://blog.chinaunix.net/uid-22948773-id-3347991.html

2、rman命令下执行备份命令 指定INCLUDING CONTROLFILE条件。




OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON