Dear sirs,
I appreciate your valuable help with the following: how could I activate "block change tracking" and I would also like to know if this is a property of the databases or commvault.
Solved
Block Change Tracking
+8Best answer by Gowri Shankar
Hi
Block change tracking is a Oracle level configuration
For more detail please refer → https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E-50C703DC6FEB.htm
Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up.
You can enable block change tracking when the database is either open or mounted. This section assumes that you intend to create the block change tracking file as an Oracle Managed File in the database area, which is where the database maintains active database files such as data files, control files, and online redo log files.
Let us know in case of any other questions.
- Vaulter
- 218 replies
Hi
Believe you are referring to block change tracking with oracle agent backups.
This is a oracle level configuration which enhances the incremental backup performance.
For more detail please refer → https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E-50C703DC6FEB.htm
Let us know in case of any other questions.
Regards,
Gowri Shankar
+8
My question is what considerations should I have to enable "block change tracking" in oracle database policies.
- Vaulter
- 218 replies
- Answer
Hi
Block change tracking is a Oracle level configuration
For more detail please refer → https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E-50C703DC6FEB.htm
Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all data blocks to identify which blocks have changed, RMAN uses this file to identify the changed blocks that need to be backed up.
You can enable block change tracking when the database is either open or mounted. This section assumes that you intend to create the block change tracking file as an Oracle Managed File in the database area, which is where the database maintains active database files such as data files, control files, and online redo log files.
Let us know in case of any other questions.
1 person likes this
+1I have a question regarding this change. Once the "block change tracking" is enabled, I must first execute a full online copy?. I mention this since it was enabled and now when we execute it the speed is still slow.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.