Linux同平台数据库整体物理迁移

 ## 0.系统版本： ##     [root@DB-A tmp]# uname -a     Linux DB-A 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux     [root@DB-A tmp]# cat /etc/issue     Red Hat Enterprise Linux Server release 6.4 (Santiago)     Kernel \r on an \m ## 1.A数据库当前信息 ##     select status from v$instance union all     select open_mode from v$database union all     select * from v$version where rownum = 1; ## 2.确认参数文件的位置 ##     show parameter pfile 

create pfile from spfile;

set linesize 140 pagesize 100
select name from v$datafile union all
select name from v$tempfile union all
select name from v$controlfile union all
select member from v$logfile;

shutdown immediate;

echo $ORACLE_BASE
/ora/app/oracle
tar -zcvf /tmp/oracle.tar.gz /ora/app/oracle

 ## 0.系统版本： ##     [root@DB-B irnop]# uname -a     Linux DB-B 2.6.32-431.el6.x86_64 #1 SMP Sun Nov 10 22:19:54 EST 2013 x86_64 x86_64 x86_64 GNU/Linux     [root@DB-B irnop]# cat /etc/issue     Red Hat Enterprise Linux Server release 6.5 (Santiago)     Kernel \r on an \m ## 1.安装依赖包和调整系统参数 ## 略。可参考：[http://www.cnblogs.com/jyzhao/p/3891769.html](http://www.cnblogs.com/jyzhao/p/3891769.html) ## 2.解压ORACLE_HOME到B机器上规划的软件安装目录：/u01/app/oracle ##     tar zxvf oracle.tar.gz  解压后的oracle目录直接mv到/u01/app下 ## 3.修改参数文件pfile并启动数据库到nomount ## 根据B机器实际情况修改数据库占用内存的值，并确认参数文件中写的路径都是存在的。     `startup nomount pfile='$ORACLE_HOME/dbs/initirnop.ora'` 

SQL> startup nomount pfile='$ORACLE_HOME/dbs/initirnop.ora'
ORACLE instance started.

Total System Global Area 2.3717E+10 bytes
Fixed Size  2239176 bytes
Variable Size1.3153E+10 bytes
Database Buffers 1.0536E+10 bytes
Redo Buffers   25612288 bytes

SQL> alter database mount;

Database altered.

set linesize 140 pagesize 100
select 'alter database rename file '''||name||''' to ''/xxx'||name||''';' from v$datafile union all
select 'alter database rename file '''||name||''' to ''/xxx'||name||''';' from v$tempfile union all
select 'alter database rename file '''||member||''' to ''/xxx'||member||''';' from v$logfile;

old_name： /xxx/oradata
new_name： /new/oradata  

select name from v$datafile union all
select name from v$tempfile union all
select member from v$logfile;

chown -R oracle:oinstall /new/oradata

SQL> alter database open;