Re: Questions about cloning an instance

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! =----- Received on Thu Mar 29 2001 - 04:09:51 CST