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

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

Delete obsolete backup sets from RMAN catalog

From: Helmut Daiminger <hdaiminger_at_vivonet.com>
Date: Wed, 29 Nov 2000 16:41:16 -0800
Message-Id: <10695.123273@fatcity.com>


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. Received on Wed Nov 29 2000 - 18:41:16 CST

Original text of this message

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