I have done the following steps:
- Backed up database with INCREMENTAL LEVEL 0
Delete INCREMENTAL LEVEL 0 backup without telling controlfile. So deleted it by hand. And did not make crosscheck.
Backed up database with INCREMENTAL LEVEL 1(without making crosscheck). How surprising it may be, log showed me that INCREMENTAL LEVEL 1 was successfully done.
Note, I have no INCREMENTAL LEVEL 0 backup, but controlfile doesn't know it. I have just INCREMENTAL LEVEL 1.
I tried to restore database with this backup but of course couldn't. It was telling me that no backup of datafile 1-5 found...
If controlfile had known about EXPIRED backups , then INCREMENTAL LEVEL 1 backup first would do INCREMENTAL LEVEL 0 and after-that INCREMENTAL LEVEL 1.
How to avoid this situation. Do I have to use chrosscheck in my backup script? Or set recovery window in RMAN?
I have Oracle 11g database. Backup is taken by Netbackup Server. So Netbackup deletes backups itself by its retention. RMAN retention policy is configured to REDUNDANCY 2.
Please, Advice me.