incremental backups using retention policy redundancy 1
PktAcesJan 19 2012 — edited Jan 20 201210.2.0.5
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
using a backup policy of running a level 0 on sunday night and a level 1 every other night using above configs. I also have an archivelog backup job that runs every 30 minutes. the details of the scripts are below.
level_0.cmd
backup incremental level 0 database plus archivelog delete all input;
delete noprompt obsolete;
level_1.cmd
backup incremental level 1 database tag = 'level_1' plus archivelog delete all input;
delete noprompt obsolete;
archivelog.cmd
backup archivelog all delete input;
I have a couple questions about limitations with this policy.
On a Friday is it possible to restore to a point in time from the Monday before?
If the following change is made, is it still possible?
CONFIGURE RETENTION POLICY TO WINDOW OF 2 DAYS;
what is the differences in what is kept in the two different policies? just the datafile pieces? archivelogs? controlfiles?
Thanks