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/
--------------------------------------------------------