We've got the following backup policy for a 9R2 database using RMAN and Netbackup v6.0

- Level 0 - Sunday
- Level 2 - Mon, Tues, Thu, Fri, Sat
- Level 1 - Wed

We've got a retention policy of 90 days, enforced through Netbackup policies.

We've also got a requirement to be able to restore to the 1st of any month indefinitely, which would require restoring the last level 0 backup and rolling forward.

I really just want to keep the necessary records in the RMAN repository to be able to restore to the 1st of any particular month and to any point in time in the last 90 days.

I cant use KEEP FOREVER as using that on my oldest backup will mean no archivelog backups will ever become OBSOLETE so I'm unsure if I can enforce the business requirement without keeping every RMAN record for all backups forever.

Any help appreciated