Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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...
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
![]() |
![]() |