The less work for the DBA's the better.

Following up when deletion scripts are not being run and having them run
tdposync when they switch rman catalogs (or the deletion script is run
when TSM is down) is just another responsibility of TSM and DBA staff.

Deleting objects with dsmc can be scripted and automate the retention
policy enforcement of Oracle backups.

I've been tempted to use "delete object" but it's not supported.  DSMC
is supported.




-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Neil Rasmussen
Sent: Tuesday, November 21, 2006 11:55 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Re: RMAN Deletions with BA Client


You should be able to use 'tdposync' (comes with DP Oracle installation)
to do exactly what you are looking to do....not sure if you were aware
of
this tool.


Regards,

Neil Rasmussen
Software Development
Data Protection for Oracle
rasmussn AT us.ibm DOT com




"L'Huillier, Denis (GTI)" <denis_lhuillier AT ML DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
11/20/2006 12:15 PM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
RMAN Deletions with BA Client






The newer TSM BA client allows for file level deletions of backup data
with the "delete backup" command.  The delete backup command has options
like "fromdate/fromtime/todate/totime".

Has anyone used this to delete orphaned RMAN backup objects?  If so, do
you have a syntax example?

Here's an example but not working...

tsm> q backup /amdp1/* -su=yes -ina
             Size      Backup Date        Mgmt Class A/I File
             ----      -----------        ---------- --- ----
API  4,096,000 KB  02/03/05   21:21:01    DEFAULT     A
/amdp1//ORA_A_AMDP1_549321660213112jgbruts

tsm> del backup /amdp1//ORA_A_AMDP1_549321660213112jgbruts
ANS1302E No objects on server match query

tsm> del backup "/amdp1//ORA_A_AMDP1_549321660213112jgbruts"
ANS1302E No objects on server match query

tsm> del backup "/amdp1/ORA_A_AMDP1_549321660213112jgbruts"
ANS1302E No objects on server match query

tsm>

If I can get this to work this would be a much easier way to enforce
retention policies.

Thanks.
--------------------------------------------------------

If you are not an intended recipient of this e-mail, please notify the
sender, delete it and do not read, act upon, print, disclose, copy,
retain
or redistribute it. Click here for important additional terms relating
to
this e-mail.     http://www.ml.com/email_terms/
--------------------------------------------------------