# rman将本地数据文件迁移到asm
问题情况:表空间建立在RAC1本地文件位置,RAC2数据库连接应用无法读取RAC1文件,造成应用程序报错
1、脱机表空间
~~~
alter tablespace bdcdj_gx offline
~~~
2、rman 拷贝文件
~~~
copy datafile '/home/orcl/app/oracle/product/12.2.0/db_1/dbs/D:APPADMINISTRATORORADATAORCLCDCDJ_GX15.DBF' to '+DG1';
~~~
Recovery Manager: Release 11.2.0.1.0 - Production on Fri Jul 7 11:25:41 2023
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL (DBID=1446281423)
RMAN> copy datafile '/home/orcl/app/oracle/product/12.2.0/db_1/dbs/D:APPADMINISTRATORORADATAORCLBCDCJ_GX15.DBF' to '+DG1';
Starting backup at 07-JUL-23
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=5146 instance=orcl1 device type=DISK
channel ORA_DISK_1: starting datafile copy
input datafile file number=00059 name=/home/orcl/app/oracle/product/12.2.0/db_1/dbs/D:APPADMINISTRATORORADATAORCLBDCDJ_GX15.DBF
**output file name=+DG1/orcl/datafile/cdcdj.2502.1141558015** tag=TAG20230707T112655 RECID=1376 STAMP=1141558032
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
Finished backup at 07-JUL-23
Starting Control File and SPFILE Autobackup at 07-JUL-23
piece handle=/backup02/guotu/rac01_orcl1/20230706/orcl1_lev1_202307062000_c-1446281423-20230707-02 comment=NONE
Finished Control File and SPFILE Autobackup at 07-JUL-23
3、grid 用户验证数据文件拷贝成功
~~~
ASMCMD> ls
~~~
4、根据ASM磁盘文件位置修改数据文件路径
~~~sql
alter tablespace apollo rename datafile '/home/orcl/app/oracle/product/12.2.0/db_1/dbs/D:APPADMINISTRATORORADATAORCLBDCDJ_GX15.DBF' to '+DG1/orcl/datafile/cdcdj.2502.1141558015'
~~~
5、联机表空间
~~~
alter tablespace bdcdj_gx online
~~~
通过ASMCMD CP命令拷贝数据文件
ASMCMD>cp /oracle/app/oracle/product/11.2.0/dbs/firsoul01.dbf .
copying /oracle/app/oracle/product/11.2.0/dbs/firsoul01.dbf -> +data/racdb/datafile/firsoul01.dbf