签到成功

知道了

CNDBA社区CNDBA社区

Oracle 19c TTS ORA-19721: Cannot find data file with absolute file number 错误说明

2021-02-06 00:08 193 0 原创 Oracle 19c
作者: Dave

在做Oracle 19c TTS 实验的时候,impdp 时报如下错误:https://www.cndba.cn/dave/article/4395

[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上有一篇提到重新操作一遍。

https://www.cndba.cn/dave/article/4395

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

https://www.cndba.cn/dave/article/4395
https://www.cndba.cn/dave/article/4395https://www.cndba.cn/dave/article/4395
https://www.cndba.cn/dave/article/4395
https://www.cndba.cn/dave/article/4395https://www.cndba.cn/dave/article/4395

[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]$

数据不会撒谎,操作时还是要仔细一些,随笔记录也提醒下自己。 https://www.cndba.cn/dave/article/4395

https://www.cndba.cn/dave/article/4395

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

用户评论
* 以下用户言论只代表其个人观点,不代表CNDBA社区的观点或立场
Dave

Dave

关注

人的一生应该是这样度过的:当他回首往事的时候,他不会因为虚度年华而悔恨,也不会因为碌碌无为而羞耻;这样,在临死的时候,他就能够说:“我的整个生命和全部精力,都已经献给世界上最壮丽的事业....."

  • 1832
    原创
  • 2
    翻译
  • 417
    转载
  • 119
    评论
  • 访问:3164769次
  • 积分:2888
  • 等级:核心会员
  • 排名:第1名
精华文章
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        Copyright © 2016 All Rights Reserved. Powered by ZhiXinTech · 皖ICP备19020168号·

        QQ交流群