1Z0-062 · Question #51
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
The correct answer is F. CTWR. The CTWR (Change Tracking Writer) is the dedicated background process that records changed block locations to the change tracking file, enabling faster RMAN incremental backups.
Question
You enabled block change tracking for faster incremental backups in your database. Which background process writes to the change tracking file?
Options
- ARBAL
- BCKPT
- CSMON
- DPMON
- EMMON
- FCTWR
- GDBWR
How the community answered
(41 responses)- D2% (1)
- E2% (1)
- F95% (39)
Why each option
The CTWR (Change Tracking Writer) is the dedicated background process that records changed block locations to the change tracking file, enabling faster RMAN incremental backups.
RBAL manages ASM disk group rebalancing operations and has no involvement in block change tracking.
CKPT (Checkpoint) writes checkpoint information to the control file and datafile headers, not to the change tracking file.
SMON performs instance recovery and tablespace maintenance tasks, and plays no role in tracking changed blocks.
PMON monitors and cleans up failed user processes and has no connection to the change tracking mechanism.
MMON performs manageability tasks such as AWR snapshots and threshold alerts, not change tracking writes.
CTWR is the Change Tracking Writer background process introduced specifically to support block change tracking. When enabled, CTWR continuously records the physical locations of all modified blocks since the last backup in the change tracking file, allowing RMAN incremental backups to read only those changed blocks rather than scanning entire datafiles.
DBWR (Database Writer) writes dirty buffers from the buffer cache to datafiles, not to the change tracking file.
Concept tested: Block change tracking CTWR background process role
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/bradv/using-block-change-tracking-with-rman.html
Topics
Community Discussion
No community discussion yet for this question.