视频1 视频21 视频41 视频61 视频文章1 视频文章21 视频文章41 视频文章61 推荐1 推荐3 推荐5 推荐7 推荐9 推荐11 推荐13 推荐15 推荐17 推荐19 推荐21 推荐23 推荐25 推荐27 推荐29 推荐31 推荐33 推荐35 推荐37 推荐39 推荐41 推荐43 推荐45 推荐47 推荐49 关键词1 关键词101 关键词201 关键词301 关键词401 关键词501 关键词601 关键词701 关键词801 关键词901 关键词1001 关键词1101 关键词1201 关键词1301 关键词1401 关键词1501 关键词1601 关键词1701 关键词1801 关键词1901 视频扩展1 视频扩展6 视频扩展11 视频扩展16 文章1 文章201 文章401 文章601 文章801 文章1001 资讯1 资讯501 资讯1001 资讯1501 标签1 标签501 标签1001 关键词1 关键词501 关键词1001 关键词1501 专题2001
OCP试题解析之053-17CONFIGURECONTROLFILEAUTOBACKUPON
2020-11-09 14:52:26 责编:小采
文档


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条件。

下载本文
显示全文
专题