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: Defining Obsolete Backups in RMAN

Re: Defining Obsolete Backups in RMAN

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Fri, 20 May 2005 21:32:48 +0200
Message-ID: <d6ldog$mrt$1@news3.zwoll1.ov.home.nl>


amerar_at_iwc.net wrote:
> We are running Oracle 8i, where retention policies are not yet
> implemented.
>
> Basically, I want to run that REPORT OBSOLETE UNTIL TIME 'SYSDATE-7';
> command, then I have written a script to parse the output and create
> the proper delete commands.
>
> I just want to make sure that the command does what I think, which is
> to report a list of backups that are outside my window, which are the
> ones I will delete.
>
> Arthur
>

Well, unless it is implemented different in 9.2 than in 8i, the report does *not* do what you expect (at least - what I understand you would expect - there's a world of possible mistakes there...): April, 12 is more that a week ago, but still not in the report. Reporting obsolete does mention it.

If you mean it *might* be obsolete, it *might* be correct, as I did not take an RMAN backup in the past 7 days, until today.

-- 
Regards,
Frank van Bortel
Received on Fri May 20 2005 - 14:32:48 CDT

Original text of this message

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