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: A legal backup copy with an old hot backup + all redo ?

Re: A legal backup copy with an old hot backup + all redo ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 21 Nov 2001 06:32:49 +1100
Message-ID: <3bfaaf56$0$13482$afc38c87@news.optusnet.com.au>


You could do what you propose, not a problem. A new backup of whatever type (hot or cold) does not invalidate any prior archives. Using the earlier backup will, however, (and as you point out) require the application of additional logs to recover -which means recovery time will be higher.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Christian Svensson" <chse30_at_hotmail.com> wrote in message
news:ccc2a7eb.0111201117.5bb1ffcd_at_posting.google.com...

> Greetings,
>
> A have a perhaps a "stupid" question, have not tested it yet though.
>
> Think of this scenario:
>
> Day 1
> 18:00 a hot backup is made and saved to the same disk that one of the
> datafiles (ok I know the backup should reside on another disk) (the
> archived redos is on another disk)
> 20:00 the files from the hot backup + all redologs is saved to tape
>
> Day 2
> 18:00 a hot backup is made...
> 19:45 a disk crash occour on the disk where both the backup and
> datafile resides
>
> In my mind I think that I just could take the backup from Day 1(lies
> on tape) and then apply all the redos (from both day 1 and day 2).
> Since I use the latest controlfile it would know how much to roll
> forward.
>
> Or does the old backup copy (from day 1) becomes invalid when a new
> hot backup is done ?
>
> Thanks for any comments on this.
>
>
> Regards
>
> /Christian
Received on Tue Nov 20 2001 - 13:32:49 CST

Original text of this message

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