Which three statements are true?

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE` /mydir/rman_change_track.f’;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

You performed an incremental level 0 backup of a database:
RMAN > BACKUP INCREMENTAL LEVEL 0 DATABASE;
To enable block change tracking after the incremental level 0 backup, you issued this command:
SQL > ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE` /mydir/rman_change_track.f’;
To perform an incremental level 1 cumulative backup, you issued this command:
RMAN> BACKUP INCREMENTAL LEVEL 1 CUMULATIVE DATABASE;
Which three statements are true?

A.
Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.

B.
The change tracking file must always be backed up when you perform a full database backup.

C.
Block change tracking will always reduce I/O performed during cumulative incremental backups.

D.
More than one database block may be read by an incremental backup for a change made to a single
block.

E.
The incremental level 1 backup that immediately follows the enabling of block change tracking will not
read the change tracking file to discover changed blocks.

Explanation:
Oracle Block Change Tracking
Once enabled; this new 10g feature records the modified since last backup and stores the log of it in a
block change tracking file using the CTW (Change Tracking Writer) process. During backups RMAN uses
the log file to identify the specific blocks that must be backed up. This improves RMAN’s performance as it
does not have to scan whole datafiles to detect changed blocks. Logging of changed blocks is performed
by the CTRW process which is also responsible for writing data to the block change tracking file.
Note:
* An incremental level 0 backup backs up all blocks that have ever been in use in this database.



Leave a Reply 1

Your email address will not be published. Required fields are marked *