Step 1: Stop the Oracle service on the new server to make sure everything smooth. On Windows 2003 server, just go into the Service console of Administrative tools, and click Stop button for Oracle service.

Step 2: Make sure the oracle service on both machines are similar. Like the existing one called MYDATA then the new one should be better called MYDATA too. If not, then create an Oralce service with the same name on the new server. I am not sure whether this step is mandatory or not. But to have less trouble, why not we keep them identicial.

 

Step 3: Copy two files from the Oracle application folder to the same folder on the new server. These two files are SPFILE and Password files. In my case, they are C:\oracle\ora92\database\SPFILEMYDATA.ora and C:\oracle\ora92\database\PWDMYDATA.ora

 

Step 4: Copy data folder to new server. There are a lot of control files in this folder whose name same as the Oracle service name. And it should be under the folder of oradata. In my case I copied the whole folder of c:\oracle\oradata\MYDATA to the directory of c:\oracle\oradata\ on the new server.

 

Step 5: re-start the oracle service on the new server. Tested, and it was successful.

发表于 @ 2008年08月25日　10:13:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:study how to express some SQL query in english------OUT JOIN