161 Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENT
来源:互联网 发布:mysql 存储过程 丢失 编辑:程序博客网 时间:2024/04/28 02:39
Examine the following command used to perform incremental level 0 backup: RMAN>
BACKUP
INCREMENTAL LEVEL 0 DATABASE;
To enable the block change tracking, after the incremental level 0 backup you issued the following
command:
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE '/mydir/
rman_change_track.f';
To perform incremental level 1 cumulative backup, you issued the following command: RMAN>
BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which two statements are true in the above situation? (Choose two.)
A. The block change tracking data will be used only from the next incremental 0 backup.
B. The incremental backup will use change tracking data for accomplishing the backup.
C. The incremental backup will not use change tracking data for accomplishing the backup.
D. The block track file will scan all the blocks and create bitmap for all the blocks backed up in the level 0
backup.
Correct Answer: AC
Section: (none)
Explanation
Explanation/Reference:
Explanation:
http://www.pythian.com/documents/Pythian-oracle-block-change.pdf
After enabling change tracking, the first level 0 incremental backup still has to scan the entire datafile, as
the change tracking file does not yet reflect the status of the blocks. Subsequent incremental backup that
use this level 0 as parent will take advantage of the change tracking file.
When some a chunk needs to be marked dirty for the first time after incremental backup, version
information in bitmap extent headers (X$KRCFBH) is initialized - XFLAGS is set to 2, CURR_VERCNT and
CURR_VERTIME filled from datafile descriptor. If file had no changes since last incremental backup -
nothing is written to the bitmap.
There is no difference in handling different backup levels. Version is created in the same way whether its
level 0, level 1 or level 4 backup. By the way, it seems that Oracle 10g documentation officially mentions
only support for levels 0 and 1. However, I checked incremental backup levels up to 4 and they do work
(10.2.0.2).
Oracle Press 1Z0-053 Exam Guide, Chapter 4: Creating RMAN Backups
The first incremental level 0 backup reads every block in the datafile, and subsequent incremental level 1
backups use the block change tracking file. No reference to create bitmap found.
http://download.oracle.com/docs/cd/B19306_01/backup.102/b14192/bkup004.htm#i1032148
RMAN's change tracking feature for incremental backups improves incremental backup performance by
recording changed blocks in each datafile in a change tracking file. If change tracking is enabled, RMAN
uses the change tracking file to identify changed blocks for incremental backup, thus avoiding the need to
scan every block in the datafile.
Using change tracking in no way changes the commands used to perform incremental backups, and the
change tracking files themselves generally require little maintenance after initial configuration.
- 161 Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENT
- 49 You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DA
- 49 You enable block change tracking. You issue the following command: BACKUP INCREMENTAL LEVEL 0 DAT
- 77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES
- 183 Examine the following command that is used to duplicate a database on the same host: RMAN> RUN {
- Steps to perform for Rolling Forward a Physical Standby Database using RMAN Incremental Backup. (文档
- 62 You have enabled backup optimization in RMAN. You issue the following RMAN command to configure a
- RMAN incremental backup tips
- Rman incremental and acumulative backup
- 109 You want to take a complete database backup using RMAN. The backup should consist only the used
- Backup incremental level and scripts
- backup incremental level 1 database
- 86.View the Exhibit to examine the output for the CROSSCHECK BACKUP command. Which statement is true
- 188 Examine the following scenario: The target database instance is running. The most recent backup
- INCREMENTAL BACKUP
- why the redo log is not needed to backup in the RMAN backup?
- 10.Examine the following statement that is used to modify the constraint on the SALES table:
- 98 Consider the following scenario for your database: - Backup optimization is enabled in RMAN. - Th
- mysql-5.6.17源码调试
- 杭电-1304A Contesting Decision(结构体)
- 课题相关的资料汇总
- bzoj 3196 Tyvj 1730 二逼平衡树
- List简单升序,降序排列 linq
- 161 Examine the following command used to perform incremental level 0 backup: RMAN> BACKUP INCREMENT
- CentOS 6.5 安装使用iSCSI-Target
- nyoj 44 子串和 【简单dp】
- Android最新敲诈者病毒分析及解锁
- location.hash详解
- shell脚本编程流水笔记
- ROS下创建meta_package
- Linux下DIR,dirent,stat等结构体详解
- Nginx (一) 基础入门