环境介绍:
OS:centos 7.8
db:19.3
expdp导出报错:
[oracle@sztech~]$ expdp system/oracle directory=dump_dir dumpfile=dmpfile.dmp version=11.2.0.4.0 transport_tablespaces='tb1,tb2'; Export:Release 19.0.0.0.0 - Production on Fri Aug 5 17:37:13 2022 Version19.3.0.0.0 Copyright(c) 1982, 2019, Oracle and/or its affiliates. All rights reserved. UDE-28002:operation generated ORACLE error 28002 ORA-28002:the password will expire within 7 days Connectedto: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production ORA-39006:internal error ORA-39065:unexpected master process exception in DISPATCH ORA-01001:invalid cursor ORA-06512:at "SYS.DBMS_METADATA_UTIL", line 3405 ORA-06512:at "SYS.KUPM$MCP", line 2635 ORA-39097: Data Pump jobencountered unexpected error -1001
解决办法: SQL>select count(*) from metanametrans$;
sqlplus/ as sysdba
@$ORACLE_HOME/rdbms/admin/catmet2.sql
@$ORACLE_HOME/rdbms/admin/utlrp.sql
详情见文档 DataPump JobReports ORA-39097: Data Pump job encountered unexpected error 100 (文档 ID 453796.1)
再次导出成功 [oracle@sztech ~]$ expdpsystem/oracle directory=dump_dir dumpfile=dmpfile.dmp version=11.2.0.4.0 transport_tablespaces='tb1,tb2'; Export: Release 19.0.0.0.0 - Production onFri Aug 5 17:49:19 2022 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle and/or itsaffiliates. All rights reserved. UDE-28002: operation generated ORACLE error28002 ORA-28002: the password will expire within7 days Connected to: Oracle Database 19cEnterprise Edition Release 19.0.0.0.0 - Production Starting"SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01": system/******** directory=dump_dir dumpfile=dmpfile.dmpversion=11.2.0.4.0 transport_tablespaces=tb1,tb2 Processing object typeTRANSPORTABLE_EXPORT/PLUGTS_BLK Processing object typeTRANSPORTABLE_EXPORT/POST_INSTANCE/PLUGTS_BLK Processing object typeTRANSPORTABLE_EXPORT/TABLE Master table "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"successfully loaded/unloaded ****************************************************************************** Dump file set forSYSTEM.SYS_EXPORT_TRANSPORTABLE_01 is: /u01/app/oracle/dumpdir/dmpfile.dmp ****************************************************************************** Datafiles required for transportabletablespace TB1: /u01/app/oracle/oradata/orcl/tb1.dbf Datafiles required for transportabletablespace TB2: /u01/app/oracle/oradata/orcl/tb2.dbf Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01"successfully completed at Fri Aug 5 17:50:59 2022 elapsed 0 00:01:33 [oracle@sztech ~]$ |