If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Originally posted by jodie Can you clarify what you mean by obsolete?
[Edited by jodie on 06-19-2002 at 04:44 PM]

Thanks for the script Jodie,

By obsolete I meant all databases prior to the last one., but I like your idea better.

This is what my setup is

I backup whole database on disk every day. My sysadmin picks up the backup from the disk onto a tape every night.

At any given point of time i have last 2 days of whole database backup on the disk and rest are on the tape. I delete the backups older than 2 days from the disk using O/S command based on the files time stamp (this somewhat scares me )and leaving their entry intact in the catalog.

Now after a week or maybe 2 , I would clean up the catalog using your script.

Can somebody please confirm whether my setup is Ok or not .

And Jodie wil your script work for what I am trying to do. I am using RMAN 8.1.7.0.0

Ronnie,
I'm really not sure what will happen if you use the script I posted. That script will try to delete it from disk/tape (Our script uses type tape... you would use type disk). I'm not really sure what would happen if the file wasn't actually on disk. My hunch is that it would work, just ignore that it wasn't physically on disk... but you should obviously test this..

You may also want to look into CROSSCHECK. One warning on crosscheck though... especially for anyone whose backups are on tape. We ran a crosscheck on our backups once, and RMAN could not detect whether the files were there on tape using the Media Management Layer. So what happened is it deleted all of our backupsets from the catalog, but they WERE on the tapes. Ouch! (We had to immediatly do an incr0 since all the backups were essentially gone). You shouldn't have problems with it if you're using disk.. but again.. make sure to test it.

Can you let us know what happens with the delete from disk? We may have to do this at some point in the future, so it would be good to know if it works!

Oh - we are also using RMAN 8.1.7.3 catalog with 8.1.6.3 database and executable... so these scripts should work fine for you.