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
document applies 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.