数据库迁移（copy datafile方式）——从32位linux到64位linux实际操作

迁移前后环境

souce：

系统：redflag Asialinux 2 32bit        2.6.9-42.7AXsmp

数据库：oracle 32bit 11.2.0.1.0

IP：10.162.2.150

ORACLE_HOME：/opt/oracle/product/11.2.0/dbhome_1

 

target：

系统：redflag Asialinux 2 64bit        2.6.9-89.5AXSlargesmp

数据库：oracle 64bit 11.2.0.1.0

IP：10.245.1.118

ORACLE_HOME：/opt/oracle/product/11.2.0/dbhome_1

 

本例不改变souce和target的datafile等文件的存放目录，故不用修改pifle 和 control file 里的路径，如不能达到source和target的control file、datafile等文件存放目录一致。可能需要修改pfile和利用trace重建controlfile。见tianlesoftware写的http://blog.csdn.net/tianlesoftware/article/details/7258654

 

一、开始安装oracle数据库（数据库安装之前的操作省略）

[oracle@aqyxn ~]$ cd /opt/app/orainstall/database/
[oracle@aqyxn database]$ ./runInstaller

检查下oracle_home的路径，之后一路“下一步”

/opt/oracle/product/11.2.0/dbhome_1/root.sh

二、在target建立对应目录（实际情况需根据souce建立）

[oracle@aqyxn oracle]$ cd /opt/oracle
[oracle@aqyxn oracle]$ mkdir admin  cfgtoollogs diag  extapi  flash_recovery_area  oradata  oradiag_oracle  oraInventory

[oracle@aqyxn oracle]$ cd admin/
[oracle@aqyxn admin]$ mkdir db
[oracle@aqyxn admin]$ cd db/
[oracle@aqyxn db]$ mkdir adump  dpdump  pfile
[oracle@aqyxn db]$ cd /opt/oracle/oradata/
[oracle@aqyxn flash_recovery_area]$ mkdir /opt/oracle/oradata/db
[oracle@aqyxn flash_recovery_area]$ cd /opt/oracle/flash_recovery_area
[oracle@aqyxn flash_recovery_area]$ mkdir db

 

三、拷贝souce文件传到target

1、先要normal停原数据库实例和监听，在source执行scp命令

 

2、scp oracle文件

[oracle@aqyxn oracle]$ cd /opt/oracle/flash_recovery_area/db/
[oracle@aqyxn db]$ scp control02.ctl oracle@10.245.1.118:/opt/oracle/flash_recovery_area/db/

[oracle@aqyxn oracle]$ cd /opt/oracle/product/11.2.0/dbhome_1/dbs/
[oracle@aqyxn admin]$ ls
[oracle@aqyxn dbs]$ scp spfiledb.ora orapwdb oracle@10.245.1.118:/opt/oracle/product/11.2.0/dbhome_1/dbs/
oracle@10.245.1.118's password:
spfiledb.ora                                                                          100% 2560     2.5KB/s   00:00   
orapwdb                                                                               100% 1536     1.5KB/s   00:00

[oracle@aqyxn oracle]$ cd /opt/oracle/product/11.2.0/dbhome_1/network/admin/
[oracle@aqyxn admin]$ ls
listener1104218下午5726.bak  samples     sqlnet1104218下午5726.bak  tnsnames1104218下午5726.bak
listener.ora                 shrept.lst  sqlnet.ora                 tnsnames.ora
[oracle@aqyxn admin]$ scp * oracle@10.245.1.118:/opt/oracle/product/11.2.0/dbhome_1/network/admin/
oracle@10.245.1.118's password:
listener1104218下午5726.bak                                                           100%  378     0.4KB/s   00:00   
listener.ora                                                                          100%  363     0.4KB/s   00:00   
samples: not a regular file
shrept.lst                                                                            100%  187     0.2KB/s   00:00   
sqlnet1104218下午5726.bak                                                             100%  215     0.2KB/s   00:00   
sqlnet.ora                                                                            100%  215     0.2KB/s   00:00   
tnsnames1104218下午5726.bak                                                           100%  332     0.3KB/s   00:00   
tnsnames.ora                                                                          100%  317     0.3KB/s   00:00   

[oracle@aqyxn db]$ cd /opt/oracle/oradata/db
[oracle@aqyxn db]$ ls
afiedt.buf