On May 18, 12:01 pm, chris b <chris.br..._at_providenthims.co.uk> wrote:
> Working on oracle 10.2.0.3 Enterprise
>
> I was working with standard recovery time window of 7 days
>
> Earliest full backup 11th May
>
> The rest between 14th and 18th May
>
> I changed recovery time window to 4 days
>
> I then executed a delete obsolete command & expected the 1th may
> backup to be picked up and deleted ....however this didn't happen and
> no backups were considered obsolete.
>
> Should the 11th May backup have been deleted in accordance with new
> recovery time window or is it somehow linked to the recoverty time
> window at the time of it's creation?
>
> Thanks in advance for any help you can give
> Chris B
When you set the recovery window to 4 days, what you are saying is
that "I want to be able to recover to any point in time in the last 4
days", not "I only want to keep backups for 4 days". It looks to me as
though you still need the 11th May backup to recover to 4 days ago
(actually due to the wonders of internet time delays you may now find
the 11th may backup obsolete, but I digress.
Received on Fri May 18 2007 - 10:07:35 CDT
