Ok, finished the installation of Oracle 9i on the new machine. It is time for me to move all existing data from my old machine to this new server. I do not want to create all stuffs from the scratch, and do not want to use exp/imp utility either. I thought there should be a easy way to do so. Since I am a web designer, I will give such question to the DBA in my team.
It turns out there is an easy way, yeah!
Here are some steps I did to move all data from the old machine to new machine with the help of my DBA co-worker.
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 identical.
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.
0 Responses to “How easily to move Oracle data from one machine to another”