一次expdp 错误的分析处理-CSDN博客

一次expdp/impdp是出现错误

$ expdp system/***** dumpfile=<filename.dmp> nologfile=y compression=all schemas=<schema_name>
Export: Release 11.2.0.2.0 - Production on Tue Mar 6 13:45:10 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
ORA-39006: internal error
ORA-39065: unexpected master process exception in DISPATCH
ORA-04063: package body "SYS.DBMS_METADATA_UTIL" has errors
ORA-06508: PL/SQL: could not find program unit being called: "SYS.DBMS_METADATA_UTIL"
ORA-39097: Data Pump job encountered unexpected error -6508

经过查询发现，数据库的两个组件invalid和一些对象失效，具体如下

Some objects invalid cause export failure, customer need to validate these components and SYS objects.
The following are collecting informations :
SQL> select comp_name, status, version
2 from dba_registry;
COMP_NAME STATUS VERSION
---------------------------------------- -------------------- ------------------------------------------------------------
Oracle Text VALID 11.2.0.2.0
Oracle Workspace Manager VALID 11.2.0.2.0
Oracle Database Catalog Views INVALID 11.2.0.2.0 <<<<<<<<<<<<<<<<<<<<<<<<<<
Oracle Database Packages and Types INVALID 11.2.0.2.0 <<<<<<<<<<<<<<<<<<<<<<<<<<
Oracle Real Application Clusters VALID 11.2.0.2.0
SQL> select owner, object_name, object_type, status
2 from dba_objects
3 where status <> 'VALID';
OWNER OBJECT_NAME OBJECT_TYPE STATUS
------------------ -------------------------------------------------- -------------------- --------------------
SYS ALL_XML_SCHEMAS VIEW INVALID
SYS ALL_XML_SCHEMAS2 VIEW INVALID
SYS KU$_XMLSCHEMA_VIEW VIEW INVALID
SYS KU$_EXP_XMLSCHEMA_VIEW VIEW INVALID
SYS KU$_XMLSCHEMA_ELMT_VIEW VIEW INVALID
SYS KU$_OPQTYPE_VIEW VIEW INVALID
SYS KU$_TABLE_XMLSCHEMA_VIEW VIEW INVALID
SYS KU$_COLUMN_VIEW VIEW INVALID
SYS KU$_PCOLUMN_VIEW VIEW INVALID
SYS KU$_NT_PARENT_VIEW VIEW INVALID
SYS KU$_FHTABLE_VIEW VIEW INVALID
SYS KU$_10_2_FHTABLE_VIEW VIEW INVALID
SYS KU$_10_1_FHTABLE_VIEW VIEW INVALID
SYS KU$_PFHTABLE_VIEW VIEW INVALID
SYS KU$_10_1_PFHTABLE_VIEW VIEW INVALID
SYS KU$_ACPTABLE_VIEW VIEW INVALID
SYS KU$_IOTABLE_VIEW VIEW INVALID
SYS KU$_10_1_IOTABLE_VIEW VIEW INVALID
SYS KU$_PIOTABLE_VIEW VIEW INVALID
SYS KU$_10_1_PIOTABLE_VIEW VIEW INVALID
SYS KU$_XMLSCHEMA_TYPES_VIEW VIEW INVALID
SYS KU$_TTS_TYPES_VIEW VIEW INVALID
SYS KU$_VIEW_VIEW VIEW INVALID
SYS KU$_M_VIEW_FH_VIEW VIEW INVALID
SYS KU$_M_VIEW_PFH_VIEW VIEW INVALID
SYS KU$_M_VIEW_IOT_VIEW VIEW INVALID
SYS KU$_M_VIEW_PIOT_VIEW VIEW INVALID
SYS KU$_M_VIEW_LOG_FH_VIEW VIEW INVALID
SYS KU$_M_VIEW_LOG_PFH_VIEW VIEW INVALID
SYS KU$_CLUSTER_VIEW VIEW INVALID
SYS DBMS_METADATA PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SYS DBMS_METADATA_INT PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
SYS DBMS_METADATA_UTIL PACKAGE BODY INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<

处理办法如下：

please perform the following scripts during system idle time to recompile invalid objects.

Note: before running the script, take full backup and validate the backups.
SQL> connect / sysdba
SQL> spool catalog.log
SQL> @?/rdbms/admin/catalog
SQL> spool off
SQL> spool catproc.log
SQL> @?/rdbms/admin/catproc
SQL> spool off
SQL> spool utlrp.log
SQL> @?/rdbms/admin/utlrp
SQL> spool off
When you finished, perform the following SQL to check for invalid objects.
SQL> select owner,object_name,object_type,status from dba_objects where status = 'INVALID';