RAC数据文件创建到本地路径错误

# 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