RAC下表空间文件迁移

把表空间TBS_DATA的文件从磁盘组DATADG迁移到NEW_DATADG中

--查看表空间文件
sqlplus / as sysdba

SQL>

set line 800
col TABLESPACE_NAME for a20
col file_name for a50
col bytes for 999999999.99
select TABLESPACE_NAME,FILE_NAME,bytes/1024/1024 as Mebi,status from dba_data_files
where TABLESPACE_NAME='TBS_DATA'
order by TABLESPACE_NAME,FILE_NAME;

--迁移文件offline
ALTER DATABASE DATAFILE '+DATADG/racdb/datafile/tbs_data_0000.dbf' OFFLINE;

--asm复制
[grid@rac2 ~]$ asmcmd
cp +DATADG/racdb/datafile/tbs_data_0000.dbf +NEW_DATADG/racdb/datafile/tbs_data_0000.dbf

--改名
ALTER DATABASE RENAME FILE '+DATADG/racdb/datafile/tbs_data_0000.dbf' TO '+NEW_DATADG/racdb/datafile/tbs_data_0000.dbf';
RECOVER DATAFILE '+NEW_DATADG/racdb/datafile/tbs_data_0000.dbf';
ALTER DATABASE DATAFILE '+NEW_DATADG/racdb/datafile/tbs_data_0000.dbf' ONLINE;

--删除原来文件
ALTER DISKGROUP DATADG DROP FILE '+DATADG/racdb/datafile/tbs_data_0000.dbf';