RMAN orphaned backups

From: Chuck <skilover_nospam_at_bluebottle.com>
Date: Tue, 30 Jan 2007 17:49:35 GMT
Message-ID: <PyLvh.37760$uC6.9899@trnddc02>

We sometimes use rman duplication to refresh test/dev databases from their production counterparts. This creates a new dbid for the copied database which effectively orphans the old dbid in the rman catalog as well as it's associated backup sets. I want to get rid of these old backup sets to release space in the tape library. I could use dbms_rcvcat.unregisterdatabase but there's a catch - some of the backup sets are marked for "keep" and must be retained. How can I remove just those backup sets from the rman catalog that are not marked to keep? If I can safely remove them, the media vendor provides a utility which will then synchronize their library with the rman catalog and delete the backup pieces from the media subsystem.

The database versions range from 9.0.1 through 10.2.0.2. The rman catalog is version 10.2.0.2.

If you have a script that does this (I'm sure other DBA's have addressed this issue before), would you care to share it?

Thanks. Received on Tue Jan 30 2007 - 11:49:35 CST