Re: Deleting RMAN catalogue file

        We just started using TDP for Oracle, and my interpretation of
the documentation I've read is that RMAN is in control of the whole
process and you shouldn't try to delete/expire the files out from under
it. 

        In a couple of cases where the DBA has been unable to see the
old backups to delete them, they have been able to run some RMAN
commands to have it query the TSM server and get the RMAN catalog back
in sync. Not sure what that command is, I'm not a DBA, perhaps someone
else in the list could talk to that.

        In one case on a test server that was build and rebuilt a few
times, they just could not get RMAN to see older TSM backups. In that
case, I renamed the filespace to another name, kept the filespace around
for the desired retention, (30 days for this server), and then deleted
the filespace.

        Sorry but that's all the insight I have into your issue, I have
never tried to expire any of the individual TDP backup files.

Ben


-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Richard Mochnaczewski
Sent: Wednesday, March 29, 2006 11:59 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Deleting RMAN catalogue file

Hi,

I'm having some trouble trying to delete a few RMAN recovery catalogue
logfiles. My DBA is unable to delete them in Oracle, but I would like to
delete the in TSM. I know I can use the expire command to do so but
because of the RMAN "virtual" filespace in TSM I'm unable to.

Info :

Filespace Name: /adsm-rman
FSID: 78
Client's Name for File: // lf_TRCV02_573465621_530_1

When I try running expire /adsm-rman/lf_TRCV02_573465621_530_1 I get the
following error :

Backup files will be expired.  Do you wish to proceed? (Yes (Y)/No (N))
y ANS1302E No objects on server match query

Expire processing of '/adsm-rman/lf_TRCV02_573465621_530_1*' finished
with  1 failures.

When I check the dsmerror/log file , I get the following message :

29.03.2006 13:51:21 ANS1302E No objects on server match query

I know the file exists because it is located on one of my onsite tapes.
I tried using the wildcard * at the end of the filename thinking that
the filename may be truncated but that is not the case. How can I delete
this file ?

Rich