Oracle Database 12c: Installation and Administration — Question 223

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.)

Answer options

• A. Multiple change tracking files can be created for a database.
• B. The change tracking file must be created after the first level 0 backup.
• 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 database restore and recovery operations.

Correct answer: C, D

Explanation

Option C is correct because RMAN does not back up the change tracking file, which is why it isn't included in backups. Option D is also accurate as the database indeed clears the change tracking file after a full restore and recovery, necessitating a new tracking cycle. Options A and B are incorrect; multiple change tracking files cannot be created, and the tracking file creation does not depend on a level 0 backup.