ok - fair enough :-)
"Howard J. Rogers" <dba_at_hjrdba.com> wrote in message
news:3c1f9996$0$28050$afc38c87_at_news.optusnet.com.au...
> If you open it with a resetlogs, then the new database is at time 1, and
the
> original database is still at time 18947392. That doesn't look like a
> "clone" to me. Sure, the data might be the same between them, but it's
not
> a clone in my book, merely a copy.
>
> Hence the reference to "*true* cloning", and if words are invested with
> their ordinary meaning, then my original statement is still accurate.
>
> Regards
> HJR
> --
> ----------------------------------------------
> Resources for Oracle: http://www.hjrdba.com
> ===============================
>
>
> "koert54" <koert54_at_nospam.com> wrote in message
> news:zwMT7.1282$9y4.375899288_at_hestia.telenet-ops.be...
> > >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:41:35 CST
