数据库文件的迁移

shinewaysoft

                        
                                     数据库文件的迁移

1、拷贝数据文件到盘阵
  SQL>shutdown immediate;
cp /opt/app/oracle/oradata/fjkdsw/redo01.log      /mnt/kdsw/redofile/redo01.log
cp /opt/app/oracle/oradata/fjkdsw/redo02.log      /mnt/kdsw/redofile/redo02.log
cp /opt/app/oracle/oradata/fjkdsw/redo03.log      /mnt/kdsw/redofile/redo03.log
cp /opt/app/oracle/oradata/fjkdsw/system01.dbf    /mnt/kdsw/datafile/system01.dbf
cp /opt/app/oracle/oradata/fjkdsw/undotbs01.dbf   /mnt/kdsw/datafile/undotbs01.dbf
cp /opt/app/oracle/oradata/fjkdsw/cwmlite01.dbf   /mnt/kdsw/datafile/cwmlite01.dbf
cp /opt/app/oracle/oradata/fjkdsw/drsys01.dbf     /mnt/kdsw/datafile/drsys01.dbf
cp /opt/app/oracle/oradata/fjkdsw/example01.dbf   /mnt/kdsw/datafile/example01.dbf
cp /opt/app/oracle/oradata/fjkdsw/indx01.dbf      /mnt/kdsw/datafile/indx01.dbf
cp /opt/app/oracle/oradata/fjkdsw/tools01.dbf     /mnt/kdsw/datafile/tools01.dbf
cp /opt/app/oracle/oradata/fjkdsw/users01.dbf     /mnt/kdsw/datafile/users01.dbf
cp /oradata/statindex01.dbf                       /mnt/kdsw/datafile/statindex01.dbf
cp /oradata/statdata01.dbf                        /mnt/kdsw/datafile/statdata01.dbf
cp /oradata/statdata02.dbf                        /mnt/kdsw/datafile/statdata02.dbf
cp /opt/app/oracle/oradata/blues/page00db2.dbf    /mnt/kdsw/datafile/page00db2.dbf
cp /opt/app/oracle/oradata/blues/page000db2.dbf   /mnt/kdsw/datafile/page000db2.dbf
cp /opt/app/oracle/oradata/blues/pagerbs0.dbf     /mnt/kdsw/datafile/pagerbs0.dbf
cp /opt/app/oracle/oradata/harmony.dbf            /mnt/kdsw/datafile/harmony.dbf
cp /opt/app/oracle/oradata/rap01.dbf              /mnt/kdsw/datafile/rap01.dbf
cp /oradata/system02.dbf                          /mnt/kdsw/datafile/system02.dbf
2、拷贝控制文件到盘阵
cp /opt/app/oracle/oradata/fjkdsw/control01.ctl /mnt/kdsw/controlfile/control01.ctl
cp /opt/app/oracle/oradata/fjkdsw/control02.ctl /mnt/kdsw/controlfile/control02.ctl
cp /opt/app/oracle/oradata/fjkdsw/control03.ctl /mnt/kdsw/controlfile/control03.ctl
3、更改控制文件路径
bash-2.05$ sqlplus " / as sysdba"
SQL*Plus: Release 9.2.0.1.0 - Production on Wed May 23 14:34:10 2007
Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.
Connected to an idle instance.
SQL> create pfile='./init.ora' from spfile='./spfilefjkdsw.ora';
SQL>shutdown
修改/opt/app/oracle/product/9.2.0/dbs/init.ora 中控制文件路径为盘阵存放控制文件的路径
SQL>create spfile='./spfilefjkdsw.ora' from pfile='./init.ora';  
SQl>startup mount;
4、更改数据文件的路径为盘阵路径
alter database rename file '/opt/app/oracle/oradata/fjkdsw/redo01.log'    to '/mnt/kdsw/redofile/redo01.log';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/redo02.log'    to '/mnt/kdsw/redofile/redo02.log';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/redo03.log'    to '/mnt/kdsw/redofile/redo03.log';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/system01.dbf'  to '/mnt/kdsw/datafile/system01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/undotbs01.dbf' to '/mnt/kdsw/datafile/undotbs01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/cwmlite01.dbf' to '/mnt/kdsw/datafile/cwmlite01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/drsys01.dbf'   to '/mnt/kdsw/datafile/drsys01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/example01.dbf' to '/mnt/kdsw/datafile/example01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/indx01.dbf'    to '/mnt/kdsw/datafile/indx01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/tools01.dbf'   to '/mnt/kdsw/datafile/tools01.dbf';
alter database rename file '/opt/app/oracle/oradata/fjkdsw/users01.dbf'   to '/mnt/kdsw/datafile/users01.dbf';
alter database rename file '/oradata/statindex01.dbf'                     to '/mnt/kdsw/datafile/statindex01.dbf';
alter database rename file '/oradata/statdata01.dbf'                      to '/mnt/kdsw/datafile/statdata01.dbf';
alter database rename file '/oradata/statdata02.dbf'                      to '/mnt/kdsw/datafile/statdata02.dbf';
alter database rename file '/opt/app/oracle/oradata/blues/page00db2.dbf'  to '/mnt/kdsw/datafile/page00db2.dbf';
alter database rename file '/opt/app/oracle/oradata/blues/page000db2.dbf' to '/mnt/kdsw/datafile/page000db2.dbf';
alter database rename file '/opt/app/oracle/oradata/blues/pagerbs0.dbf'   to '/mnt/kdsw/datafile/pagerbs0.dbf';
alter database rename file '/opt/app/oracle/oradata/harmony.dbf'          to '/mnt/kdsw/datafile/harmony.dbf';
alter database rename file '/opt/app/oracle/oradata/rap01.dbf'            to '/mnt/kdsw/datafile/rap01.dbf';
alter database rename file '/oradata/system02.dbf'                        to '/mnt/kdsw/datafile/system02.dbf';
5、更改临时文件路径
bash-2.05$ cp /opt/app/oracle/oradata/fjkdsw/temp01.dbf /opt/app/oracle/oradata/fjkdsw/temp01.dbf.old
bash-2.05$ cp /opt/app/oracle/oradata/blues/PAGETEMP0.dbf /opt/app/oracle/oradata/blues/PAGETEMP0.dbf.old
bash-2.05$ cp /opt/app/oracle/oradata/raptemp01.dbf /opt/app/oracle/oradata/raptemp01.dbf.old
SQL> alter database tempfile '/opt/app/oracle/oradata/fjkdsw/temp01.dbf' drop;  
SQL> alter database tempfile '/opt/app/oracle/oradata/blues/PAGETEMP0.dbf' drop;  
SQL> alter database tempfile '/opt/app/oracle/oradata/raptemp01.dbf' drop;   
SQL>alter database open;
SQL> alter tablespace TEMP add tempfile '/mnt/kdsw/datafile/temp01.dbf' size 8196M reuse;
SQL> alter tablespace RAPTEMP add tempfile '/mnt/kdsw/datafile/PAGETEMP0.dbf' size 3096M reuse;
SQL> alter tablespace PAGETEMP0 add tempfile '/mnt/kdsw/datafile/raptemp01.dbf' size 3096M reuse;
6、修改归档路径
SQL> alter system set log_archive_dest_1='LOCATION=/mnt/kdsw/archive' scope=both;
System altered.
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Disabled
Archive destination            /mnt/kdsw/archive
Oldest online log sequence     124
Next log sequence to archive   126
Current log sequence           126


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/29219/showart_311378.html