This content has been marked as final. Show 10 replies
The two are mutually exclusive.
RECOVERY WINDOW specifies the age of backups that need to be retained.
REDUNDANCY specifies the number of backups that need to be retained.
Think about the case where you have a critical database that you backup
3 times a day. Your WINDOW has to be 14 days OR REDUNDANCY has to be 42 copies.
Recovery window of 14 days mean it will keep all 14 days backups as available and the older copies as obsolete.The OP mentioned backup once a day. With that in mind, typically backups are scheduled at the same time everyday. Therefore, with a RECOVERY WINDOW OF 14 DAYS, RMAN will require a backup sufficiently old enough to recover to the desired time. The backup from the 14th day wouldn't be old enough, therefore the 15 day old backup would be required.
We are backing up our database full backup once a week (on Monday) and 2 times of daily backup.
Is "CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS" good enough?
I am very confused about retention policy.
here is our parameters in RMAN
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup/db/ba
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/10.1.0/db_1/db