Re: Cloning an Oracle instance

Have you thought of making a physical copy of your database?

On your source database you could use the "alter database backup controlfile to trace"
command to generate a create controlfile script. Do a normal Shutdown of the source
database and copy all the database files and redo log files to their new directories
or to another server. Do not copy the old controlfiles, they won't do you any good. You
can refer to the create control file script if you're not sure which files you'll need. You'll
probably want to make a copy of the parameter file(s) as well. Edit your create control file
script and change all the paths to your new directories, and edit any path references in
your parameter files too. You can then run the create controlfile script from srvrmgr to
create your clone database.

Good luck,

Jim Yoshii

Lizzie wrote in message <01befa56$c5b8b2e0$d8b44f0c_at_liznet.bcgroup.com>...
>Hi - I need to clone an Oracle instance to another, and never having done
>this before wanted to bounce my ideas off you guys first to see if you had
>any recommendations about what to do or not do!
>
>I need to migrate all the objects from this instance, including packages,
>package bodies, views, etc.
>I'm planning on using Export (does Export do packages?) , but not with a
>"full" option because I want to put the objects in the tablespaces
>belonging to the new instance, which will be in different directories.
>I was planning on creating an empty new instance first, with all needed
>files, then importing the stuff in. I need to retain the data in some but
>not all of the tables, so was planning on taking it all and then truncating
>what I didn't need later.
>We're doing this to create a few more test databases for a product we're
>installing. Unfortunately the install process was so squirrely that I can't
>just install fresh, as there is no real good "canned" install process to
>follow. The vendor put on patch after patch after patch after the base
>install scripts were run. Ugh....
>
>Any ideas, warnings, etc that you have would be greatly appreciated.....
Received on Thu Sep 09 1999 - 15:44:57 CDT