Which statement correctly describes the change tracking writer (CTWR) background process?
A.
It keeps track of changes in the background processes.
B.
It records the system change number (SCN) in the control file.
C.
It writes audit records for user changes to the change tracking file.
D.
It records any changes to the listened configuration in the listener.ora file.
E.
It records any changes to the database parameters in the change tracking file.
F.
It records the physical location of all the changes that are made to the database in the change
tracking file.
Explanation:
Subject: New Background Processes In 10g
Doc ID: Note :268197.1 Type: HOWTO
Last Revision Date: 18-JUL-2005 Status:
PUBLISHED
CTWR
=====
This is a new process Change Tracking Writer (CTWR) which works with the new block changed
tracking features in 10g for fast RMAN incremental backups.
Subject: RMAN 10g : How To Size the Block Change Tracking File Doc ID: Note:306112.1 Type:
How To Last Revision Date: 22-MAY-2005 Status: REVIEWED
The information in this document applies to:
Oracle Server – Enterprise Edition – Version: 10.1.0.0 to 10.2.0.0 Information in this documentapplies to any platform.
Goal
This is a clarification of the documentation for sizing the Block Change Tracking File.
Block Change Tracking is used to optimize incremental backups. A new file is introduced:
– Changed blocks are tracked by the CTWR background process as redo is generated
– Database backups automatically use the change tracking file Sizing of this file is important, and
even though you can use V$BLOCK_CHANGE_TRACKING view to monitor the usage, it may in
some cases not be easy to change the size, ie when using raw devices.