Re: hot backup question

>True cloning requires a closed database backup that includes
> the online redo logs.

sorry Howard - you even do not *need* the online redolog files for cloning a database using closed database backup IF the DB was shutdowned WITH a checkpoint (so shutdown whatever except ABORT). That way you can restore without online redologs and open the DB with 'resetlogs' without losing any data/transaction. A checkpoint happened during
shutdown so no need for redologs :-)
I believe this is even mentioned in the Oracle docs.

cheers

"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message news:3c1f92db$0$28049$afc38c87_at_news.optusnet.com.au...
> 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
> >
> >
>
>
Received on Tue Dec 18 2001 - 13:10:23 CST