Datapump export failed with ORA-08102 error

郑全

如题：

C:\Users\Administrator>expdp 'sys/oracle as sysdba' directory=dir_expdp dumpfile=zzmes_expdp.dmp schemas=zzmes logfile=zzmes_expdp.log

Export: Release 11.2.0.1.0 - Production on 星期四 8月 9 23:48:03 2018

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

连接到: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-31626: 作业不存在
ORA-31637: 无法创建作业 SYS_EXPORT_SCHEMA_01 (用户 SYS)
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: 在 "SYS.KUPV$FT_INT", line 798
ORA-39244: 关系选择期间禁用删除空位图像标题的事件
ORA-06512: 在 "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: 在 "SYS.KUPC$QUE_INT", line 1825
ORA-08102: 未找到索引关键字, 对象号 52, 文件 1, 块 88585 (2)

郑全

Datapump export failed with ORA-08102 error (Doc ID 2378261.1)
To Bottom



In this Document

Symptoms

Cause

Solution

References


Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.
Symptoms
CT having corruption issues, opened the DB with (*._ALLOW_RESETLOGS_CORRUPTION = TRUE) option.
Taking the DB export to rebuild the DB, but fails with below error.
Export: Release 11.2.0.4.0 - Production on Mon Mar 19 17:38:16 2018

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

Username: / as sysdba

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Data Mining, Oracle Database Vault and Real Application Testing optio
ORA-31626: job does not exist
ORA-31637: cannot create job SYS_EXPORT_SCHEMA_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 798
ORA-39080: failed to create queues "KUPC$C_2_20180319173819" and "KUPC$S_2_20180319173819" for Data Pump job
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 1534
ORA-08102: index key not found, obj# 52, file 1, block 71731 (2)

Cause
ORA-08102: index key not found, obj# 52, file 1, block 71731 (2) <<<<<<<<<< Corrupt index SYS.I_CON2 is the cause.
Solution
Try traditional export. if that also fails, please fix the corrupt index and take expdp export.
1. Shutdown database:
shutdown immediate
2. Remove below parameter from pfile/spfile:
*._ALLOW_RESETLOGS_CORRUPTION = TRUE
3. Take a cold backup of database.
4. Startup upgrade:
startup upgrade;
alter index SYS.I_CON2 rebuild;
Please contact Oracle support, if you need any clarification on the above action plan.
References
NOTE:1594347.1 - RAC and DB Support Tools Bundle
NOTE:166650.1 - Working Effectively With Oracle Support - Best Practices
BUG:18607546 - ORA-600 [KDBLKCHECKERROR], [43], [1971507], [6266] WITH CHAINED ROWS
NOTE:978502.1 - How to Resolve ORA-08102 Reported on Table SMON_SCN_TIME
NOTE:1949651.1 - SRDC - Required Diagnostic Data Collection for ORA-08102
NOTE:1944645.1 - ALERT Bug 18607546 ORA-600 [kdblkcheckerror]..[6266] Corruption with Self-referenced Chained row. ORA-600 [kdsgrp1] / Wrong Results / ORA-8102
NOTE:2166117.1 - SRDC - Other Internal Error: Checklist of Evidence to Supply for Version 11g and Greater