ORA-39773: parse of metadata stream failed---惜分飞

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：ORA-39773: parse of metadata stream failed故障处理

作者：惜分飞©版权所有[未经本人同意,不得以任何形式转载,否则有进一步追究法律责任的权利.]

客户expdp导出数据,在写入生成SYS_EXPORT_SCHEMA表所在的users表空间不足,导致expdp报部分异常

Export: Release 11.2.0.4.0 - Production on Thu Feb 27 15:12:36 2025

 

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, Real Application Clusters, Automatic Storage Management, OLAP,

Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting "XFF"."SYS_EXPORT_SCHEMA_95":XFF/**** directory=DUMP dumpfile=20250227.dmp logfile=20250227.log schemas=XFF

Estimate in progress using BLOCKS method...

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

ORA-39171: Job is experiencing a resumable wait.

ORA-01653: unable to extend table XFF.SYS_EXPORT_SCHEMA_95 by 128 in tablespace USERS

Total estimation using BLOCKS method: 481.9 GB

Processing object type SCHEMA_EXPORT/USER

Processing object type SCHEMA_EXPORT/SYSTEM_GRANT

Processing object type SCHEMA_EXPORT/ROLE_GRANT

Processing object type SCHEMA_EXPORT/DEFAULT_ROLE

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

Processing object type SCHEMA_EXPORT/MATERIALIZED_VIEW

Processing object type SCHEMA_EXPORT/JOB

. . exported "XFF"."PUB_WORKINGTASKLOG"              88.09 GB  112681 rows

. . exported "XFF"."SM_BUSILOG_DEFAULT"              51.94 GB 3149092 rows

. . exported "XFF"."FFW_DISTRIBUTESUBTASK"           46.47 GB  552214 rows

. . exported "XFF"."GL_DETAIL"                       11.32 GB 16214805 rows

…………

. . exported "XFF"."ZDP_10000000RR8NKX"                  0 KB       0 rows

. . exported "XFF"."ZDP_10000000RTB1GI"                  0 KB       0 rows

. . exported "XFF"."ZDP_10000000RTB1GK"                  0 KB       0 rows

Master table "XFF"."SYS_EXPORT_SCHEMA_95" successfully loaded/unloaded

******************************************************************************

Dump file set for XFF.SYS_EXPORT_SCHEMA_95 is:

  /rman_bak/dump/20200227.dmp

Job "XFF"."SYS_EXPORT_SCHEMA_95" completed with 10 error(s) at Thu Feb 27 19:32:22 2025 elapsed 0 04:16:28

尝试把该dmp导入数据库,报ORA-31694/ORA-02354/ORA-39773错误

Import: Release 11.2.0.4.0 - Production on 星期日 3月 16 02:38:14 2025

 

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

;;;

连接到: 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-31694: 加载/卸载主表 "XFF"."SYS_IMPORT_FULL_01" 失败

ORA-02354: 导出/导入数据时出错

ORA-39773: parse of metadata stream failed

客户需要恢复其中的GL_DETAIL表数据,通过dul实现expdp dump文件转换sqlldr格式方法进行恢复,实现数据完美恢复

---

对于dmp(exp/expdp)文件,我们可以实现比较完美的恢复,最后限度抢救数据.如果你有oracle expdp/exp dmp被加密或者破坏,无法正常导入数据库,可以联系我们对其进行恢复处理:提供(ORACLE数据库恢复技术支持)：Phone:17813235971    Q Q:107644445    E-Mail:dba@xifenfei.com

 

• impdp 创建index提示ORA-00942: table or view does not exist
• impdp导入数据丢失sys授权问题分析
• EXP-00104: datatype (BINARY_DOUBLE) 错误
• .Devos加密数据库恢复
• 关于ORACLE 11G密码大小写敏感猜想(USER$.SPARE4)
• Data pump 中network_link参数的使用
• expdp中PARALLEL和DUMPFILE关系
• statement suspended, wait error to be cleared
• ORA-39126: 在 KUPW$WORKER.PUT_DDLS [TABLE_STATISTICS] 中 Worker 发生意外致命错误
• impdp中的DISABLE_ARCHIVE_LOGGING参数测试
• 给你的dmp文件(datapump)加上密码锁
• ORACLE 12C可以通过expdp导出view数据