We found the easiest way to get rid of files lost to the ebu (for
example if a dba starts a new ebu catalog during testing) was to
send them to a new management class
DSMO_FS=adsmorccleanup.  When your retention requirements
have past, delete the original adsmorc filespace.

A precise method is to talk to support and get instruction on how
to compile and use the sample maintenance utility to delete
individual objects.

On 7 Jul 2000, at 16:36, Loon, E.J. van - SPLXM wrote:

> Thanks to all who replied!
> I have updated the VEREXIST and RETEXTRA to 0, just in case this copy group
> is misused for non-Oracle backups.
> Thanks to you all I learned that the Connect Agent for Oracle creates
> backups instead of archives. Due to this I discovered that old backups were
> NOT deleted by the Connect Agent! This was because I allowed nodes to delete
> archive data and not to delete backup data!
> I now have to find a way for the Oracle guys to remove the old backups from
> TSM. Since I cannot remove individual backups through admin interfaces, they
> have to find a way to do this through the BA client.
> Kindest regards,
> Eric van Loon
>
>
> -----Original Message-----
> From: Neil Rasmussen [mailto:Neil_Rasmussen AT TIVOLI DOT COM]
> Sent: Friday, 07 July, 2000 16:17
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Management Class for Oracle backups
>
>
> Hi Eric,
>
> Each Oracle backup has a unique name based on a date/time stamp so only one
> version of a backup on the TSM Server exists. The only possible way that an
> object can be marked inactive is if you specifically mark it as deleted
> through
> RMAN or EBU and that also removes it from the backup catalog on Oracle.
> Therefor, you are right about VEREXIST and RETEXTRA. I hope this is clear.
> If
> you need more assistance you can email me offline. Thanks.
>
>
> Regards,
>
>
> Neil G. Rasmussen
> TDP Oracle
> Phone:  408-256-8265, t/l 276-8265
> E-mail:  nrasmuss AT tivoli DOT com
>
>
> "Loon, E.J. van - SPLXM" <Eric-van.Loon AT KLM DOT NL> on 07/07/2000 01:02:15 
> AM
>
> Please respond to "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
>
> To:   ADSM-L AT VM.MARIST DOT EDU
> cc:    (bcc: Neil Rasmussen/Tivoli Systems)
> Subject:  Management Class for Oracle backups
>
>
>
>
> Hi *SM-ers!
> The TDP for Orcale manual is rather unclear about how to configure your TSM
> management class for Oracle backups. The only statement is:
>
> Use parameters in the Management Class definition to control when the
> inactive object expires on the TSM server.
> For the backup copy group, use:
>    VERDELETED=0
>    RETONLY=0
> This erases the inactive objects from the server after the next inventory
> expiration.
>
> But how about the other parameters? Like VEREXIST and RETEXTRA?
> What should I enter here? The defaults (VEREXIST=2 and RETEXTRA=30) don't
> look right to me. Why keep files while Oracle can't restore them?
> Thanks in advance for your reply!
> Kindest regards,
> Eric van Loon
>
>
> **********************************************************************
> This e-mail and any attachment may contain confidential and privileged
> material
> intended for the addressee only. If you are not the addressee, you are
> notified
> that no part of the e-mail or any attachment may be disclosed, copied or
> distributed, and that any other action related to this e-mail or attachment
> is
> strictly prohibited, and may be unlawful. If you have received this e-mail
> by
> error, please notify the sender immediately by return e-mail, and delete
> this
> message. Koninklijke Luchtvaart Maatschappij NV (KLM), its subsidiaries
> and/or
> its employees shall not be liable for the incorrect or incomplete
> transmission
> of this e-mail or any attachments, nor responsible for any delay in receipt.
> **********************************************************************



 ========================================================================
== R. Ian Blair , Systems Administrator     = Phone: 902-494-3310      ==
== Dalhousie Univ., Computer Facilities & O =   Fax: 902-494-2319      ==
== B519 Killam Lib. , 6225 University Ave.  = E-mail: ian.blair AT dal DOT ca ==
== Halifax , NS , Canada , B3H 4H8          =  or: cfo.systems AT dal DOT ca  ==
 ========================================================================