Re: hot backup question

Perfectly reasonable question, actually!

Because you are missing the current redo log, you are already talking about an incomplete recovery. All incomplete recoveries require you to finish off with an 'alter database open resetlogs'. The 'resetlogs' option will create any missing redo logs for you, so you will have an openable database at the end of it. It's actually the same sort of thing you do on production systems when you lose all members of the current redo log group. (Then you go and jump in a lake somewhere for putting yourself in a position of vulnerability like that!).

However, naturally, you'll have lost whatever transactions were involved in that last dollop of redo, so your new database will not be an exact clone of the old one. True cloning requires a closed database backup that includes the online redo logs.

Regards
HJR

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

"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

>

>