OCP 1Z0 053 59

59.You have not configured Oracle Managed Files (OMF) in your database. You do not want to scan the 
entire datafile every time an incremental backup is performed. You decide to enable the block change 
tracking feature. Which statement should you use to enable the block change tracking feature? 
A. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING; 
B. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>; 
C. ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>; 
D. ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING; 
Answer: C 


http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_1004.htm#SQLRF52548

BLOCK CHANGE TRACKING Clauses

The block change tracking feature causes Oracle Database to keep track of the physical locations of all database updates on both the primary database and any physical standby database. You must enable block change tracking on each database for which you want tracking to be performed. The tracking information is maintained in a separate file called the block change tracking file. If you are using Oracle Managed Files, then Oracle Database automatically creates the block change tracking file in the location specified by DB_CREATE_FILE_DEST. If you are not using Oracle Managed Files, then you must specify the change tracking filename. Oracle Database uses change tracking data for some internal tasks, such as increasing the performance of incremental backups. You can enable or disable block change tracking with the database either open or mounted, in either archivelog or NOARCHIVELOG mode.

ENABLE BLOCK CHANGE TRACKING This clause enables block change tracking and causes Oracle Database to create a block change tracking file.

• Specify USING FILE 'filename' if you want to name the block change tracking file instead of letting Oracle Database generate a name for it. You must specify this clause if you are not using Oracle Managed Files.

• Specify REUSE to allow Oracle Database to overwrite an existing block change tracking file of the same name.

DISABLE BLOCK CHANGE TRACKING Specify this clause if you want Oracle Database to stop tracking changes and delete the existing block change tracking file.

http://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_1004.htm#SQLRF52570

Enabling and Disabling Block Change Tracking: Examples The following statement enables block change tracking and causes Oracle Database to create a block change tracking file named tracking_file and overwrite the file if it already exists:

ALTER DATABASE
  ENABLE BLOCK CHANGE TRACKING
    USING FILE 'tracking_file' REUSE;

The following statement disables block change tracking and deletes the existing block change tracking file:

ALTER DATABASE
  DISABLE BLOCK CHANGE TRACKING;