expdp-数据库逻辑备份报ORA-39014错

mahui168 · 发表于 2014-9-28 16:55

raysuen 发表于 2014-9-28 16:52
兄弟，300多G的备份还是使用rman吧，更高效。

有2种备份方式的，rman加expdp，但是expdp报错了

super_sky · 发表于 2014-9-29 08:55

mahui168 发表于 2014-9-28 16:05
您看一下我贴的信息，这个脚本在20号备份失败的，25号我这边去掉了@nberp后备份成功，但是在27号又备份失 ...

27号备份的错误信息呢？

super_sky · 发表于 2014-9-29 09:02

请再次提供一下你的环境信息

操作系统
数据库版本，从信息上看是10.2.0.4
是否是RAC

2009532140 · 发表于 2014-9-29 09:10

ORA-00028: your session has been killed
ORA-00028: your session has been killed

mahui168 · 发表于 2014-9-29 10:33

super_sky 发表于 2014-9-29 09:02
请再次提供一下你的环境信息

操作系统

oracle@P740M:/backup/dpbak> cat nc_14-09-27.log
;;;
Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 27 September, 2014 21:00:01

Copyright (c) 2003, 2007, Oracle. All rights reserved.
;;;
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "NC501SP184"."SYS_EXPORT_SCHEMA_13": nc501sp184/******** dumpfile=nc_14-09-27.dp logfile=nc_14-09-27.log directory=dpdir schemas=nc501sp184,iufo
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 330.8 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/POST_TABLE_ACTION
Processing object type SCHEMA_EXPORT/TABLE/MATERIALIZED_VIEW_LOG
Processing object type SCHEMA_EXPORT/JOB
Processing object type SCHEMA_EXPORT/POST_SCHEMA/PROCOBJ
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW01" prematurely terminated
ORA-31671: Worker process DW01 had an unhandled exception.
ORA-00028: your session has been killed
ORA-00028: your session has been killed
ORA-06512: at "SYS.KUPF$FILE", line 5772
ORA-06512: at line 1
ORA-06512: at "SYS.KUPD$DATA_INT", line 14
ORA-06512: at "SYS.KUPD$DATA", line 1313
ORA-06512: at "SYS.KUPW$WORKER", line 10826
ORA-06512: at "SYS.KUPW$WORKER", line 2637
ORA-06512: at "SYS.KUPW$WORKER", line 6958
ORA-06512: at "SYS.KUPW$WORKER", line 1314
ORA-06512: at line 2
Job "NC501SP184"."SYS_EXPORT_SCHEMA_13" stopped due to fatal error at 22:02:29
ORA-39014: One or more workers have prematurely exited.

aix6.1，单机，没有rac，10.2。0.4