Re: DBPITR with incremental level 1 backup

From: Ingrid Voigt <giantpanda_at_gmx.net>
Date: Fri, 18 Nov 2011 18:39:07 +0100
Message-ID: <20111118173907.263550_at_gmx.net>

Hi,

for a point in time recovery you need

- a level 0 backup as a foundation 
- optional: a level 1 backup on top
- all archivelogs from the beginning of the previous backup 

to the target time (either as backup or on the server).

In your case you have the level 0 from Sunday, the level 1 from Monday, but no archivelog backups between Monday and Tuesday morning. So, unless you keep the necessary archivelogs on the server, this recovery is going to fail.

BTW, it is a high-risk strategy not to keep some redundant backups on file or tape. One does not always notice if a tape is broken...

Best regards
Ingrid

• Original-Nachricht --------
  > Datum: Fri, 18 Nov 2011 17:29:51 +0000
  > Von: "Ricard Martínez" <ricard.martinez_at_gmail.com>
  > An: oracle-l_at_freelists.org
  > Betreff: DBPITR with incremental level 1 backup
  

> Hello
> I have a question that is not enough clear for me reading the manuals.
> I do a Level 0 backup on Sunday and then a incremental level 1 from monday
> to saturday.
> Also i make 1 normal archive backup every day at lunch time, that do a
> delete backup of archivelog until time sysdate-1
> If for example some user delete a table on tuesday morning, and we notice
> it on friday, will we able to do a database incomplete recovery to tuesday
> morning using the level 1 backups?
> Or the delete of the archive backup will make us unable to do it, cause it
> have already deleted the old archive backup?
> Thanks
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

-- 
NEU: FreePhone - 0ct/min Handyspartarif mit Geld-zurück-Garantie!		
Jetzt informieren: http://www.gmx.net/de/go/freephone
--
http://www.freelists.org/webpage/oracle-l

Received on Fri Nov 18 2011 - 11:39:07 CST