problems with deleting oracle back-ups

[ronaldm60]

Hi,

We want to delete old archives, but it is not possible, When we start the command with rman, i get the following error in TSM:

TDP Oracle AIX ANU0599 TDP for Oracle: (901957: =>(l2-bm06-e0g_gmtst) ANU2602E The object /gmtst//// full_GMTST_s4732_t645714029_p1 was not found on the TSM Server

But with the q content command i still see the back-ups on tape:

Node Name Type Filespace FSID Client's Name for File
Name
--------------- ---- ---------- ---- --------------------------------------
L2-BM06-E0G_GM- Bkup /gmtst 1 // full_GMTST_s4732_t645714029_p1
TST

I'm using TSM 5.3.3.0

I found the following on the internet, but that doesn't work for us:

The problem is the behaviour that the DP for Oracle will first try to delete this file regardless of whether it exists or not.
In addition to the information the 'backdel' parameter of the node object should be set to 'yes'. Otherwise the DP for Oracle client is unable to delete the control file in case it indeed exists on the TSM server.

How can i delete this backup?

[cheffern]

check here -
picked from an old post by Chad Small on the ADSM.org site (which you can search...)

http://www.tsmexpert.org/search/label/Oracle

Cheers -
-Chef.

[darsenau]

If the old archive logs were created by an old version of ORACLE, the new ORACLE RMAN probably is unable to delete them. We have run into this numerous times when the old backups are not deleted before the ORACLE is upgraded.

[cheffern]

that is because that in your backups, RMAN stores the info under a specific numerical ID - called an 'incarnation.'
you would have to connect to that ID using RMAN to be able to delete those.
ie -
Check this by:
RMAN> LIST INCARNATION OF DATABASE.

-Chef.