Guillaume, there was a thread on this problem quite a while ago. Just search the list for "delete object 0".
Using TSM's SQL interface you can select the object-id from each file you want to delete. Now you can create a macro file with line like "delete object 0 46364523". To delete the objects run "macro macrofile". Keep in mind that this is an undocumented feature. There probably is no support from Tivoli for this but it worked fine on our server to get rid of all the objects RMAN had not expired in TSM by error. Good luck, Michael -- Michael Bartl, Dipl. Inform. (FH) mailto:[EMAIL PROTECTED] Backup Services, IT Ops Germany/Austria Tel: +49-89-92699-806 Cable & Wireless Deutschland GmbH. Fax: +49-89-92699-302 Landsberger Str. 155, D-80687 Muenchen http://www.cw.com/de -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED]]On Behalf Of Guillaume Gilbert Sent: Donnerstag, 4. Juli 2002 21:11 To: [EMAIL PROTECTED] Subject: Deleting old TDP for Oracle backups Hello I have old TDP for Oracle backups that I want to get rid of. This being the first time I used TDPO, I didn't use a nodename for each database, I used a nodename for each server. So now I have 3 or 4 databases using the same nodename. SOme of these databases have since disappeared and I am stuck with the backups. The Oracle admin can't seem to figure out how to get RMAN to delete the backups and since they are in the active state, they will never expire. I've opened a PMR on this and I'm hoping for a miracle. That Share request about being able to delete 1 file from backups and not only a filespace seems to me would be migty handy here. If anyone out there in TSM land has a recipe, please share. Thanks Guillaume Gilbert CGI Canada
