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;
Section: (none)
Explanation
Explanation/Reference:
Explanation:
You should use the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING USING FILE <path>;
statement. If OMF is configured in your database, then you need not specify the name of the block change
tracking file in the ALTER DATABASE statement. The file is automatically located in the directory specified
by the DB_CREATE_FILE_DEST parameter. In this scenario, OMF is not configured. Therefore, you must
specify the location of the block change tracking file in the statement. After you enable block change
tracking, RMAN uses the block change tracking file to determine the blocks the blocks that have changed
and should be backed up in an incremental backup. This improves the performance because RMAN does
not have to scan the entire datafiles during backup. RMAN backs up only the changed blocks and skips
the unchanged blocks.
The options stating that you should issue the ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING; or
the ALTER SYSTEM ENABLE BLOCK CHANGE TRACKING USING FILE <path>; statements are
incorrect. Each of these statements will generate an error because the block change tracking feature is
enabled at the database level, not at the system level.
The option stating that you should issue the ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
statement is incorrect because OMF is not configured in the database. If OMF is not configured, then you
must specify the location of the block change tracking file in the ALTER DATABASE ENABLE BLOCK
CHANGE TRACKING; statement.