数据库移植方法

 

********************************************

数据库移植方法

********************************************

1、创建pfile,关闭数据库
create pfile from spfile;
shutdown immediate

2、使用dd或者cp拷贝数据文件，日志文件，控制文件

3、使用pfile启动数据库
修改pfile中的控制文件路径问新的文件或者裸设备路径
startup nomount pfile='';
create spfile from pfile;
alter database mount;

4、更改文件名称路径（select NAME FROM v$datafile;select * from v$logfile）
alter database rename file '/opt/oracle/oradata/shtd/indx01.dbf' to '/u02/oradata/shtd/indx01.dbf';
alter database rename file '/opt/oracle/oradata/shtdredo01.log'   to '/u01/redolog/redo01.log';
alter database rename file '/opt/oracle/oradata/shtdredo02.log'   to '/u01/redolog/redo02.log';
alter database rename file '/opt/oracle/oradata/shtdredo03.log'   to '/u01/redolog/redo03.log';
alter database rename file '/opt/oracle/oradata/shtd/system01.dbf'  to '/u02/oradata/shtd/system01.dbf';
alter database rename file '/opt/oracle/oradata/shtd/temp01.dbf'   to '/u02/oradata/shtd/temp01.dbf';
alter database rename file '/opt/oracle/oradata/shtd/tools01.dbf'  to '/u02/oradata/shtd/tools01.dbf';
alter database rename file '/opt/oracle/oradata/shtd/undotbs01.dbf' to '/u02/oradata/shtd/undotbs01.dbf';
alter database rename file '/opt/oracle/oradata/shtd/users01.dbf'  to '/u02/oradata/shtd/users01.dbf';

5、打开数据库
alter database open;