Shulou(Shulou.com)05/31 Report--

The main content of this article is to explain "what is the difference between the incremental backup of the two Oracle RMAN libraries". Interested friends may wish to take a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the difference between the incremental backups of the two Oracle RMAN libraries?"

1 differential incremental experiment example 1.1 differential incremental backup

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

Perform another level 1 differential incremental backup:

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

Perform another level 1 differential incremental backup:

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

Check to see if the table has been restored:

2 Cumulative incremental lab example 2.1 Cumulative incremental backup

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

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

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

Make changes to the database again:

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

Now that we have deleted the two tables, we can demonstrate using cumulative incremental backups to restore the two tables, and then observe the cumulative incremental recovery process:

2.2 cumulative incremental recovery

To see if the table has been restored:

3The difference between the two.

Difference increment:

Cumulative increment:

From the above experimental comparison, the difference between differential incremental backup and cumulative incremental backup is not very big. The characteristic of cumulative incremental backup is that when backing up, it needs to find a reference point smaller than its own level for incremental backup, while differential incremental backup is to find a reference point that is less than or equal to its own level for backup. In this experiment, the first level 0 and two level 1 backup files are used in differential incremental backup recovery (see figure, marked), while cumulative incremental backup only uses one level 0, one level 1 and two backup files (see figure, marked).

Personally, I think that in the actual backup generation, unless the amount of data backup varies greatly, there is no need to worry too much about which incremental backup technology to use.

At this point, I believe you have a deeper understanding of "what is the difference between the incremental backups of the two Oracle RMAN libraries". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.