Backup Performance via Block Change Tracking | Oracle RMAN ( Recovery Manager ) Backup Tutorials -7

Hi,

I will continue to tell you about the RMAN (Recovery Manager) tool in this seventh article of my tutorial series .

Oracle RMAN2

 

 

Read Older articles of my rman backup tutorial series before this article with following links.

https://ittutorial.org/2019/03/25/oracle-rman-recovery-manager-backup-tutorials-1/

https://ittutorial.org/2019/03/25/oracle-rman-recovery-manager-backup-tutorials-2/

https://ittutorial.org/2019/03/25/oracle-rman-recovery-manager-backup-tutorials-3/

https://ittutorial.org/2019/03/26/oracle-rman-recovery-manager-backup-tutorials-4/

https://ittutorial.org/2019/03/26/oracle-rman-recovery-manager-backup-tutorials-5/

https://ittutorial.org/2019/03/26/oracle-rman-recovery-manager-backup-tutorials-6/

 

 

Block Change Tracking: There is a serious performance problem in case of incremental backup. Because All datafiles are scanned and changing blocks are determined while taking a incremental backup. This performance problem has been fixed with Oracle 10g. With Oracle 10g, changed blocks are written to a file and this backup file is used in incremental backup, a significant performance increase has been achieved in this way. This file is called the Change Tracking File.

Block change tracking

We can enable this feature as follows.

[oracle@MehmetSalih ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon Mar 25 17:37:18 2019
Version 19.2.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.2.0.0.0

SQL> select status from v$block_change_tracking;
STATUS
----------
DISABLED   SQL> alter database enable block change tracking using file '/BACKUP/rman_change_tracking_file.f' reuse;

When we enable this feature as above, the blocks that are changed after Full backup will now be written to /BACKUP/rman_change_tracking_file.f. This means that when incremental backup is taken, RMAN should read this file instead of scanning all datafiles one by one. This means a significant performance gain for incremental backup operations. We can disable this feature with the following command.

SQL> ALTER DATABASE DISABLE BLOCK CHANGE TRACKING;   

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

One comment

  1. goutham keathireddy

    Thanks Salih Deveci for sharing good doc on rman. please keep posting doc on oracle related.

Leave a Reply

Your email address will not be published. Required fields are marked *