1.11g Rac 环境 数据文件从本地文件目录迁移至共享盘

本文提供了两种方式将数据文件从本地文件目录迁移至 共享盘，将过程中遇到的一些问题在此记录，仅个人遇到情况，实际生产情况需根据自身环境、进行测试后再实施变更。

1.环境信息

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
双节点 RAC

2.实施过程

------------------------------------------------方法1-----------------------------------------------------------------------

参考来源：How to Move a Datafile from Filesystem to ASM Using ASMCMD CP Command. (Doc ID 1610615.1)

SYMPTOMS

Datafile wrongly added on file system instead of diskgroup.

CAUSE

This is not a System tablespace datafile

SOLUTION

1) Make sure the datafile to be moved is OFFLINE

SQL> alter system switch logfile;

System altered.

SQL> select file_name, file_id from dba_data_files;

FILE_NAME FILE_ID

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

/<FILESYSTEM_PATH>/oradata/<FILENAME.dbf> 6

SQL> alter database datafile 6 offline;

Database altered.

SQL> select file_name, file_id, online_status from dba_data_files where file_id=6;

FILE_NAME FILE_ID ONLINE_STATUS  /<FILESYSTEM_PATH>/oradata/<FILENAME.dbf> 6 RECOVER

2) Use ASMCMD to copy the file from filesystem to the diskgroup