Re: hot backup question

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

> > >

> > >

> >

> >

>

>