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:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of 
David E Ehresman
Sent: Friday, July 22, 2011 11:35 AM
To: ADSM-L AT VM.MARIST DOT EDU
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