You can enable block change tracking when the database is either open or mounted.
To enable block change tracking:
-
Start SQL*Plus and connect to a target database with administrator privileges.
-
Ensure that the DB_CREATE_FILE_DEST initialization parameter is set.
SHOW PARAMETER DB_CREATE_FILE_DESTIf 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 SETDB_CREATE_FILE_DEST = '/disk1/bct/'SCOPE=BOTH SID='*'; -
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 TRACKINGUSING 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博客 ” ，链接：https://blog.itpub.net/29196873/viewspace-1129422/ ，如需转载，请注明出处，否则将追究法律责任。
