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

Please suggest.

Thanks