I am somewhat new to RMAN, and have taken an Oracle class on it, but I am stumped on validating my backups when using level 0 and 1; in order to save space, I am considering doing a level 0 (full) incremental backup Sunday, level 1 differential backups Monday and Tuesday, and level 1 cumulative on Wednesday. Then leve1 1 differential backups Thursday and Friday, and level 1 cumulative on Saturday.
The thought was after a successful level 1 cumulative backup on Wednesday, I could delete the differential level 1 backups from Monday and Tuesday. So, on Wednesday, to verify before I do something drastic to test, I did a
RMAN> restore database validate;
And away it went, validating files; but it only looked at files from the level 0 Sunday backup.
I would have expected it to also validate at least the incremental level 1 backup from Wednesday.
So two questions:
- Is my strategy of deleting differential level 1 backups after a successful incremental level 1 backup valid?
- How can I test to ensure this is correct?