OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON
来源:互联网 发布:淘宝店铺宝贝数量 编辑:程序博客网 时间:2024/06/11 13:51
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
正确答案: AD
【解析】
此处的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 theBACKUP
command.Back up data file
1
, because RMAN automatically includes the control file and server parameter file in backups of data file1
A、rman执行backup命令;
D、数据库结构发生改变,如:新增或删除表空间操作。11g有控制文件自动延迟备份特性,详细参考:
http://blog.chinaunix.net/uid-22948773-id-3347991.html
E、手动备份控制文件,rman命令下执行备份命令 指定include current controlfile条件。
- OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON
- CONFIGURE CONTROLFILE AUTOBACKUP ON/OFF;
- CONFIGURE CONTROLFILE AUTOBACKUP ON/OFF;
- CONFIGURE CONTROLFILE AUTOBACKUP ON的作用
- CONTROLFILE AUTOBACKUP ON 间接导致数据库hang
- OCP试题解析之053-16 MEMORY_TARGET
- 如何使用 restore controlfile from autobackup ?
- 如何使用 restore controlfile from autobackup
- OCP试题解析之053-61 RMAN set command id to
- OCP试题解析之052-- DROP PROFILE app_user
- OCP试题疑问集-053
- ocp试题之视图的DML操作
- OCP试题
- controlfile
- controlfile
- Configure OpenVPN on Ubuntu
- Configure Hotspot on MAC
- Configure PPPoE on CentOS7
- HDU1200 To and Fro
- iOS_25_彩票骨架搭建+导航栏适配
- Linux程序设计笔记(第4章 Linux环境)
- 设置可编辑
- javascript学习笔记
- OCP试题解析之053-17 CONFIGURE CONTROLFILE AUTOBACKUP ON
- 第十章 10.5.3节练习 & 10.6节练习
- 【LeetCode】Linked List Cycle II
- 音效和音乐播放要用到的方法
- 把质量控制工作往前推进(1)——安装sonarqube
- Boost Asio 1.56 学习之同步定时器
- eclipse中格式化代码快捷键Ctrl+Shift+F失效的解决办法
- Loadrunner中集合点详解
- Android隐藏输入法键盘(hideSoftInputFromInputMethod没有效果)