Explore RMAN_05 Incremental Backup in Oracle

What is Incremental backup? There are two types of Incremental Backup: DifferentialBackup and CumulativeBackup. Use RMAN to create a backup

What is Incremental Backup? There are two types of Incremental Backup: Differential Incremental Backup and CumulativeBackup. Use RMAN to create a backup

In the previous blog posts, I mentioned consistency backup and non-Consistency backup for databases. They all belong to full backup and data backup. Each backup is to back up all blocks, today we will talk about Incremental backup, which can effectively save storage space and the time required for backup.

1What is Incremental backup?

What is Incremental backup? There are two types of Incremental Backup: Differential Incremental backup.(Differential Backup)Backup and accumulative Increment(CumulativeBackup)Backup. UseRMANWhen a backup set is created, all data blocks of the backup data file are used by default. This backup is also called a full backup, while Incremental Backup only backs up the changed data blocks since the last backup. You can useRMANIncremental backup is used to back up data files, tablespaces, and databases, while minimizing backup files.

Related reading:

Exploring the RMAN_01 concept of Oracle

Explore the basic use of RMAN_02 in Oracle

Explore Oracle-based RMAN_03 non-consistent backup

Explore Oracle-based RMAN_04 non-consistent backup

Explore RMAN_05 Incremental Backup in Oracle

Exploring Oracle's RMAN_06 backup policy

2Differential Incremental Backup:

Differential Incremental Backup level1Back up the latest Incremental Backup (differential incremental backup and cumulative incremental backup) changed data blocks. Level1Differential Incremental backup,RMANBackup at the last level of execution1The changed data blocks after Incremental backup.1Backup, backup self-execution level0Data blocks that will change in the future.0,RmanCopy all data blocks that have changed since the file is created. Otherwise, execute a level0. For incremental differential backup, see.

Execute one level on Sunday0Incremental backup. The execution level on Monday and Saturday is1Differential Incremental Backup refers to the data block that has changed since the previous backup.

()

3Cumulative Incremental Backup:

Cumulative Incremental Backup refers to the backup from the nearest level0Data blocks changed since the backup. Cumulative Incremental Backup can reduce the recovery time. Shows the cumulative incremental backup.

()

Medium, the database is executed on Sunday0. The execution level from Monday to Saturday is1. The arrows show that the cumulative incremental backup is at the backup level.0Data Block modified since. Accumulative incremental backup increases the backup time. However, because data needs to be restored from fewer backup sets during recovery, accumulative Incremental Backup will save more time than differential incremental backup.