Re: Questions about cloning an instance

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! =-----
Received on Wed Mar 28 2001 - 02:21:56 CST