Fast incremental backups using the block change tracking (BCT) file
The algorithm behind the incremental backups searches for those modified blocks whose block System Change Number (SCN) is higher than the last incremental level backup's Incremental Start SCN. Though it's a very good workaround to skip those unchanged blocks which we don't need to back up again now, to find the list of the candidate changed blocks, it would be required to read the entire data file even when the backup type is going to be an incremental backup. That's why although the incremental backups are faster than the comparative full backups, they are not really fast enough!
Note
An SCN within Oracle database is the internal representation of time. Using an SCN, a database ...
Get Oracle Database 12c Backup and Recovery Survival Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
