Oracle数据库文件迁移步骤

（1）首先确认需要迁移的数据库文件

SQL> select name from v$controlfile;

NAME

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

D:ORACLEORADATAXSFREECONTROL01.CTL

D:ORACLEORADATAXSFREECONTROL02.CTL

SQL> select name from v$datafile;

D:ORACLEORADATAXSFREESYSTEM01.DBF

D:ORACLEORADATAXSFREESYSAUX01.DBF

D:ORACLEORADATAXSFREEUNDOTBS01.DBF

D:ORACLEORADATAXSFREEUSERS01.DBF

SQL> select member from v$logfile;

MEMBER

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

D:ORACLEORADATAXSFREEREDO01.LOG

D:ORACLEORADATAXSFREEREDO02.LOG

D:ORACLEORADATAXSFREEREDO03.LOG

SQL> select name from v$tempfile;

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

D:ORACLEORADATAXSFREETEMP01.DBF

（2）创建pfile，备份spfile

SQL> create pfile from spfile;

move SPFILEXSFREE.ORA SPFILEXSFREE.ORA_bak

（3）关闭数据库

SQL> shutdown immediate;

（4）迁移数据库文件

将D:oracleoradata下的文件复制到D:oracleoradata_bak下（本测试是将oradata目录下的数据库文件迁移至oradata_bak下）

（5）修改pfile中控制文件路径

*.control_files='D:oracleoradata_bakxsfreecontrol01.ctl','D:oracleoradata_bakxsfreecontrol02.ctl'

（6）rename文件

SQL> startup mount pfile='D:oracleproduct11.2.0dbhome_1databaseINITxsfree.ORA';

SQL> alter database rename file 'D:ORACLEORADATAXSFREESYSTEM01.DBF' to 'D:ORACLEORADATA_BAKXSFREESYSTEM01.DBF';

SQL> alter database rename file 'D:ORACLEORADATAXSFREESYSAUX01.DBF' to 'D:ORACLEORADATA_BAKXSFREESYSAUX01.DBF';

SQL> alter database rename file 'D:ORACLEORADATAXSFREEUNDOTBS01.DBF' to 'D:ORACLEORADATA_BAKXSFREEUNDOTBS01.DBF';

SQL> alter database rename file 'D:ORACLEORADATAXSFREEUSERS01.DBF' to 'D:ORACLEORADATA_BAKXSFREEUSERS01.DBF';

SQL> alter database rename file 'D:ORACLEORADATAXSFREEREDO01.LOG' to 'D:ORACLEORADATA_BAKXSFREEREDO01.LOG';

SQL> alter database rename file 'D:ORACLEORADATAXSFREEREDO02.LOG' to 'D:ORACLEORADATA_BAKXSFREEREDO02.LOG';

SQL> alter database rename file 'D:ORACLEORADATAXSFREEREDO03.LOG' to 'D:ORACLEORADATA_BAKXSFREEREDO03.LOG';

SQL> alter database rename file 'D:ORACLEORADATAXSFREETEMP01.DBF' to 'D:ORACLEORADATA_BAKXSFREETEMP01.DBF';

（7）打开数据库

SQL> alter database open;

SQL> create spfile from pfile='D:oracleproduct11.2.0dbhome_1databaseINITxsfree.ORA';

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!