ocp-043 DB_CREATE_FILE_DEST

A50
You are managing an Oracle Database 10g database that uses Oracle Managed Files (OMF). You enabled the block change tracking feature for the database. Which statement regarding the change tracking file is true?
A. One block change tracking file is created for each data file. By default, the file is created in DB_CREATE_FILE_DEST.
B. One block change tracking file is created for each data file. By default, the file is created in BACKGROUND_DUMP_DEST.
C. One block change tracking file is created for the database. By default, the file is created in DB_CREATE_FILE_DEST.
D. One block change tracking file is created for the database. By default, the file is created in BACKGROUND_DUMP_DEST.

Answer: C

block change tracking

A database option that causes Oracle to track datafile blocks affected by each database update. The tracking information is stored in a new type of file called the change tracking file. When block change tracking is enabled, RMAN uses the record of changed blocks from the change tracking file to improve incremental backup performance by only reading those blocks known to have changed, instead of reading datafiles in their entirety.

Setting the DB_CREATE_FILE_DEST Initialization Parameter

Include the DB_CREATE_FILE_DEST initialization parameter in your initialization parameter file to identify the default location for the database server to create:

• Datafiles

• Tempfiles

• Redo log files

• Control files

• Block change tracking files

You specify the name of a file system directory that becomes the default location for the creation of the operating system files for these entities. The following example sets /u01/oradata as the default directory to use when creating Oracle-managed files:

DB_CREATE_FILE_DEST = '/u01/oradata'

DB_CREATE_FILE_DEST

Property	Description
Parameter type	String
Syntax	DB_CREATE_FILE_DEST = directory | disk group
Default value	There is no default value.
Modifiable	ALTER SESSION, ALTER SYSTEM
Basic	Yes