I don't think the TDPOSYNC is for regular deletes. That's used
only for cases where the RMAN catalog doesn't have the file/object
anymore but TSM server still does. (RMAN doesn't use good handshaking
and therefore gets in this condition). The TDPOSYNC is used to display
a list of files in this condition for you to manually delete.
The normal deletes are done by RMAN scripts.
David Longo
>>> [EMAIL PROTECTED] 08/08/02 02:52PM >>>
Thanks Eric! That is exactly what I needed. My question now is whether
anyone has this process automated. Can I have the client or the server
automate the process to expire the backups?
Rob Schroeder
Famous Footwear
"Cowperthwaite,
Eric" To: [EMAIL PROTECTED]
<eric.cowperthwai cc:
[EMAIL PROTECTED]> Subject: Re: Expiring TDP for Oracle
data
Sent by: "ADSM:
Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
07/31/2002 04:12
PM
Please respond to
"ADSM: Dist Stor
Manager"
Once the objects are deleted in RMAN, then you will need to run a TDPOSYNC
<tdposync syncdb -tdpo_optfile=[optfile name]> and that will sync the RMAN
catalog and TSM database and expire the files on your TSM Server
Eric W. Cowperthwaite
EDS
-----Original Message-----
From: Holger Speh [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 31, 2002 1:27 PM
To: [EMAIL PROTECTED]
Subject: Re: Expiring TDP for Oracle data
Theresa,
all Oracle backup objects are unique so there won't be any inactive
versions
which you can expire via TSM. You have to expire them "manually" with an
RMAN script doing a RMAN report obsolete first to find all no longer needed
Oracle backups and them doing a RMAN delete on these objects.
Mit freundlichen Grüssen / With kind regards,
Holger Speh
<http://www.ibm.com/>
IBM Global Services - Integrated Technology Services
Mobil: +49 (0)172 / 6365603
Fax: +49 (0)5341 / 892803
Notes: Holger Speh/Germany/IBM@IBMDE
email: [EMAIL PROTECTED]
Theresa Sarver <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
31.07.2002 18:39
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Expiring TDP for Oracle data
Hello;
I've been searching the archives on this subject all morning and I just
want
to double-check my findings.
Environment:
SP Model 9076 (1 Frame w/ 7 nodes)
AIX 4.3.3 ML8
P.S.S.P 3.2
ptfset 8
TSM 4.1.5
ORACLE 8.1.7/RMAN
TDP for Oracle v2.1.1 (I think?)
The DBA's have only been using TDP/RMAN for a few months now and around
July
10 they decided to start exprining some old backups. I noticed yesterday,
that the copy group had been setup improperly for TDP_Oracle:
STANDARD ACTIVE RMANCLASS STANDARD 1 1 0 1
STANDARD STANDARD RMANCLASS STANDARD 1 1 0 1
I modified the appropriate parameters last night (using TDP for Ocacle
Admin
Guide) and think it's right now:
STANDARD ACTIVE RMANCLASS STANDARD 1 0 0 0
STANDARD STANDARD RMANCLASS STANDARD 1 0 0 0
I ran 'expire inventory' shortly thereafter, this however did not remove
any
of the inactive databases:
/adsmorc : // cold_TESTR_1631_270302_22_1 (MC: DEFAULT)
Inactive, Inserted 03/27/02 16:32:19, Deactivated 07/10/02 15:18:10
ObjId: 0.58797993
So, from what I've read I have 3 options:
1) run some "delete object 0 xxxxxx" command (Could someone please
provide
me with any further information on this command?)
2) Create a new filespace, then delete the old one after several days
3) Using a TDPOSYNC command...depending on version. Anyone know if 2.1.1
supports the use of this command? - Can't find any reference in the TDP for
Oracle Manuel.
Thanks 'yet again' for your help;
Theresa
(See attached file: image001.gif)
"MMS <health-first.org>" made the following
annotations on 08/08/2002 05:04:34 PM
------------------------------------------------------------------------------
This message is for the named person's use only. It may contain confidential,
proprietary, or legally privileged information. No confidentiality or privilege is
waived or lost by any mistransmission. If you receive this message in error, please
immediately delete it and all copies of it from your system, destroy any hard copies
of it, and notify the sender. You must not, directly or indirectly, use, disclose,
distribute, print, or copy any part of this message if you are not the intended
recipient. Health First reserves the right to monitor all e-mail communications
through its networks. Any views or opinions expressed in this message are solely
those of the individual sender, except (1) where the message states such views or
opinions are on behalf of a particular entity; and (2) the sender is authorized by
the entity to give such views or opinions.
==============================================================================
