OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含1984字,纯文字阅读大概需要3分钟。
内容图文
![OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON](/upload/InfoBanner/zyjiaocheng/562/13089575d86049c6932ce53b906a27f6.jpg)
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
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
正确答案: ADE
【解析】
此处的atuobackup on 指:CONFIGURE CONTROLFILE AUTOBACKUP ON。
此时有2种情况会触发自动备份控制文件:
You can back up the control file when the database is mounted or open. RMAN uses a snapshot control file to ensure a read-
consistent version. If theCONFIGURE CONTROLFILE AUTOBACKUP command is set to ON (by default it is OFF), then RMAN automatically
backs up the control file and server parameter file after every backup and after database structural changes. The control file
autobackup contains metadata about the previous backup, which is crucial fordisaster recovery
手动备份控制文件:
If the autobackup feature is not set, then you must manually back up the control file in one of the following ways:
Run BACKUP CURRENT CONTROLFILE .
Include a backup of the control file within any backup by using the INCLUDE CURRENT CONTROLFILE option of the BACKUP command.
Back up data file 1, because RMAN automatically includes the control file and server parameter file in backups of data file 1
A、rman执行backup命令;
D、数据库结构发生改变,如:新增或删除表空间操作。11g有控制文件自动延迟备份特性,详细参考:
http://blog.chinaunix.net/uid-22948773-id-3347991.html
E、手动备份控制文件,rman命令下执行备份命令 指定INCLUDING CONTROLFILE条件。
内容总结
以上是互联网集市为您收集整理的OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON全部内容,希望文章能够帮你解决OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。