Simplest way I've found: select ll_name, filespace_name, date(backup_date) from backups where node_name='ORACLENODENAME'
Then get your Oracle person to pull a list of the Oracle "pieces" from the RMAN catalog, you can match up the names and dates to the ll_names from this query. -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[email protected]] On Behalf Of David E Ehresman Sent: Friday, July 22, 2011 11:35 AM To: [email protected] Subject: [ADSM-L] Rman not deleting old backups Awhile back someone shared on this list their commands/scripts for verifying that rman was not leaving any old backups on the TSM server. I can't seem to find it now. Ring a bell with anyone? David
