Sean,

This is a good question;  I have had a really hard time finding more
information about the store inside TSM for TDP for Oracle.  Our TSM is
keeping the TDPO backups forever. (Until I delete the filespace completely).

I've done the same thing with my management class as per instructions
(1,0,0,0).  In addition to that I've read that the management class needs to
be put in the dsm.opt or dsm.sys files ??

If filespace is not specified, then /adsmorc is used.  Within TSM
administrator client, I've done a "q QUERY ACTLOG BEGINDATE=01/20/2004
BEGINTIME=01:00 ENDDATE=02/06/2004 ENDTIME=NOW SEARCH=adsmorc" and seen
curious entries in the TSM server activity log.  But I can't make sense of
them:

01/22/04   03:01:41     ANE4994S (Session: 30431, Node: 107PROD)  TDP Oracle
SUN ANU0599 ANU2602E The object /adsmorc//25fc5edk_1_1 was not found on the
TSM Server
01/22/04   03:02:28     ANE4994S (Session: 30434, Node: 107PROD)  TDP Oracle
SUN ANU0599 ANU2602E The object /adsmorc//d7fc5edo_1_1 was not found on the
TSM Server
01/22/04   03:47:16     ANE4991I (Session: 30439, Node: 107PROD)  TDP Oracle
SUN ANU0599 ANU2535I File /adsmorc//d8fc5ei5_1_1 = 1572864000 bytes sent
01/22/04   04:28:25     ANE4991I (Session: 30501, Node: 107PROD)  TDP Oracle
SUN ANU0599 ANU2535I File /adsmorc//d9fc5h68_1_1 = 1572864000 bytes sent
01/22/04   04:30:09     ANE4994S (Session: 30537, Node: 107PROD)  TDP Oracle
SUN ANU0599 ANU2602E The object /adsmorc//dafc5jje_1_1 was not found on the
TSM Server


Anyone, is there a way to find out what these 'files' in the /adsmorc
filespace are bound to ?  TSM looks like a DB2..   Is there any information
within TSM that i can get to that will let me know more ?   It seems like
TSM has to know what mgmt class these /adsmorc//backup23983_xx  files are
bound to.

In the TDPO directory, there is a utility called tdposync that claims to
sync the TSM store and the Oracle Rman information.  I haven't had success
in connecting with it yet.





-----Original Message-----
From: bab [mailto:vjtsm AT REDIFFMAIL DOT COM]
Sent: Monday, February 09, 2004 10:14 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: TDP for Oracle and TSM


be sure, node use for tdp has backdelete=yes

On Mon, 09 Feb 2004 tsmadmin account for Excaliber Business Solutions wrote
:
>Hi
>
>I am running TDP for Oracle Version 2.2.1 on an AIX server.
>Current version of Oracle is version 8
>We are using RMAN to backup the database to TSM.
>
>My question is using RMAN how does one delete/expire the data out of TSM.
>Using the RMAN option I have specified the following for the co group.
>
>
>
>Versions Versions   Retain  Retain
>Data     Data       Extra    Only
>Exists   Deleted    Versions Version
>
>   1        0          0          0
>
>
>Thks
>Sean
>
>"This e-mail is sent on the Terms and Conditions that can be accessed by
Clicking on this link http://www.vodacom.net/legal/email.asp "