ORA-39006、ORA-39065、ORA-01403、ORA-39097
上午客户反馈无法进行数据库到处,请求解决改问题,报错如下:
[oracle@xxxxx~]$ expdp \'/ as sysdba\' directory=dmpdir dumpfile=xxxx.dmp logfile=xxxxx.log tables=xxx.xxxxquery=\"where LEDGER_ID\=2024\"
Export: Release 11.2.0.4.0 - Production on Fri May 13 09:45:42 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-01403: no data found
ORA-39097: Data Pump job encountered unexpected error 100
改问题是dump相关视图问题,执行一下SQL,重新生成DATAPUMP API相关视图信息即可
SQL> @?/rdbms/admin/catmeta.sql
SQL> @?/rdbms/admin/catmet2.sql
SQL> @?/rdbms/admin/utlrp.sql
重新导出数据正常执行
[oracle@xxxx~]$ expdp \'/ as sysdba\' directory=dmpdir dumpfile=xxxx.dmp logfile=xxxx.log tables=GL.GL_LEDGERS query=\"where LEDGER_ID\=2024\"
Export: Release 11.2.0.4.0 - Production on Fri May 13 09:52:49 2022
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01": "/******** AS SYSDBA" directory=dmpdir dumpfile=xxxxx.dmp logfile=xxxxx.log tables=xx.xxxx query="where LEDGER_ID=2024"
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 128 KB
......
......
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
. . exported "GL"."GL_LEDGERS" 42.96 KB 1 rows
Master table "SYS"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SYS.SYS_EXPORT_TABLE_01 is:
/u03/app/oracle/dumpfile/xxxxxx.dmp
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Fri May 13 09:53:20 2022 elapsed 0 00:00:30
作者:hanglinux
出处:https://www.cnblogs.com/hanglinux/p/16265640.html
版权:本作品采用「署名-非商业性使用-相同方式共享 4.0 国际」许可协议进行许可。
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 全程不用写代码,我用AI程序员写了一个飞机大战
· DeepSeek 开源周回顾「GitHub 热点速览」
· MongoDB 8.0这个新功能碉堡了,比商业数据库还牛
· 记一次.NET内存居高不下排查解决与启示
· 白话解读 Dapr 1.15:你的「微服务管家」又秀新绝活了
2020-05-13 安装cvuqdisk-1.0.9-1.rpm报错