Re: I need advice

Hello,

Moving an Oracle Database from an NT Server to another is a breeze. I did it just a couple of days ago, and I need the process for a lot of cloning.

Here's what has to be done:
1- On your first server, when the database is running, make sure you have the trace portion that helps you to recreate your control files. You usualy do this by issuing the following command:

    ALTER DATABASE BACKUP CONTROLFILE TO TRACE 2- Go to your trace files (usually in ORACLE_HOME\rdbms80\trace) and look in the most recent trace files for the syntax of the CREATE CONTROLFILE statment. Cut it and save it in a text control file. You'll need this if you move your database files to a differen folder structure. 3- Make a proper shutdown for the instance that you want to move, and backup the parm. file, data files, control files, redo logs, etc. 4- Prepare you second server by installing your Oracle server with similar options than the first one.
5- Copy all the files to the locations on the new server. If you manage to get them in a similar foler structure and the same drive name, you'll not need to recreate the control files.
6- Create the services for you instance using oradim80. 7- If you move the files to a different location, you need to modify the control trace file that you created in steps 1 and 2 to point to the new locations of your data files, and run it with server manager after you connect internal.

And voila! Your database should be up and running by this time!

If you need any clarification on the above, you can contact me...

Regards,

--
Salim J. Karam (aka Connector)
Computer Systems Engineer, Oracle DBA
Ain El Remmaneh, Pierre Gemayel Str.,
White Bldg
Beirut, Lebanon
E-mail: salim_at_sjkaram.com
Alt.: sjkaram_at_hotmail.com
<hpbrantley_at_my-deja.com> wrote in message
news:8j0fg3$hbp$1_at_nnrp1.deja.com...


> I need advice on migrating an existing database on an NT server to a new

> NT server.  I need info on what to watch out for.

>

> Any advice would be appreciated.

>

> Thanks.

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.