How to move Oracle data from one machine to another

最新推荐文章于 2026-06-23 18:57:17 发布

转载最新推荐文章于 2026-06-23 18:57:17 发布 · 578 阅读

标签

#oracle #service #application #server #button

#tools

收录于

Data Persistence 专栏收录该内容

2 篇文章

订阅专栏

本文介绍了一种Oracle数据库从旧服务器迁移到新服务器的方法。主要内容包括：停用新服务器上的Oracle服务；确保源目标服务器上Oracle服务的一致性；复制SPFILE及密码文件；迁移数据文件夹；重启新服务器上的Oracle服务并进行验证。

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.