enable block change tracking

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 the DB_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.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29196873/viewspace-1129422/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29196873/viewspace-1129422/