由于数据目录已经满了需要将数据文件移动到另外一个分区,操作步骤

1.停应用,关闭监听

lsnrctl stop

2.关闭数据库

SQL> select file_name from dba_data_files;

FILE_NAME

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

/u01/app/oracle/oradata/orcl/users01.dbf

/u01/app/oracle/oradata/orcl/undotbs01.dbf

/u01/app/oracle/oradata/orcl/sysaux01.dbf

/u01/app/oracle/oradata/orcl/system01.dbf

/u01/app/oracle/oradata/orcl/xihu.dbf

/u01/app/oracle/oradata/orcl/example01.dbf

/oradata2/zhiyoubao.dbf

/oradata2/SETTLE01.DBF

/u01/app/oracle/oradata/orcl/ebiz.dbf

/u01/app/oracle/oradata/orcl/zhyh.dbf

/u01/app/oracle/oradata/orcl/lnykt.dbf

我们需要将/u01/app/oracle/oradata/orcl/users01.dbf移动到/oradata下

alter system checkpoint;(至少四次)

shutdown immediate;

[oracle@dbserver oradata2]$ pwd

/oradata2

[oracle@dbserver oradata2]$ mv /u01/app/oracle/oradata/orcl/users01.dbf ./

[oracle@dbserver oradata2]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 23 09:13:38 2016

Connected to an idle instance.

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1202556928 bytes

Fixed Size 2212816 bytes

Variable Size 922750000 bytes

Database Buffers 268435456 bytes

Redo Buffers 9158656 bytes

Database mounted.

SQL> alter database rename file '/u01/app/oracle/oradata/orcl/users01.dbf' to '/oradata2/users01.dbf';

Database altered.

SQL> alter database open;

Database altered.

ITPub博客

非归档模式下的数据文件路径修改