修改Oracle数据文件名及数据文件存放路径

更改Oracle数据文件名及数据文件存放路径

SQL> select * from v$dbfile;

     FILE# NAME

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

         1 /db2/oracle/oradata/db2/system01.dbf

         2 /db2/oracle/oradata/db2/sysaux01.dbf

         3 /db2/oracle/oradata/db2/undotbs01.dbf

         4 /db2/oracle/oradata/db2/users01.dbf

         5 /db2/oracle/product/11.2.0/db_1/dbs/D:ORACLE11GADMINORADATAADMINgg01.dbf

         6 /db2/oracle/oradata/db2/db201.dbf

一、离线修改（需要关闭数据库进行修改）

[oracle@db1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 26 17:43:38 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

[oracle@db1 ~]$ mv /db2/oracle/product/11.2.0/db_1/dbs/D\:ORACLE11GADMINORADATAADMINgg01.dbf  /db2/oracle/oradata/db2/gg01.dbf

SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 26 17:48:31 2012

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup mount

ORACLE instance started.

Total System Global Area  521936896 bytes

Fixed Size      2214936 bytes

Variable Size    163578856 bytes

Database Buffers   352321536 bytes

Redo Buffers      3821568 bytes

Database mounted.

SQL> alter database rename file '/db2/oracle/product/11.2.0/db_1/dbs/D\:ORACLE11GADMINORADATAADMINgg01.dbf' to '/db2/oracle/oradata/db2/gg01.dbf';

Database altered.

SQL>