Oracle自学笔记---在linux环境下转移数据文件

1查看数据文件的位置
SYS@ORCL>select file_name,tablespace_name from dba_data_files;

FILE_NAME                                                              TABLESPACE_NAME
---------------------------------------------------------------------- -------------------
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_97y3h799_.dbf        USERS
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_97y3h76j_.dbf     UNDOTBS1
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_97y3h75s_.dbf       SYSAUX
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_97y3h747_.dbf       SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_97y3mx28_.dbf      EXAMPLE


2.关闭数据库
SYS@ORCL>shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.


3.转移数据文件
[oracle@WZY datafile]$ cp /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_97y3h799_.dbf  /home/oracle/datafile_bak/o1_mf_users_97y3h799_.dbf


4.开启数据库到mount状态
SYS@ORCL>startup 
ORACLE instance started.


Total System Global Area  849530880 bytes
Fixed Size                  1339824 bytes
Variable Size             595594832 bytes
Database Buffers          247463936 bytes
Redo Buffers                5132288 bytes
Database mounted.
Database opened.


5.rename数据文件
SYS@ORCL>alter database rename file '/u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_97y3h799_.dbf' to '/home/oracle/datafile_bak/o1_mf_users_97y3h799_.dbf';


Database altered.

6.open数据库并查看数据文件位置
SYS@ORCL>alter database open;


Database altered.


SYS@ORCL>select file_name,tablespace_name from dba_data_Files;


FILE_NAME                                                              TABLESPACE_NAME
---------------------------------------------------------------------- -------------------
/home/oracle/datafile_bak/o1_mf_users_97y3h799_.dbf                    USERS
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_97y3h76j_.dbf     UNDOTBS1
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_97y3h75s_.dbf       SYSAUX
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_97y3h747_.dbf       SYSTEM
/u01/app/oracle/oradata/ORCL/datafile/o1_mf_example_97y3mx28_.dbf      EXAMPLE