ORA-39405: Oracle Data Pump Does Not Support Importing From A Source Database With TSTZ Version

好记忆不如烂笔头abc

已于 2025-02-26 13:21:07 修改

阅读量1.7k

点赞数 17

文章标签：数据库 oracle

于 2024-07-23 10:38:21 首次发布

本文链接：https://blog.csdn.net/jycjyc/article/details/140628604

版权

现象：源端21.3，目标端19.15 oracle rac，已有其它pdb生产业务，impdp报错：

ORA-39405: Oracle Data Pump Does Not Support Importing From A Source Database With TSTZ Version 35 into a target database with TSTZ version 32.

由于官方给出的参考需要目标端停库打补丁，动作太大无法满足。

检查源端的库很小10多G，本次可采用方法是：

从在目标端使用exp的方式连接到源端进行备份（不是expdp)

目标端连接源端导出：
exp system/xxx@192.168.23.54:1521/db owner=XXX1,XXX2 file=/oracleback/20240722/exp_xxx.dmp log=exp_xxx20240722.log buffer=65535000

目标端创建好相应的用户，然后imp
imp system/xxx file=/oracleback/20240722/exp_xxx.dmp log=exp_xxx20240722.log full=y

目标端导出源端dmp的操作记录：

导出也需要检查日志是否有异常：后期结合导入判断是否需要单独修复问题。

目标端操作记录：

由于删除用户可能失败ORA-01940，所以快速的做法是先锁定用户，然后重启pdb再执行删除操作。

最后检查表空间占用

编译失效对象imp导入的时候一定要检查导入日志是否有异常？？？如下的问题就是通过检查分析导入日志发现的问题：

注意exp导出不能加direct=y 否则导入可能报错：

Oracle Data Pump impdp报ORA-39405，手动更新DST v42版本

ORA-39405: Oracle Data Pump Does Not Support Importing From A Source Database With TSTZ Version (Doc ID 2793311.1)

Oracle Database - Enterprise Edition - Version 19.0.0.0 and later
Oracle Cloud Infrastructure - Database Service - Version N/A to N/A [Release 1.0]
Information in this document applies to any platform.

SYMPTOMS

Got below error while running import:
ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 35 into a target database with TSTZ version 34

CHANGES

Doing import with mismatch DST TZ version.

CAUSE

Oracle Data Pump does not support importing from a source database with TSTZ version 35 or 36 into a target database with TSTZ version 34.

OR

ORA-39405: Oracle Data Pump does not support importing from a source database with TSTZ version 34 into a target database with TSTZ version 32.

SOLUTION

This error is expected because the Oracle Data Pump does not support importing from a source database with higher TSTZ version into a target database with lower TSTZ version.

Please upgrade the DST TZ version of the target database to higher or equal to source database DST TZ version.

Applying the DSTv34 update for the Oracle Database (Doc ID 2602555.1)
Applying the DSTv36 update for the Oracle Database(Doc ID 2767770.1)
Applying the DSTv35 update for the Oracle Database(Doc ID 2676922.1)

for any latest DST patches, refer this document section C.1) Oracle RDBMS and OJVM DST-related notes

Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches (Doc ID 412160.1)

REFERENCES

NOTE:2767770.1 - Applying the DSTv36 update for the Oracle Database
NOTE:2676922.1 - Applying the DSTv35 update for the Oracle Database
NOTE:2602555.1 - Applying the DSTv34 update for the Oracle Database
NOTE:412160.1 - Primary Note DST FAQ : Updated DST Transitions and New Time Zones in Oracle RDBMS and OJVM Time Zone File Patches