Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Delete obsolete backup sets from RMAN catalog

Re: Delete obsolete backup sets from RMAN catalog

From: Malik Michael <mmalyk_at_cryptologic.com>
Date: Thu, 30 Nov 2000 10:33:41 -0500
Message-Id: <10696.123328@fatcity.com>


Hi Helmut
You can try to do that (for instance):

RMAN> allocate channel for delete type disk; RMAN> change backuppiece <full name backup file> delete;

Repeat this command for every obsolete backup file.

Hope this help

Michael Malyk
Oracle Programmer
Toronto,Canada

Helmut Daiminger wrote:

> Hi!
>
> How can I get rid of obsolete backup sets in the recovery catalog? I already
> deleted the corresponding operating system files.
>
> Now I want to delete them from the recovery catalog so that I don't get
> listing of ancient backup sets when reporting on obsoletes.
>
> RMAN> report obsolete;
> RMAN-03022: compiling command: report
>
> Report of obsolete backups and copies
> Type Key Completion Time Filename/Handle
> -------------- ------ ------------------ --------------------
> Backup Set 1364 23-OCT-00
> Backup Piece 1466 23-OCT-00 C:\USERS_414431903_1
> Backup Set 1365 23-NOV-00
> Backup Piece 1467 23-NOV-00 C:\SYSTEM_414431904_2
> Backup Set 1366 23-NOV-00
> Backup Piece 1468 23-NOV-00 C:\DB_414432007_3_P1
> Backup Set 1367 23-NOV-00
> Backup Piece 1469 23-NOV-00 C:\DB_414432099_4_P1
> ...
>
> This is 8.1.6 on Win2k.
>
> Thanks,
> Helmut
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Helmut Daiminger
> INET: hdaiminger_at_vivonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Thu Nov 30 2000 - 09:33:41 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US