Re: Rman

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Thu, 6 Jun 2002 06:30:24 +1000
Message-ID: <adlsdd$blf$1@lust.ihug.co.nz>

It entirely depends on what version of RMAN you are using. If it's 9i, then you can do what you want very easily: set a retention policy of 'redundancy 2', and periodically run 'report obsolete;' followed by 'delete obsolete;'.

But 'delete obsolete' was invented only in 9i, so your options are very much more restricted in 8i. Restricted to the point, in your case, that it can't be done: the relevant commands are things like 'change catalog'... and since you don't have a catalog, you wouldn't be able to use those.

Regards
HJR "Louis Frolio" <froliol_at_yahoo.com> wrote in message news:94c28610.0206050822.6518c3bf_at_posting.google.com...
> Greetings All. I am using RMAN in nocatalog mode and I am not sure
> how I would go about deleting old backup sets? I am in archivelog
> mode and I do a full backup each night. I only want to keep 2 days
> worth of backups on hand. How would I go about deleting the backups
> that are more than 2 days old? Also, I would like to remove these
> entries from the control file as well as the v$ views in the target
> database.
>
> Any advice would be greatly appreciated.
>
> Louis
Received on Wed Jun 05 2002 - 15:30:24 CDT