生活随笔
收集整理的这篇文章主要介绍了
一次expdp 错误的分析处理
小编觉得挺不错的,现在分享给大家,帮大家做个参考.
一次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';
转载于:https://blog.51cto.com/hsbxxl/861056
总结
以上是生活随笔为你收集整理的一次expdp 错误的分析处理的全部内容，希望文章能够帮你解决所遇到的问题。
如果觉得生活随笔网站内容还不错，欢迎将生活随笔推荐给好友。
