Re: Questions about cloning an instance

Assuming that your test server and your production server are the same OS and the version of oracle is the same, here is a faster, simpler approach:

1. Copy the datafiles to the new location
2. Create the init.ora file
3. Recreate the controlfile (possibily renaming the database).

"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! =-----
Received on Tue Mar 27 2001 - 18:29:07 CST