I am making a backup plan for a 24/7 database instance. They want to be able to go back upto month, so data has to be archived for a month. I need some advice/suggestions as to what I am thinking is right.
As there is not enough space on the disk for even one full backup everything has to backed up to the tape.
Now here is what I planned:
Full online backups on Sunday.
Archivelog backups on SUnday(delete from disk).
Cum Incre. backups level 2 from Monday to Wednesday.
Cum. Incremental backup level 1 on Thursday.
Cum. Incre. backup level 2 on Fri and Sat.
Now from what I understand if I need to recover the database on Sat, I will need Full backup from Sunday, incr backup from Thursday and incr backup from Friday.
Is my understanding right as it contradicts with what I read somewhere that if i use cum. backups I will need to use only 1 incr backup at any point in time?
I don't generate too many archivelogs and have enough space currently to keep one week in disk, so I am backing it up only on Sunday. My logic was that I will have most of them on disk when I need to apply which will make the recovery faster, is that right??