Get the App
SLTechnology News&Howtos  ›  Database  › 

Case Diagram Analysis of ORACLE RMAN difference Increment and Cumulative Increment

Shulou Source: shulou.com Published: 2022-05-31 15:07:36 09月29日 Update

This article mainly talks about "case diagram analysis of ORACLE RMAN difference increment and cumulative increment". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn the case diagram analysis of ORACLE RMAN difference increment and cumulative increment.

ORACLE RMAN backup-- A policy example diagram of differential increment and cumulative increment

The BACKUP command chooses Differential mode, that is, differential incremental backup, by default when it is not explicitly specified. However, from the point of view of recovery efficiency, Cumulative incremental backup performs better, after all, it does not need to read so many backup sets.

Note:

In versions prior to 10g, incremental backups can have more than n levels, from level 0, level 1, level 2. In this order up to level n (n is a positive integer less than or equal to 4).

In the 10g version, Oarcle's official documentation clearly states that incremental backups have only two levels of 0 and 1 (too many incremental levels don't make much sense), but when actually performing incremental operations, you can still specify multiple levels, up to a maximum of level 4 incremental backups.

The example figure for the 10g version of the 0BI difference and cumulative incremental backup strategy is as follows:

At this point, I believe you have a deeper understanding of the "case diagram analysis of ORACLE RMAN difference increment and cumulative increment". 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!

Tags: Increments backups differences instances levels analysis versions content multiple actual situation way strategy learning practical deeper maximum interest only command Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno MariaDB Redmi Apple MySQL Xiaomi