ADSM-L

Re: Deleting old TDP for Oracle backups

2002-07-05 04:01:15
Subject: Re: Deleting old TDP for Oracle backups
From: Michael Bartl <michael.bartl AT CW DOT COM>
Date: Fri, 5 Jul 2002 09:59:27 +0200
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:michael.bartl AT cw DOT com
Michael Bartl, Dipl. Inform. (FH)           mailto:michael.bartl AT cw DOT com
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


<Prev in Thread] Current Thread [Next in Thread>