Re: Problem : Maintaning the RMAN repository v. 8.0.5

Well :-) I answer it myself ... (!)

Perhaps a bit of help for anyone else strugeling with RMAN..

First issue the following on the unix prompt (as oracle user) :

# rman target sys/<instans> rcvcat rman/rman_at_rman

Then, at the rman prompt (or in my case in a shell script):

RMAN> allocate channel for delete type 'sbt_tape';
RMAN> list backupset of database;
RMAN> release channel;

Then to delete the obsolete backup items:

RMAN> change backupset <KEY> delete;

• <KEY> is derived from previous "list backupset" command.

...... Then after the next "Expire Inventory" process in the TSM server - the obsolete backup items will dissapear.

/Nicke Berglund

nicke.berglund_at_scomp.se (Nicke Berglund) wrote in message news:<763ecf9b.0311280111.34c53ad_at_posting.google.com>...
> Hello,
>
> I've got a problem deleting old backup objects through an old version
> of RMAN - v. 8.0.5.2.1. I'm my no means a DBA - only TSM and UNIX
> skills so I'd greatly appreciate any ideas :-)
>
> (I want to do this because the backup objects are backed up to a TSM
> server, which can't inforce backup object version policy due to all
> objects hav
> ing unique names. When I delete old objects in RMAN they later become
> "expired" in TSM)
>
>
> ... It says "backup set is missing" (se error log below) eventhough I
> select a backup object that's been backed up as recent as 2 days ago.
>
> Also I've tried to use the RMAN command "crosscheck" but my RMAN
> installation doesn't recognize the option:
>
> crosscheck backup;
> or:
> change backuppiece 1023 crosscheck;
>
> -------------------------------------------------------------------------
> # rman target sys/xxxxx rcvcat rman/rman_at_rman
> RMAN> allocate channel for delete type 'sbt_tape';
> -------------------------------------------------------------------------
> RMAN> change backuppiece 1023 delete;
>
> RMAN-03022: compiling command: change
> RMAN-03026: error recovery releasing channel resources
> RMAN-00569: ================error message stack
> follows================
> RMAN-03002: failure during compilation of command
> RMAN-03013: command type: change
> RMAN-06038: recovery catalog package detected an error
> RMAN-20260: backup piece not found in the recovery catalog
> RMAN-06092: error while looking up backup piece
> --------------------------------------------------------------------------
>
> Still i can se all backup objects (from the very first object id 2 to
> yesterdays id 3512) if I run: RMAN> report obsolete;
>
>
>
>
> Any help appreciated,
>
> Regards
> Nicke Berglund
Received on Tue Dec 02 2003 - 03:27:04 CST