[Lesson]9.3 example shows the difference between an Oracle Rman two library incremental backup

1 Example of differential increment experiment1.1 Differential Incremental backup

To demonstrate the effect of an incremental backup, we made some changes to the database after performing a 0 level backup.

Perform a 1-level differential incremental backup again:

Make the changes to the database again after performing a 1-level backup:

Perform a 1-level differential incremental backup again:

To view the current SCN, we delete the table:

This allows us to demonstrate the use of incremental backups to demonstrate the recovery of BAKTAB01 and BAKTAB02 tables.

1.2 Differential Incremental Recovery

To see if the table has been restored:

2 Cumulative Incremental Experiment Example2.1 Cumulative Incremental backup

First make a cumulative incremental backup of the database at level 0:

To demonstrate the effect of the cumulative incremental backup, we made some changes to the database after performing a 0 level backup.

Make a 1-level cumulative incremental backup of the database:

Make changes to the database once again:

Once again, make a 1-level cumulative incremental backup of the database:

Now that we have deleted the two tables, we can demonstrate the use of a cumulative incremental backup to recover the two tables, and then observe the process of cumulative incremental recovery:

2.2 Cumulative Incremental Recovery

To see if the table has been restored:

3 differences between the two

Variance Increment:

Cumulative increment:

From the above experiment, differential incremental and cumulative incremental backups are not significantly different, and the cumulative incremental backup feature is that when it is being backed up, it is going to look for incremental backups at a baseline point that is smaller than its own level, while a differential incremental backup is to find a datum point that is less than or equal to its own level for backup. In this experiment, the differential incremental backup recovery was used in the 1th level 0, 2 1 levels of 3 backup files (see figure, marked), and cumulative incremental backup only used 1 0 levels, a 1-level total of 2 backup files (see figure, marked).

Personally feel that in the actual build backup, unless the data volume backup is large, there is no need to be overly obsessed with which incremental backup technology to use.

For details, refer to the online information: http://blog.sina.com.cn/s/blog_48e13c9e01010wcz.html

[Lesson]9.3 example shows the difference between an Oracle Rman two library incremental backup