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

From: Christian Svensson <chse30_at_hotmail.com>
Date: 20 Nov 2001 11:17:19 -0800
Message-ID: <ccc2a7eb.0111201117.5bb1ffcd@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:17:19 CST