Re: hot backup question

You can not take your online redologs from tape as it is not possible to make a consistent hot backup of them ...

So to answer your question - you can do a restore/recovery to different machine (with or without recreating the controlfile) but the recovery will always be an incomplete one as you'll have to open the database using resetlogs to recreate your redologs...

"Scott Gamble" <zifnab_at_NOSPAM.reddragon.org> wrote in message news:0aMT7.38380$m8.36272_at_news.webusenet.com...
>
> Oracle Version: 8.0.6.2 (not supported, but an 8.1.7 bug
> kept us from upgrading in Aug)
>
> OS: Tru64 5.0
>
>
> Trying to restore from a hot backup to a differant machine.
>
> 2 reasons for trying this.
>
> 1) We are moving to a new machine in January, and people
> were not patient enough afer moving files around this
> weekend for the next cold backup to be restored for them
> to start testing nor would they give us the time to do
> an additional cold backup.
>
> 2) Thought it would be a good test to verify that our hot
> backups are functioning as expected. (not often we have
> a spare machine sitting around with enough space to do
> it).
>
> So that being said, I have searched dejanews, and metalink
> for the answer to this question and I cannot seem to find it,
> and it may entirely be that I am completely overlooking something.
>
> Is it possible to take a hot backup from machine A restore it
> and the archive logs to machine B and get the database up and
> running.
>
> Seems as if it should be possible and documentation that I
> found seems to say it is. However the part that I seem to be
> missing is how to get the online logs created since they are not
> part of the hot backup itself? Or is it required to actually
> recover from the last cold, then lay the latest hot backup down
> on top of it (in which case old online logs are still there).
>
> Or am I just completely missing a part of the backup/restore
> process here.
>
> Scott
>
>
Received on Tue Dec 18 2001 - 12:52:43 CST