Re: Questions about cloning an instance

And one other question. Does this force me to have the same db_block_size as the old database?

-greg

"Greg Akins" <insomnia_at_cvzoom.net> wrote in message news:3ac30919_4_at_corp.newsfeeds.com...
> OK...clone a database. It looks relatively simple. I am going to a
> different box, with one disk (It's just for testing) and Win2000. Will
 that
> make much of a difference. It doesn't appear so.
>
> A couple things I'm a little wary of. First of all, I know that I can
 edit
> the controlfile trace to a 'Create database' command. Is this what I want
> to do, or am I simply editing it to create a different controlfile?
>
> So, walking through the startup...
>
> 1. Nomount - just needs a minimal init.ora
> 2. mount - Needs a controlfile (which can be created by the 'Alter
 Database
> Backup Controlfile to trace'
> Use the Create Controlfile statement and edit the file locations
> appropriately.
> 3. open - Will work if a valid copy of the datafiles are in the
 appropriate
> place.
>
> Seems simple enough. Wish me luck.
>
> Thanks for the the help.
>
> -greg
>
> "Howard J. Rogers" <howardjr_at_www.com> wrote in message
> news:3ac19f36_at_news.iprimus.com.au...
> > You might care to peruse
> > http://www.geocities.com/hjroz2000/clonedatabase.txt where the subject
 is
> > documented at length. The replies I've seen posted here will have your
 new
> > database sending archives into the same directory as the production
 database
> > (assuming the source database is in archivelog mode), amongst other
 nasty
> > gotchas.
> >
> > Incidentally, you don't clone an 'Instance'. You clone a database.
> >
> > Regards
> > HJR
> >
> >
> >
> > "Greg Akins" <insomnia_at_cvzoom.net> wrote in message
> > news:3ac104e6_3_at_corp.newsfeeds.com...
> > > Hello,
> > >
> > > I am setting up a test server which need to mimic a production oracle
 8i
> > > database.
> > >
> > > From a highlevel perspective I believe I have to
> > >
> > > 1. Create the instance with an init.ora similar to the production
> > > (differences for SGA settings only?)
> > > 2. Create a script to recreate the users and tablespaces? Tablespace
 can
> > > be the same, but the test box only has one disk, so Datafile locations
 will
> > > be different.
> > > 3. Full Export from Production and import to Test.
> > >
> > > Am I missing anything? Any suggestions would be appreciated.
> > >
> > > -greg
> > >
> > >
> > >
> > >
> > > -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> > > http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> > > -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
> >
> >
>
>
>
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Mar 29 2001 - 05:00:22 CST