一次expdp 错误的分析处理

     一次expdp/impdp是出现错误

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

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

1. Some objects invalid cause export failure, customer need to validate these components and SYS objects. 
2.  
3. The following are collecting informations : 
4.  
5. SQL> select comp_name, status, version 
6. 2  from dba_registry; 
7.  
8. COMP_NAME                                STATUS               VERSION 
9. ---------------------------------------- -------------------- ------------------------------------------------------------ 
10. Oracle Text                              VALID                11.2.0.2.0 
11. Oracle Workspace Manager                 VALID                11.2.0.2.0 
12. Oracle Database Catalog Views            INVALID              11.2.0.2.0 <<<<<<<<<<<<<<<<<<<<<<<<<< 
13. Oracle Database Packages and Types       INVALID              11.2.0.2.0  <<<<<<<<<<<<<<<<<<<<<<<<<< 
14. Oracle Real Application Clusters         VALID                11.2.0.2.0 
15.  
16.  
17. SQL> select owner, object_name, object_type, status 
18. 2  from dba_objects 
19. 3  where status <> 'VALID'; 
20.  
21. OWNER              OBJECT_NAME                                        OBJECT_TYPE          STATUS 
22. ------------------ -------------------------------------------------- -------------------- -------------------- 
23. SYS                ALL_XML_SCHEMAS                                    VIEW                 INVALID 
24. SYS                ALL_XML_SCHEMAS2                                   VIEW                 INVALID 
25. SYS                KU$_XMLSCHEMA_VIEW                                 VIEW                 INVALID 
26. SYS                KU$_EXP_XMLSCHEMA_VIEW                             VIEW                 INVALID 
27. SYS                KU$_XMLSCHEMA_ELMT_VIEW                            VIEW                 INVALID 
28. SYS                KU$_OPQTYPE_VIEW                                   VIEW                 INVALID 
29. SYS                KU$_TABLE_XMLSCHEMA_VIEW                           VIEW                 INVALID 
30. SYS                KU$_COLUMN_VIEW                                    VIEW                 INVALID 
31. SYS                KU$_PCOLUMN_VIEW                                   VIEW                 INVALID 
32. SYS                KU$_NT_PARENT_VIEW                                 VIEW                 INVALID 
33. SYS                KU$_FHTABLE_VIEW                                   VIEW                 INVALID 
34. SYS                KU$_10_2_FHTABLE_VIEW                              VIEW                 INVALID 
35. SYS                KU$_10_1_FHTABLE_VIEW                              VIEW                 INVALID 
36. SYS                KU$_PFHTABLE_VIEW                                  VIEW                 INVALID 
37. SYS                KU$_10_1_PFHTABLE_VIEW                             VIEW                 INVALID 
38. SYS                KU$_ACPTABLE_VIEW                                  VIEW                 INVALID 
39. SYS                KU$_IOTABLE_VIEW                                   VIEW                 INVALID 
40. SYS                KU$_10_1_IOTABLE_VIEW                              VIEW                 INVALID 
41. SYS                KU$_PIOTABLE_VIEW                                  VIEW                 INVALID 
42. SYS                KU$_10_1_PIOTABLE_VIEW                             VIEW                 INVALID 
43. SYS                KU$_XMLSCHEMA_TYPES_VIEW                           VIEW                 INVALID 
44. SYS                KU$_TTS_TYPES_VIEW                                 VIEW                 INVALID 
45. SYS                KU$_VIEW_VIEW                                      VIEW                 INVALID 
46. SYS                KU$_M_VIEW_FH_VIEW                                 VIEW                 INVALID 
47. SYS                KU$_M_VIEW_PFH_VIEW                                VIEW                 INVALID 
48. SYS                KU$_M_VIEW_IOT_VIEW                                VIEW                 INVALID 
49. SYS                KU$_M_VIEW_PIOT_VIEW                               VIEW                 INVALID 
50. SYS                KU$_M_VIEW_LOG_FH_VIEW                             VIEW                 INVALID 
51. SYS                KU$_M_VIEW_LOG_PFH_VIEW                            VIEW                 INVALID 
52. SYS                KU$_CLUSTER_VIEW                                   VIEW                 INVALID 
53. SYS                DBMS_METADATA                                      PACKAGE BODY         INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 
54. SYS                DBMS_METADATA_INT                                  PACKAGE BODY         INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<< 
55. SYS                DBMS_METADATA_UTIL                                 PACKAGE BODY         INVALID <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<  

处理办法如下：

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

1. Note: before running the script, take full backup and validate the backups. 
2.  
3. SQL> connect / sysdba 
4. SQL> spool catalog.log 
5. SQL> @?/rdbms/admin/catalog 
6. SQL> spool off 
7. SQL> spool catproc.log 
8. SQL> @?/rdbms/admin/catproc 
9. SQL> spool off 
10. SQL> spool utlrp.log 
11. SQL> @?/rdbms/admin/utlrp 
12. SQL> spool off 
13.  
14. When you finished, perform the following SQL to check for invalid objects. 
15.  
16. SQL> select owner,object_name,object_type,status from dba_objects where status = 'INVALID';