Block chage tracking is a new feature of Oracle10g. The block change tracking process records the changes in data blocks since the last 0-level backup and records the information in the tracking file. RMAN uses this file to determine the changed data to be backed up in the Incremental backup. This greatly improves the backup performance and speed. RMAN can no longer scan the entire file to find the changed data.
To enable tracing, run the following command:
Alter database enable block change tracking using
File 'd: \ backup \ Paul. Log ';
You can query the current settings:
Select filename, status, bytes from V $ block_change_tracking;
Disable tracing:
Alter database disable block change tracking;
The following comparison of the time when the block change tracking feature is enabled and the block change tracking feature is not enabled:
Enable alter database enable block change tracking;
RMAN> Backup incremental level 0 format = 'd: \ backup \ % U' database;
Start backup in month-08
Use channel ora_disk_1
Channel ora_disk_1: starts the compressed incremental level 0 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set,
Enter the data file fno = 00001 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ System_422b1m98_.dbf
Enter the data file fno = 00002 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Undotbs1_422b1mc7_.dbf
Enter the data file fno = 00003 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Sysaux_422b1mfo_.dbf
Enter the data file fno = 00005 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Test_422q3d0h_.dbf)
Enter the data file fno = 00006 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Bftbs_43dg9qnz_.dbf
Enter the data file fno = 00004 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Users_422b1mnz_.dbf
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0fjhbabt_1_1 mark = tag20080526t113106 annotation = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 01: 25;
Channel ora_disk_1: starts the compressed incremental level 0 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
The backup set includes the current control file
Include the current spfile in the backup set
Channel ora_disk_1: Starting segment 1 at month-08, month-08)
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0gj1_eq_1_1 mark = tag20080526t113106 annotation = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 17
Backup completed in month-08
RMAN> Backup incremental Level 1 format = 'd: \ backup \ % U' database;
Start backup in month-08
Use channel ora_disk_1
Channel ora_disk_1: Start the compressed incremental Level 1 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
Enter the data file fno = 00001 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
System_422b1m98_.dbf
Enter the data file fno = 00002 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Undotbs1_422b1mc7_.dbf
Enter the data file fno = 00003 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Sysaux_422b1mfo_.dbf
Enter the data file fno = 00005 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
F0_test_422q3d0h _. DBF. C! I + x3x d [I j
Enter the data file fno = 00006 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Enter the data file fno = 00004 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Users_422b1mnz_.dbf
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0hjhbagr_1_1 mark = tag20080526t113346 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 03
Channel ora_disk_1: Start the compressed incremental Level 1 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
The backup set includes the current control file
Include the current spfile in the backup set
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0ijhbagu_1_1 mark = tag20080526t113346 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 04
Backup completed in month-08
Level 1 backup time is 7 seconds
Disable alter database disable block change tracking;
RMAN> Backup incremental level 0 format = 'd: \ backup \ % U' database;
Start backup in month-08
Use channel ora_disk_1
Channel ora_disk_1: starts the compressed incremental level 0 data file backup set
Channel ora_disk_1: Specifies the data file itpub in the backup set.
Enter the data file fno = 00001 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
System_422b1m98_.dbf
Enter the data file fno = 00002 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Undotbs1_422b1mc7_.dbf
Enter the data file fno = 00003 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Sysaux_422b1mfo_.dbf
Enter the data file fno = 00005 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Test_422q3d0h_.dbf
Enter the data file fno = 00006 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Enter the data file fno = 00004 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0j1_kk_1_1 mark = tag20080526t113548 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 55
Channel ora_disk_1: starts the compressed incremental level 0 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
The backup set includes the current control file
Include the current spfile in the backup set
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0kjhbamb_1_1 mark = tag20080526t113548 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 04
Backup completed in month-08
RMAN> Backup incremental Level 1 format = 'd: \ backup \ % U' database;
Start backup in month-08
Use channel ora_disk_1
Channel ora_disk_1: Start the compressed incremental Level 1 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
Enter the data file fno = 00001 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Enter the data file fno = 00002 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
Enter the data file fno = 00003 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Sysaux_422b1mfo_.dbf
Enter the data file fno = 00005 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Test_422q3d0h_.dbf
Enter the data file fno = 00006 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Bftbs_43dg9qnz_.dbf
Enter the data file fno = 00004 name = D: \ oracle \ product \ 10.2.0 \ oradata \ orcl \ datafile \ o1_mf
_ Users_422b1mnz_.dbf
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0lj1_ou_1_1 mark = tag20080526t111_6 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 55
Channel ora_disk_1: Start the compressed incremental Level 1 data file backup set
Channel ora_disk_1: Specifies the data file in the backup set.
The backup set includes the current control file
Include the current spfile in the backup set
Channel ora_disk_1: Starting segment 1 from April 8 to April 8
Channel ora_disk_1: Completed segment 1 in month-08
Segment handle = D: \ backup \ 0mj1_qm_1_1 mark = tag20080526t111_6 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 03
Backup completed in month-08
RMAN>
The backup time for level 1 backup is 58 seconds, and I have not made any changes to the database data.
This performance is obvious.