oracle incremental backup is taking longer time to finish , upon the checking the event we got the event says to enable the block change tracking, we have some dependencies to enable it,
is there any way to speed up the incremental backup or better to run full backup daily.
Best answer by Tanuj Balani
Hello Ajal,
This change of activating the Block Change Tracking on Oracle side, will definitely improve the DB backup and restore performance.
By enabling this option in Oracle, Oracle is able to keep track which blocks are actually changed, that optimizing the incremental backup and speed up the process. Without this option, the backup would traverse all the blocks just to backup the changes. On smaller less busy databases, this might not be needed, but if performance is impacted on the Oracle level, then this is option is recommended to be applied.
Here is the documentation from Oracle
https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E-50C703DC6FEB.htm
Hello Ajal,
I am not aware of any way to improve the incremental here as RMAN needs to read every block in the database to see if it was changed since the last full (level=0) backup.
I’d strongly suggest to enable “change block tracking” asap to solve this.
Another option is to not run incremental anymore (level > 1) and just run full and redo log backups.
Regards,
Mike
Hello Ajal,
This change of activating the Block Change Tracking on Oracle side, will definitely improve the DB backup and restore performance.
By enabling this option in Oracle, Oracle is able to keep track which blocks are actually changed, that optimizing the incremental backup and speed up the process. Without this option, the backup would traverse all the blocks just to backup the changes. On smaller less busy databases, this might not be needed, but if performance is impacted on the Oracle level, then this is option is recommended to be applied.
Here is the documentation from Oracle
https://docs.oracle.com/database/121/ADMQS/GUID-3BAA0D48-CA35-4CD7-810E-50C703DC6FEB.htm
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
