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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Deleting obsolete backups from RMAN

Re: Deleting obsolete backups from RMAN

From: Sean Fitzgerald <sfitzgerald_at_centurytel.net>
Date: Thu, 8 Nov 2001 06:14:29 -0800
Message-ID: <tTtG7.485$2S2.269538@feed.centurytel.net>


You need to issue a change.....delete command for each backup piece. Oracle provides a basic shell script (at least with enterprise edition) that simplifies this. The script runs the report obsolete command and outputs the results to the file, then it "builds" an rman script from that file which will run the change....delete command for each backup piece it finds.

"Michael Moore" <hicamel_at_yahoo.com> wrote in message news:ca4074a8.0111071614.56a20d72_at_posting.google.com...
> In RMAN I can say "report obsolete;". Now what if I want to delete
> everything that was just reported? What command can I use to delete
> obsolete Backup Sets and Backup Pieces. I want to get them out of the
> catalog, and off of the disk.
>
> Is there a document some where that lays out a strategy for using
> RMAN. I have the oracle8i Backup and Recovery Guide, but it is not too
> helpful on strategy.
> thanks,
> Mike
Received on Thu Nov 08 2001 - 08:14:29 CST

Original text of this message

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