nerdexam
Exams1Z0-060Questions#102
Oracle

1Z0-060 · Question #102

1Z0-060 Question #102: Real Exam Question with Answer & Explanation

The correct answer is A: Backup change tracking will sometimes reduce I/O performed during cumulative incremental backups.. A: In a cumulative level 1 backup, RMAN backs up all the blocks used since the most recent level 0 incremental backup. E: 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 fil

Question

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?

Options

  • ABackup change tracking will sometimes reduce I/O performed during cumulative incremental backups.
  • BThe change tracking file must always be backed up when you perform a full database backup.
  • CBlock change tracking will always reduce I/O performed during cumulative incremental backups.
  • DMore than one database block may be read by an incremental backup for a change made to a single block.
  • EThe incremental level 1 backup that immediately follows the enabling of block change tracking will not read

Explanation

A: In a cumulative level 1 backup, RMAN backs up all the blocks used since the most recent level 0 incremental backup. E: 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. * An incremental level 0 backup backs up all blocks that have ever been in use in this database.

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice