This is the script I use: ASSUMPTIONS: RMAN is backing-up using the node name ORACLE-NODE-BU
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='ORACLE-NODE-BU' order by BACKUP_DATE > /tmp/ORACLE-NODE-BU.bulist.txt Thanks, H. Milton Johnson -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Hart, Charles A Sent: Friday, November 21, 2008 9:59 AM To: [email protected] Subject: [ADSM-L] RMAN - Oracle Deletes Hope everyone is well in these trying times..... Does anyone know if there's a way other than tracking occupancy to see if RMAN is passing deletes to TSM for Oracle TDP clients? We've had many challenges with our Oracle group and their delete backup script not working. Thank you Have a great day! Charles This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
