ORA-15046: ASM file name '……TEST.268.940854177' is not in single-file creation form

场景：11g RAC向12c RAC传输表空间

在向ASM磁盘地址里复制文件时

ASMCMD> cp /backup/TEST.268.940854177 +data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile
copying /backup/TEST.268.940854177 -> +data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile/TEST.268.940854177
ASMCMD-8016: copy source '/backup/TEST.268.940854177' and target '+data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile/TEST.268.940854177' failed
ORA-15056: additional error message
ORA-15046: ASM file name '+data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile/TEST.268.940854177' is not in single-file creation form
ORA-06512: at "SYS.X$DBMS_DISKGROUP", line 486
ORA-06512: at line 3 (DBD ERROR: OCIStmtExecute)

参考oracle官方文档452158.1和1468566.1

我本身就是用的452158.1的方式，证明不行

再看1468566.1

ASMCMD> cp /backup/TEST.268.940854177 +data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile/TEST
copying /backup/TEST.268.940854177 -> +data/orcl/4C5F367B71DA36B5E0536538A8C0AD64/datafile/TEST
ASMCMD> mkalias TEST TEST.268.940854177
ORA-15032: not all alterations performed
ORA-15177: cannot operate on system aliases (DBD ERROR: OCIStmtExecute)

呵呵

然后我干脆修改导入时的参数transport_datafiles

[oracle@rac1 ~]$ impdp system/oracle_4U@shihong_db directory=backup dumpfile=test01.dmp transport_datafiles= +DATA/ORCL/4C5F367B71DA36B5E0536538A8C0AD64/DATAFILE/TEST remap_schema=source_test:target_test logfile=test.log

Import: Release 12.1.0.2.0 - Production on Sun Apr 9 13:56:46 2017

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Source time zone version is 14 and target time zone version is 18.
Source time zone is +00:00 and target time zone is -07:00.
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/********@shihong_db directory=backup dumpfile=test01.dmp transport_datafiles=+DATA/ORCL/4C5F367B71DA36B5E0536538A8C0AD64/DATAFILE/TEST remap_schema=source_test:target_test logfile=test.log 
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Sun Apr 9 13:57:15 2017 elapsed 0 00:00:15

成功了，看看数据有没有正常导入

SQL> show user
USER is "TARGET_TEST"
SQL> show con_name

CON_NAME
------------------------------
SHIHONG_DB
SQL> select * from t1;

        ID NAME
---------- ------------------------------
         1 AAAAA
         2 BBBBB

正常导入