Im on an 11G database(soon to be 12). Currently we do a full rman backup 2 times a day with a retention policy recovery window of 1 day. The problem is we are running out of disk space and backups are taking 2 hrs, so 4 hrs of extra load a day on our system. I am trying to get scripts changed so that we can move to an incremental backup procedure. I would like to have a weekly procedure of a level 0 backup done on monday and then level 1 cumulative backups done tues-sun(i dont want differentials). Couple things im unsure of is how to handle the archive logs and the retention policy. I only want 1 full(level 0) backup plus the weeks incrementals on disk at a time.
Will having a recovery window of 7 days do what im after or should it be redundancy of 1.(Not sure how redundancy is handled with incrementals.) and am i handling the archive logs correctly?
This is what i have come up with for my 2 scripts. First is ran every monday and the second is ran every tues-sun.
--monday script--
configure controlfile autobackup on;
configure backup optimization on;
configure default device type to disk;
configure channel 1 device type disk format '/backup/RMAN/weekly_%u';
show all;
REPORT OBSOLETE RECOVERY WINDOW OF 7 DAYS; or REPORT OBSOLETE REDUNDANCY 1;
Delete obsolete;
BACKUP incremental level 0 database plus archivelog delete all input;
sql 'alter system archive log current';
backup archivelog all;
delete archivelog all backed up 1 times to disk;
exit;
--tues-sun script--
configure controlfile autobackup on;
configure backup optimization on;
configure default device type to disk;
configure channel 1 device type disk format '/backup/RMAN/daily_%u';
show all;
BACKUP incremental level 1 cumulative database plus archivelog delete all input;
sql 'alter system archive log current';
backup archivelog all;
delete archivelog all backed up 1 times to disk;
exit;
One more thing can someone point me in the correct direction on how to handle recovery and restore with incremental backups. Is it the same as doing a recovery from a full rman backup?
Thanks!