>>In the case I manually drop the incremental level 0 and run a crosscheck, RMAN doesn't backup datafiles (for a new incremental level 0) because of the incremental level 1 (RMAN considers >>
>>backup exist and so skip datafiles).
It depend on the level 1 backup setup would be either cumulative or differential if cumulative it will always check for latest level 0 backup. seems in your case is it is differential which check either most recent level 0 or level 1
>>But since I haven't got any incremental level 0, incremental level 1 are useless.
>>How can I ask RMAN to delete all unusable backup and archive log ?
You can use
DELETE OBSOLETE: backups are in RMAN repository that are obsolete, that is, no longer needed
DELETE EXPIRED : RMAN marks as expired when run crosscheck command and the files are absent or inaccessible.
For more detail you can check the doc:BACKUP
Thanks for replying.
I do understand the differences between differential and cumulative but this is not what I'm looking for.
I run a crosscheck (archivelog all and backupset) before each backup.
My problem is that at a point in time I can run without an incremental 0 (lost or deleted from disk), an incremental 1, do a crosscheck so that Oracle is aware that only an incremental lvl 1 exist without a "parent" level 0 ( I think that cumulative or differential doesn't matter), then ask to Oracle to "backup not backed up incremental level 0" and get an answer from RMAN saying "everything's ok, I've nothing to do" which is obviously wrong.
I found a blog related to this "problem" => Database Specialists &raquo; Don&#8217;t Fall Into This RMAN Trap