nerdexam
Oracle

1Z0-062 · Question #174

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

The correct answer is C. RMAN does not support backup and recovery of the change tracking file. D. The database clears the change tracking file and starts tracking changes again, after whole. The block change tracking file cannot be backed up or recovered by RMAN, and Oracle automatically clears and resets it after a whole database restore.

Performing Backup and Recovery

Question

To enable faster incremental backups, you enabled block change tracking for the database. Which two statements are true about the block change tracking file? (Choose two.)

Options

  • AMultiple change tracking files can be created for a database.
  • BThe change tracking file must be created after the first level 0 backup.
  • CRMAN does not support backup and recovery of the change tracking file.
  • DThe database clears the change tracking file and starts tracking changes again, after whole

How the community answered

(40 responses)
  • A
    3% (1)
  • B
    8% (3)
  • C
    90% (36)

Why each option

The block change tracking file cannot be backed up or recovered by RMAN, and Oracle automatically clears and resets it after a whole database restore.

AMultiple change tracking files can be created for a database.

Only one block change tracking file is permitted per database; attempting to create a second one will result in an Oracle error, as the feature is designed as a single-file mechanism.

BThe change tracking file must be created after the first level 0 backup.

The change tracking file can be created at any point while the database is open or mounted and does not depend on a prior level 0 backup existing; the subsequent incremental will simply behave as a level 0 until the tracker accumulates data.

CRMAN does not support backup and recovery of the change tracking file.Correct

RMAN does not back up or restore the block change tracking file; if the file is lost or corrupted, the DBA must disable change tracking with ALTER DATABASE DISABLE BLOCK CHANGE TRACKING and then re-enable it, causing the next incremental backup to scan all blocks.

DThe database clears the change tracking file and starts tracking changes again, after wholeCorrect

After a whole database restore and recovery, Oracle automatically clears the change tracking file and begins re-tracking changed blocks from scratch to ensure the tracking bitmap is consistent with the restored database state.

Concept tested: RMAN block change tracking file behavior and restrictions

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/making-database-backups.html

Topics

#Block change tracking#Incremental backups#RMAN#Recovery

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice