Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: A legal backup copy with an old hot backup + all redo ?
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...Received on Tue Nov 20 2001 - 13:32:49 CST
> 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
![]() |
![]() |