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

Home -> Community -> Usenet -> c.d.o.server -> Re: RMAN - Deleting old backupsets

Re: RMAN - Deleting old backupsets

From: Shaul <sbenyo_at_ibm.net>
Date: Fri, 29 Oct 1999 20:17:33 +0200
Message-ID: <7vcoj4$u14$1@news.ibm.net.il>


I've checked things myself and now I know how to do it. If anyone is intrested this is how it works:

  1. To delete backupsets / backuppieces there is a command called change with the option delete: change ... delete
  2. With the change command you can also delete already deleted backuppieces from the catalog by using change...uncatalog. There's also a way to validate the catalog by: change...validate.
  3. If anyone is looking for an automatic procedure, you can get a list of the obsolete backupsets/pieces (e.g. old sets from before the last full backup) by using the report command, and write a script that will issue a change...delete on these backupsets.
                                            Shaul





Received on Fri Oct 29 1999 - 13:17:33 CDT

Original text of this message

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