Enabling block change Tracking-10g new features ()

Source: Internet
Author: User

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.