Block change tracking is a function provided from Oracle 10 Gb. It is disabled by default in the system.
When this feature is enabled, the relevant information is recorded in the file whenever the data block changes.
In this way, when RMAN performs Incremental backup, you do not need to completely traverse the entire data file and find the data block to be backed up.
This greatly improves the backup efficiency.
1. Confirm the function status
SQL> desc v $ block_change_tracking;
Name
----------------------------------
STATUS
FILENAME
BYTES
SQL>
SQL> select * from v $ block_change_tracking; // default disabled
STATUS FILENAME BYTES
--------------------------------------------
DISABLED
2. Enable this function
The file name must be specified in 11g.
SQL> alter database enable block change tracking using file 'e: \ app \ oraclebase \ oradata \ orcl \ rman \ block_change_tracking.log ';
The default file name exists in 10 Gb. Use the following statement.
SQL> alter database enable block change tracking;
3. disable this function
SQL> alter database disable block change tracking;