Re: Move database server from one NT to another

Salim,

Thanks for your helpful information. I will try to do it in next few day.

Tuan

In article <962828256.265561_at_opti.cyberia.net.lb>, salim_at_sjkaram.com says...
>
>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
>>
>>
>
>
Received on Thu Jul 06 2000 - 00:00:00 CDT