Re: Move database server from one NT to another

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!

Another option is to use the export / import database utility. Only the above way gives U an exact replica of your DB...

Regards,

--
Salim J. Karam (aka Connector)
Computer Systems Engineer, Oracle DBA
Beirut, Lebanon
E-mail: salim_at_sjkaram.com
Alt.: sjkaram_at_hotmail.com
Tuan Dang <tdang1_at_slb.com> wrote in message
news:8k03hq$b70$1_at_news.cwomnes.net...


> Hello,

>

> Can you please show me the best way to move the Oracle

> server from one NT to another.

>

> My systems:

> Oracle 8.1.5

> NT 4.0 SP 5

>

> Thanks,

> Tuan

>

>