nerdexam
Oracle

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.

Performing Backup and Recovery

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)
  • D
    2% (1)
  • E
    2% (1)
  • F
    95% (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.

ARBAL

RBAL manages ASM disk group rebalancing operations and has no involvement in block change tracking.

BCKPT

CKPT (Checkpoint) writes checkpoint information to the control file and datafile headers, not to the change tracking file.

CSMON

SMON performs instance recovery and tablespace maintenance tasks, and plays no role in tracking changed blocks.

DPMON

PMON monitors and cleans up failed user processes and has no connection to the change tracking mechanism.

EMMON

MMON performs manageability tasks such as AWR snapshots and threshold alerts, not change tracking writes.

FCTWRCorrect

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.

GDBWR

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

#Block Change Tracking#Incremental Backups#Background Processes

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice