在做Oracle 19c TTS 实验的时候，impdp 时报如下错误：

[oracle@www.cndba.cn ~]$ impdp dave/dave@192.168.74.202:1521/DAVE directory=dpump_dir DUMPFILE=cndba.dmp EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS transport_datafiles='/u01/app/oracle/oradata/CNDBA/dave7.dbf','/u01/app/oracle/oradata/CNDBA/dave8.dbf'

Import: Release 19.0.0.0.0 - Production on Fri Feb 5 23:00:43 2021
Version 19.10.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "DAVE"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "DAVE"."SYS_IMPORT_TRANSPORTABLE_01":  dave/********@192.168.74.202:1521/DAVE directory=dpump_dir DUMPFILE=cndba.dmp EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS transport_datafiles=/u01/app/oracle/oradata/CNDBA/dave7.dbf,/u01/app/oracle/oradata/CNDBA/dave8.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
ORA-39123: Data Pump transportable tablespace job aborted
ORA-19721: Cannot find data file with absolute file number 15 in tablespace CNDBA

Job "DAVE"."SYS_IMPORT_TRANSPORTABLE_01" stopped due to fatal error at Fri Feb 5 23:00:47 2021 elapsed 0 00:00:03

[oracle@www.cndba.cn ~]$ oerr ora 19721
19721, 00000, "Cannot find data file with absolute file number %s in tablespace %s"
// *Cause:   One of the data files that should have been in the pluggable
//           set was not found. Alternatively, one of the data files in the
//           pluggable set had already been plugged in from a previous
//           import job and so was excluded from the pluggable set.
// *Action:  Ensure that all of the data files are specified using the import
//           command-line option or parameter files. Also, ensure that none of
//           the data files have already been plugged into the database.
[oracle@www.cndba.cn ~]$

前期步骤没有发现什么问题，开始以为是19c 的bug，在MOS上搜了半天，并没有找到匹配的内容。 不过MOS上有一篇提到重新操作一遍。 http://www.cndba.cn/cndba/dave/article/4395http://www.cndba.cn/cndba/dave/article/4395

第二遍操作的时候，发现了故障的原因， 因为是19c 的CDB 架构，在复制数据文件的时候，不小心复制到了CDB的目录下，导致在PDB中无法识别到对应的数据文件，重新将数据文件复制到PDB 目录后导入成功。

[oracle@www.cndba.cn cndba]$ impdp dave/dave@192.168.74.202:1521/DAVE directory=dpump_dir DUMPFILE=cndba.dmp EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS transport_datafiles='/u01/app/oracle/oradata/CNDBA/dave/dave_11.dbf','/u01/app/oracle/oradata/CNDBA/dave/dave_12.dbf'

Import: Release 19.0.0.0.0 - Production on Fri Feb 5 23:57:46 2021
Version 19.10.0.0.0

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

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Master table "DAVE"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "DAVE"."SYS_IMPORT_TRANSPORTABLE_01":  dave/********@192.168.74.202:1521/DAVE directory=dpump_dir DUMPFILE=cndba.dmp EXCLUDE=TABLE_STATISTICS,INDEX_STATISTICS transport_datafiles=/u01/app/oracle/oradata/CNDBA/dave/dave_11.dbf,/u01/app/oracle/oradata/CNDBA/dave/dave_12.dbf
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
Processing object type TRANSPORTABLE_EXPORT/TABLE
Processing object type TRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK
Job "DAVE"."SYS_IMPORT_TRANSPORTABLE_01" successfully completed at Fri Feb 5 23:57:52 2021 elapsed 0 00:00:05

[oracle@www.cndba.cn cndba]$

数据不会撒谎，操作时还是要仔细一些，随笔记录也提醒下自己。

版权声明：本文为博主原创文章，未经博主允许不得转载。