Get the App
SLTechnology News&Howtos  ›  Database  › 

The difference between Oracle rman backup retention Policy Redundancy and recovery window

Shulou Source: shulou.com Published: 2022-06-01 13:16:11 10月03日 Update

RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 7;

RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

The two backup retention policies are mutually exclusive, with the later configured overriding the former.

Understanding:

Redundancy can be understood as a physical policy, which is easy to understand is to set it to have several backups.

Recovery Window can be understood as a logical policy. If it is set to 7 days, it will ensure that the backups required for recovery to 7 days are available at any point in time.

The specific effect depends on your specific backup strategy. For example, if you backup once a day, then Redundancy=7 can be restored to 7 days.

One is considered quantitatively (redundancy)

A thing is considered in terms of days (recovery window)

If you backup 7 times a day and use Redundancy=7, it is impossible to restore it to the day before yesterday.

window is time-based, a window of time beyond which delete obsolete runs will be deleted.

redundancy means redundancy, beyond which redundancy will be deleted as an expired backup when delete obsolete is run

Tags: Backup time policy redundancy operation window again number of days that is meaning effect quantity time physics logic guarantee configuration Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno NVidia Xiaomi Shulou Technology Microsoft Linux