OCP-1Z0-053-V12.02-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

答案解析：

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 DATABASEstatement. The file is automatically located in the directory specified by

the DB_CREATE_FILE_DESTparameter. In this scenario, OMF is not configured. Therefore, you must specify

the location of the block change tracking file in the statement. 

You can enable block change tracking when the database is either open or mounted.

To enable block change tracking:

1. Start SQL*Plus and connect to a target database with administrator privileges.

2. Ensure that theDB_CREATE_FILE_DEST initialization parameter is set.

   SHOW PARAMETER DB_CREATE_FILE_DEST

   If the parameter is not set, and if the database is open, then you can set the parameter with the following form of the ALTER SYSTEM statement:

   ALTER SYSTEM SET

   DB_CREATE_FILE_DEST = '/disk1/bct/'

   SCOPE=BOTH SID='*';

3. Enable block change tracking.

   Execute the following ALTER DATABASE statement:

   ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;

   You can also create the change tracking file in a location that you choose yourself by using the following form of SQL statement:

   ALTER DATABASE ENABLE BLOCK CHANGE TRACKING

   USING FILE '/mydir/rman_change_track.f' REUSE;

   The REUSE option tells Oracle Database to overwrite any existing block change tracking file with the specified name.

官方参考：http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmbckba.htm#BRADV8125