ASM在磁盘组间迁移数据文件

由于最近有一套使用ASM的系统需要更换存储，新的存储会创建新的的DG，然后把数据文件迁移到新的DG上，今天测试了一下ASM中磁盘组间迁移数据文件的操作。
命令参考官方文档：Database Backup and Recovery Reference
实施步骤过程如下：
1、查看数据文件的原始路径

SQL> set lines 200
SQL> col file_name for a60  
SQL> col tablespace_name for a40
SQL> select file_id,file_name,tablespace_name from dba_data_files;
   FILE_ID FILE_NAME                                                    TABLESPACE_NAME
---------- ------------------------------------------------------------ ----------------------------------------
         4 +DATADG/racdb/datafile/users.259.820580293                   USERS
         3 +DATADG/racdb/datafile/sysaux.257.820580293                  SYSAUX
         2 +DATADG/racdb/datafile/undotbs1.258.820580293                UNDOTBS1
         1 +DATADG/racdb/datafile/system.256.820580293                  SYSTEM
         5 +DATADG/racdb/datafile/example.267.820580341                 EXAMPLE
         6 +DATADG/racdb/datafile/undotbs2.268.820580397                UNDOTBS2
6 rows selected.
SQL> 
SQL>

 
2、通过RMAN进行迁移操作

RMAN> 
RMAN> sql 'alter tablespace EXAMPLE offline';
using target database control file instead of recovery catalog
sql statement: alter tablespace EXAMPLE offline
RMAN> 
RMAN> backup device type disk as copy datafile 5 format '+DATADG2';
Starting backup at 12-JUL-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=128 instance=racdb1 devtype=DISK
channel ORA_DISK_1: starting datafile copy
input datafile fno=00005 name=+DATADG/racdb/datafile/example.267.820580341
output filename=+DATADG2/racdb/datafile/example.256.820602925 tag=TAG20130712T171524 recid=2 stamp=820602925
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
Finished backup at 12-JUL-13
RMAN> 
RMAN> switch tablespace EXAMPLE to copy;
datafile 5 switched to datafile copy "+DATADG2/racdb/datafile/example.256.820602925"
RMAN> 
RMAN> 
RMAN> 
RMAN> sql 'alter tablespace EXAMPLE online';
sql statement: alter tablespace EXAMPLE online
RMAN> 
用switch操作的时候，被操作的表空间或则数据文件必须处于离线状态
3、查看迁移后的表空间数据文件情况
SQL> set lines 200
SQL> col file_name for a60
SQL> col tablespace_name for a40
SQL> select file_id,file_name,tablespace_name from dba_data_files;
   FILE_ID FILE_NAME                                                    TABLESPACE_NAME
---------- ------------------------------------------------------------ ----------------------------------------
         4 +DATADG/racdb/datafile/users.259.820580293                   USERS
         3 +DATADG/racdb/datafile/sysaux.257.820580293                  SYSAUX
         2 +DATADG/racdb/datafile/undotbs1.258.820580293                UNDOTBS1
         1 +DATADG/racdb/datafile/system.256.820580293                  SYSTEM
         5 +DATADG2/racdb/datafile/example.256.820602925                EXAMPLE
         6 +DATADG/racdb/datafile/undotbs2.268.820580397                UNDOTBS2
6 rows selected.
SQL>