Re: Questions about cloning an instance

easiest way that i've found if they are the same platform and you can shutdown the prod instance:

1. create oracle user, configure profile and install database on new server but do not create db objects
2. on the production box, log into server manager and create a trace file:

%svrmgrl
svrmgrl> connect internal
svrmgrl> alter database backup controlfile to trace reset logs;

3) shutdown production and copy the datafiles to the mount points on the new box via ftp or tape, etc

4) edit the trace file to reflect the new controlfile, datafile locations, etc

5) on the new box, log into server manager

6) boot up from trace file Received on Tue Mar 27 2001 - 19:42:26 CST