oracle数据库迁移---from source server to target server

公司需要将一台服务器上的数据库(size:11Gb)挪到另一台服务器上，具体信息及步骤如下：

 

source server

OS:   Windows 2003 sp2

DB:    oracle 9.2.0.7

 

target server

OS:   Windows 2003 sp2

DB:    oracle 9.2.0.7    ---- Only oracle software

 

  

步骤：

1.在target server上仅安装与source server一致的oracle软件（包括patchset 和 one-off patches） （Ready）

 

D:/oracle/ora92/OPatch>set oracle_home=d:/oracle/ora92

D:/oracle/ora92/OPatch>opatch lsinventory

Oracle Interim Patch Installer version 1.0.0.0.52
Copyright (c) 2005 Oracle Corporation. All Rights Reserved..

We recommend you refer to the OPatch documentation under
OPatch/docs for usage reference. We also recommend using
the latest OPatch version. For the latest OPatch version
and other support related issues, please refer to document
293369.1 which is viewable from metalink.oracle.com

Oracle Home = d:/oracle/ora92
Location of Oracle Universal Installer components = D:/oracle/ora92/oui
Location of OraInstaller.jar  = "D:/oracle/ora92/oui/jlib"
Oracle Universal Installer shared library = D:/oracle/ora92/oui/lib/win32/oraIns
taller.dll
Location of Oracle Inventory Pointer = N/A
Location of Oracle Inventory = D:/oracle/ora92/inventory
Path to Java = "D:/oracle/ora92/jre/1.4.2/bin/java.exe"
Log file = d:/oracle/ora92/.patch_storage/<patch ID>/*.log

Creating log file "D:/oracle/ora92/.patch_storage/LsInventory__08-19-2009_14-54-
18.log"

Result:

 

There is no Interim Patch

 

OPatch succeeded.
OPatch returns with error code = 0

 

 

2.在target server上创建与source server一致的目录  （Ready）

（包括数据文件目录，控制文件目录，日记文件目录，归档日志文件目录，tracefile目录等）

cmd>create_dir.bat

-------------------------------
--d:/oracle/admin/NEWMRPC/bdump
--d:/oracle/admin/NEWMRPC/cdump
--d:/oracle/admin/NEWMRPC/udump
--e:/newmrpc
--F:/NEWMRPC
--f:/newmrpc/arc
--e:/newmrpc/arc
-------------------------------

 

 

3.关闭数据库 (1 minutes)

 

cmd>set oracle_home=d:/oracle/ora92
cmd>set oracle_sid=newmrpc
cmd>lsnrctl stop
sql>shutdown immediate

 

 

4.拷贝source server上所有相关文件到target server相应目录下  (25 minutes)

(data files;temp file;control files;redo log files;spfile;pwfile;listener files)
cmd>copy_files.bat

-------------------------------------------------------------------------------------------- 

--copy /z E:/NEWMRPC/SYSTEM01.DBF //10.10.1.21/E$/NEWMRPC/
--copy /z E:/NEWMRPC/CWMLITE01.DBF //10.10.1.21/E$/NEWMRPC/
--copy /z E:/NEWMRPC/DRSYS01.DBF //10.10.1.21/E$/NEWMRPC/
--copy /z E:/NEWMRPC/EXAMPLE01.DBF //10.10.1.21/E$/NEWMRPC/
--copy /z E:/NEWMRPC/INDX01.DBF //10.10.1.21/E$/NEWMRPC/
...

--copy /z D:/oracle/ora92/database/SPFILENEWMRPC.ORA //10.10.1.21/D$/oracle/ora92/database/
--copy /z D:/oracle/ora92/database/PWDNEWMRPC.ora //10.10.1.21/D$/oracle/ora92/database/
--copy /z D:/oracle/ora92/network/admin/* //10.10.1.21/D$/oracle/ora92/network/admin/
--------------------------------------------------------------------------------------------------------------------------------

 

 

5.source server退域，拔掉网线  (1 minute)

 

 

6.修改target server的IP，主机名，加域 (6 mimute)

 

 

7.在target server上创建新实例，并启动数据库  (2 minute)

cmd>oradim -new -sid newmrpc -startmode auto

 

8.测试，检查（alert file和应用）  (10 minutes)

 

 

9.备份数据库