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:[EMAIL PROTECTED] On Behalf Of Nicholas Rodolfich Sent: Thursday, September 20, 2007 11:21 AM To: ADSM-L@VM.MARIST.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.
