Try:

select NODE_NAME,cast(BACKUP_DATE as date) as
"BACKUP_DATE",STATE,cast(DEACTIVATE_DATE as date) as
"DEACTIVATE_DATE",HL_NAME,LL_NAME from BACKUPS where
NODE_NAME='YOUR_TDP_NODE_NAME' order by BACKUP_DATE  

Milton Johnson 
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Nicholas Rodolfich
Sent: Thursday, September 20, 2007 11:21 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] How to view Oracle TDP files from TSM server

Hello All,

Thanks for your help!!

Is there a way to verify or list of particular files from Oracle TDP
backups on the server. I am caught in a chasm in DBA land. I don't fully
understand the TDP and the DBA doesn't understand TSM or the TDP.

Does anyone know any tricks or how I can find out more information than
just the standard q occ?

Nicholas


IMPORTANT NOTICE:  This message and any included attachments are from
East Jefferson General Hospital, and is intended only for the
addressee(s), and may include Protected Health (PHI) or other
confidential information.  If you are the intended recipient, you are
obligated to maintain it in a secure and confidential manner and
re-disclosure without additional consent or as permitted by law is
prohibited.   If you are not the intended recipient, use of this
information is strictly prohibited and may be unlawful.  Please promptly
reply to the sender by email and delete this message from your computer.
East Jefferson General Hospital greatly appreciates your cooperation.