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

显示全部楼层 · 2014-10-9 06:00:13

上星期检查日志发现数据库逻辑备份出错，网上查了资料，没有什么好的解决办法，有没高手遇到过，求解答。以下为报错日志。
Export: Release 10.2.0.4.0 - 64bit Production on Saturday, 20 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_12":nc501sp184/********@nberp dumpfile=nc_14-09-20.dp logfile=nc_14-09-20.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: 327.4 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.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_12" stopped due to fatal error at 21:17:25
ORA-39014: One or more workers have prematurely exited.

千问 · 2014-10-9 06:00:13

EXCLUDE=STATISTICS加这个参数试一下

千问 · 2014-10-9 06:00:13

Increase the memory allocated in the streams_pool_size to resolve this issue.
https://support.oracle.com/epmos ... 04873573427#SYMPTOM

千问 · 2014-10-9 06:00:13

bizhanjie 发表于 2014-9-22 17:45
Increase the memory allocated in the streams_pool_size to resolve this issue.
https://support.oracl ...
你这个链接，没账号打不开啊，能贴下来看下吗？

千问 · 2014-10-9 06:00:13

dzminglong 发表于 2014-9-22 18:16
你这个链接，没账号打不开啊，能贴下来看下吗？
SYMPTOMSDataPump fails with errorstack similar to the following: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-39079: unable to enqueue message DG,KUPC$C_1_20071030223003,KUPC$A_1_20071030223013,MCP,8473,Y
ORA-06512: at "SYS.KUPW$WORKER", line 1342
ORA-06512: at line 2
Job "SYS"."SYS_EXPORT_FULL_01" stopped due to fatal error at 00:44:51
ORA-39014: One or more workers have prematurely exited.
CAUSEThe important errors here are the ORA-39014 and ORA-39079. The DataPump utility uses Streams in the background and if the Streams memory pool is not large enough, it can result in this error stack.
Use a queries below to investigate memory usage and settingscol bytes format 999,999,999,999
select * from v$sgastat where pool='streams pool';select * from v$sgainfo;
If using auto-tuning in the SGA, you may find the memory manager is having difficulty moving memory to satisfy memory needs in the Streams Pool.set lines 200
col component format a20
col initial_size format 999,999,999,999
col finish_size format 999,999,999,999
col target_size format 999,999,999,999
select to_char(end_time, 'dd-MON-yyyy hh24:mi:ss') end_time,
component, initial_size, target_size,
final_size, status
from v$sga_resize_ops
order by end_time;
Look for STATUS showing up as ERROR or DEFERRED. This can mean that SGA_TARGET is too small to meet all SGA memory needs. This can also indicate that minimum sizes (explicit settings) are not included in the spfile, so under stress the auto-tuner could get too aggressive moving memory inside the SGA.SOLUTIONIncrease the memory allocated in the streams_pool_size to resolve this issue.If using auto-tuning a higher value for streams_pool_size will act a higher minimum value and keep the memory tuner from shrinking the Streams Pool too small for workload.

千问 · 2014-10-9 06:00:13

看一下你的内存管理方式。是否开启了自动内存管理。如果没有开启，请扩大streams_pool_size值。

千问 · 2014-10-9 06:00:13

bizhanjie 发表于 2014-9-23 09:42
SYMPTOMSDataPump fails with errorstack similar to the following:ORA-39014: One or more workers hav ...
这几天有点忙，所以现在才看帖子
我把信息搜集了下：
SQL> show parameter sga;
NAME
TYPEVALUE
------------------------------------ ----------- ------------------------------
lock_sga
boolean TRUE
pre_page_sga
boolean FALSE
sga_max_size
big integer 90G
sga_target
big integer 90G
自动内存管理
select * from v$sgastat where pool='streams pool'
2;
POOL NAME
BYTES
------------ -------------------------- ----------
streams pool free memory
16762136
streams pool kwqbcqini:spilledovermsgs 18248
streams pool kgqmsub
2896
streams pool name_kgqmsub
1352
streams pool Sender info
108528
streams pool recov_kgqmsub
7976
SQL> select * from v$sgainfo;
NAME
BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size
2266392 No
Redo Buffers
14508032 No
Buffer Cache Size
8.2997E+10 Yes
Shared Pool Size
1.3573E+10 Yes
Large Pool Size
16777216 Yes
Java Pool Size
16777216 Yes
Streams Pool Size
16777216 Yes
Granule Size
16777216 No
Maximum SGA Size
9.6637E+10 No
Startup overhead in Shared Pool1056964608 No
Free SGA Memory Available
0
SQL> select to_char(end_time, 'dd-MON-yyyy hh24:mi:ss') end_time,
2component, initial_size, target_size,
3final_size, status
4from v$sga_resize_ops
5order by end_time;
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
20-SEP-2014 19:52:00shared pool
01,476,395,008 1476395008 COMPLETE
20-SEP-2014 19:52:00large pool
0 16,777,216 16777216 COMPLETE
20-SEP-2014 19:52:00java pool
0 16,777,216 16777216 COMPLETE
20-SEP-2014 19:52:00streams pool
0
0
0 COMPLETE
20-SEP-2014 19:52:00DEFAULT buffer cache
0 95,110,037,504 9.5110E+10 COMPLETE
20-SEP-2014 19:52:00KEEP buffer cache
0
0
0 COMPLETE
20-SEP-2014 19:52:00RECYCLE buffer cache
0
0
0 COMPLETE
20-SEP-2014 19:52:00DEFAULT 2K buffer ca
0
0
0 COMPLETE

che
20-SEP-2014 19:52:00DEFAULT 4K buffer ca
0
0
0 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------

che
20-SEP-2014 19:52:00DEFAULT 8K buffer ca
0
0
0 COMPLETE

che
20-SEP-2014 19:52:00DEFAULT 16K buffer c
0
0
0 COMPLETE

ache
20-SEP-2014 19:52:00DEFAULT 32K buffer c
0
0
0 COMPLETE

ache

END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
20-SEP-2014 19:52:00ASM Buffer Cache
0
0
0 COMPLETE
20-SEP-2014 19:52:16DEFAULT buffer cache 95,110,037,504 95,110,037,504 9.5110E+10 COMPLETE
20-SEP-2014 19:58:03DEFAULT buffer cache 95,110,037,504 95,093,260,288 9.5093E+10 COMPLETE
20-SEP-2014 19:58:03shared pool
1,493,172,2241,509,949,440 1509949440 COMPLETE
20-SEP-2014 19:58:03DEFAULT buffer cache 95,093,260,288 95,076,483,072 9.5076E+10 COMPLETE
20-SEP-2014 19:58:03shared pool
1,476,395,0081,493,172,224 1493172224 COMPLETE
20-SEP-2014 21:00:10DEFAULT buffer cache 95,076,483,072 95,059,705,856 9.5060E+10 COMPLETE
20-SEP-2014 21:00:10streams pool
0 16,777,216 16777216 COMPLETE
20-SEP-2014 21:00:10DEFAULT buffer cache 95,059,705,856 95,042,928,640 9.5043E+10 COMPLETE
20-SEP-2014 21:00:10streams pool
16,777,216 33,554,432 33554432 COMPLETE
20-SEP-2014 21:00:43DEFAULT buffer cache 95,042,928,640 95,026,151,424 9.5026E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
20-SEP-2014 21:00:43shared pool
1,509,949,4401,526,726,656 1526726656 COMPLETE
20-SEP-2014 21:00:53DEFAULT buffer cache 95,026,151,424 95,009,374,208 9.5009E+10 COMPLETE
20-SEP-2014 21:00:53shared pool
1,526,726,6561,543,503,872 1543503872 COMPLETE
20-SEP-2014 21:01:06shared pool
1,543,503,8721,560,281,088 1560281088 COMPLETE
20-SEP-2014 21:01:06DEFAULT buffer cache 95,009,374,208 94,992,596,992 9.4993E+10 COMPLETE
20-SEP-2014 21:09:11DEFAULT buffer cache 94,992,596,992 94,975,819,776 9.4976E+10 COMPLETE
20-SEP-2014 21:09:11shared pool
1,560,281,0881,577,058,304 1577058304 COMPLETE
21-SEP-2014 02:04:21DEFAULT buffer cache 94,975,819,776 94,908,710,912 9.4909E+10 COMPLETE
21-SEP-2014 02:04:21shared pool
1,577,058,3041,644,167,168 1644167168 COMPLETE
21-SEP-2014 02:12:54DEFAULT buffer cache 94,908,710,912 94,841,602,048 9.4842E+10 COMPLETE
21-SEP-2014 02:12:54shared pool
1,644,167,1681,711,276,032 1711276032 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 04:30:25DEFAULT buffer cache 94,841,602,048 94,757,715,968 9.4758E+10 COMPLETE
21-SEP-2014 04:30:25shared pool
1,711,276,0321,795,162,112 1795162112 COMPLETE
21-SEP-2014 04:33:55DEFAULT buffer cache 94,757,715,968 94,673,829,888 9.4674E+10 COMPLETE
21-SEP-2014 04:33:55shared pool
1,795,162,1121,879,048,192 1879048192 COMPLETE
21-SEP-2014 04:37:25DEFAULT buffer cache 94,673,829,888 94,589,943,808 9.4590E+10 COMPLETE
21-SEP-2014 04:37:25shared pool
1,879,048,1921,962,934,272 1962934272 COMPLETE
21-SEP-2014 04:40:55DEFAULT buffer cache 94,589,943,808 94,506,057,728 9.4506E+10 COMPLETE
21-SEP-2014 04:40:55shared pool
1,962,934,2722,046,820,352 2046820352 COMPLETE
21-SEP-2014 04:44:25DEFAULT buffer cache 94,506,057,728 94,405,394,432 9.4405E+10 COMPLETE
21-SEP-2014 04:44:25shared pool
2,046,820,3522,147,483,648 2147483648 COMPLETE
21-SEP-2014 04:47:55DEFAULT buffer cache 94,405,394,432 94,304,731,136 9.4305E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 04:47:55shared pool
2,147,483,6482,248,146,944 2248146944 COMPLETE
21-SEP-2014 04:52:25DEFAULT buffer cache 94,304,731,136 94,204,067,840 9.4204E+10 COMPLETE
21-SEP-2014 04:52:25shared pool
2,248,146,9442,348,810,240 2348810240 COMPLETE
21-SEP-2014 04:57:25DEFAULT buffer cache 94,204,067,840 94,086,627,328 9.4087E+10 COMPLETE
21-SEP-2014 04:57:25shared pool
2,348,810,2402,466,250,752 2466250752 COMPLETE
21-SEP-2014 05:00:55DEFAULT buffer cache 94,086,627,328 93,969,186,816 9.3969E+10 COMPLETE
21-SEP-2014 05:00:55shared pool
2,466,250,7522,583,691,264 2583691264 COMPLETE
21-SEP-2014 05:04:25DEFAULT buffer cache 93,969,186,816 93,851,746,304 9.3852E+10 COMPLETE
21-SEP-2014 05:04:25shared pool
2,583,691,2642,701,131,776 2701131776 COMPLETE
21-SEP-2014 05:08:25DEFAULT buffer cache 93,851,746,304 93,717,528,576 9.3718E+10 COMPLETE
21-SEP-2014 05:08:25shared pool
2,701,131,7762,835,349,504 2835349504 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 05:12:28DEFAULT buffer cache 93,717,528,576 93,583,310,848 9.3583E+10 COMPLETE
21-SEP-2014 05:12:28shared pool
2,835,349,5042,969,567,232 2969567232 COMPLETE
21-SEP-2014 05:17:55DEFAULT buffer cache 93,583,310,848 93,449,093,120 9.3449E+10 COMPLETE
21-SEP-2014 05:17:55shared pool
2,969,567,2323,103,784,960 3103784960 COMPLETE
21-SEP-2014 05:24:28DEFAULT buffer cache 93,449,093,120 93,298,098,176 9.3298E+10 COMPLETE
21-SEP-2014 05:24:28shared pool
3,103,784,9603,254,779,904 3254779904 COMPLETE
21-SEP-2014 05:43:29DEFAULT buffer cache 93,298,098,176 93,147,103,232 9.3147E+10 COMPLETE
21-SEP-2014 05:43:29shared pool
3,254,779,9043,405,774,848 3405774848 COMPLETE
21-SEP-2014 05:46:59DEFAULT buffer cache 93,147,103,232 92,979,331,072 9.2979E+10 COMPLETE
21-SEP-2014 05:46:59shared pool
3,405,774,8483,573,547,008 3573547008 COMPLETE
21-SEP-2014 05:59:29DEFAULT buffer cache 92,979,331,072 92,811,558,912 9.2812E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 05:59:29shared pool
3,573,547,0083,741,319,168 3741319168 COMPLETE
21-SEP-2014 06:06:59DEFAULT buffer cache 92,811,558,912 92,627,009,536 9.2627E+10 COMPLETE
21-SEP-2014 06:06:59shared pool
3,741,319,1683,925,868,544 3925868544 COMPLETE
21-SEP-2014 06:10:29DEFAULT buffer cache 92,627,009,536 92,442,460,160 9.2442E+10 COMPLETE
21-SEP-2014 06:10:29shared pool
3,925,868,5444,110,417,920 4110417920 COMPLETE
21-SEP-2014 06:18:29DEFAULT buffer cache 92,442,460,160 92,241,133,568 9.2241E+10 COMPLETE
21-SEP-2014 06:18:29shared pool
4,110,417,9204,311,744,512 4311744512 COMPLETE
21-SEP-2014 06:27:59DEFAULT buffer cache 92,241,133,568 92,039,806,976 9.2040E+10 COMPLETE
21-SEP-2014 06:27:59shared pool
4,311,744,5124,513,071,104 4513071104 COMPLETE
21-SEP-2014 06:32:29DEFAULT buffer cache 92,039,806,976 91,821,703,168 9.1822E+10 COMPLETE
21-SEP-2014 06:32:29shared pool
4,513,071,1044,731,174,912 4731174912 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 06:37:30DEFAULT buffer cache 91,821,703,168 91,586,822,144 9.1587E+10 COMPLETE
21-SEP-2014 06:37:30shared pool
4,731,174,9124,966,055,936 4966055936 COMPLETE
21-SEP-2014 06:42:00DEFAULT buffer cache 91,586,822,144 91,351,941,120 9.1352E+10 COMPLETE
21-SEP-2014 06:42:00shared pool
4,966,055,9365,200,936,960 5200936960 COMPLETE
21-SEP-2014 06:45:30DEFAULT buffer cache 91,351,941,120 91,100,282,880 9.1100E+10 COMPLETE
21-SEP-2014 06:45:30shared pool
5,200,936,9605,452,595,200 5452595200 COMPLETE
21-SEP-2014 08:01:30DEFAULT buffer cache 91,100,282,880 90,831,847,424 9.0832E+10 COMPLETE
21-SEP-2014 08:01:30shared pool
5,452,595,2005,721,030,656 5721030656 COMPLETE
21-SEP-2014 11:19:39DEFAULT buffer cache 90,831,847,424 90,815,070,208 9.0815E+10 COMPLETE
21-SEP-2014 11:19:39shared pool
5,721,030,6565,737,807,872 5737807872 COMPLETE
21-SEP-2014 15:00:09DEFAULT buffer cache 90,815,070,208 90,798,292,992 9.0798E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
21-SEP-2014 15:00:09shared pool
5,737,807,8725,754,585,088 5754585088 COMPLETE
21-SEP-2014 20:05:42DEFAULT buffer cache 90,798,292,992 90,781,515,776 9.0782E+10 COMPLETE
21-SEP-2014 20:05:42shared pool
5,754,585,0885,771,362,304 5771362304 COMPLETE
22-SEP-2014 04:18:13DEFAULT buffer cache 90,781,515,776 90,764,738,560 9.0765E+10 COMPLETE
22-SEP-2014 04:18:13shared pool
5,771,362,3045,788,139,520 5788139520 COMPLETE
22-SEP-2014 08:01:01DEFAULT buffer cache 90,764,738,560 90,747,961,344 9.0748E+10 COMPLETE
22-SEP-2014 08:01:01shared pool
5,788,139,5205,804,916,736 5804916736 COMPLETE
22-SEP-2014 09:02:00DEFAULT buffer cache 90,747,961,344 90,462,748,672 9.0463E+10 COMPLETE
22-SEP-2014 09:02:00shared pool
5,804,916,7366,090,129,408 6090129408 COMPLETE
22-SEP-2014 11:01:15DEFAULT buffer cache 90,462,748,672 90,445,971,456 9.0446E+10 COMPLETE
22-SEP-2014 11:01:15shared pool
6,090,129,4086,106,906,624 6106906624 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
22-SEP-2014 11:07:04DEFAULT buffer cache 90,445,971,456 90,143,981,568 9.0144E+10 COMPLETE
22-SEP-2014 11:07:04shared pool
6,106,906,6246,408,896,512 6408896512 COMPLETE
22-SEP-2014 11:20:04DEFAULT buffer cache 90,143,981,568 89,825,214,464 8.9825E+10 COMPLETE
22-SEP-2014 11:20:04shared pool
6,408,896,5126,727,663,616 6727663616 COMPLETE
22-SEP-2014 11:23:34DEFAULT buffer cache 89,825,214,464 89,489,670,144 8.9490E+10 COMPLETE
22-SEP-2014 11:23:34shared pool
6,727,663,6167,063,207,936 7063207936 COMPLETE
22-SEP-2014 11:36:04DEFAULT buffer cache 89,489,670,144 89,137,348,608 8.9137E+10 COMPLETE
22-SEP-2014 11:36:04shared pool
7,063,207,9367,415,529,472 7415529472 COMPLETE
22-SEP-2014 13:22:35DEFAULT buffer cache 89,137,348,608 88,768,249,856 8.8768E+10 COMPLETE
22-SEP-2014 13:22:35shared pool
7,415,529,4727,784,628,224 7784628224 COMPLETE
22-SEP-2014 13:28:35DEFAULT buffer cache 88,768,249,856 88,382,373,888 8.8382E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
22-SEP-2014 13:28:35shared pool
7,784,628,2248,170,504,192 8170504192 COMPLETE
22-SEP-2014 16:01:09DEFAULT buffer cache 88,382,373,888 87,979,720,704 8.7980E+10 COMPLETE
22-SEP-2014 16:01:09shared pool
8,170,504,1928,573,157,376 8573157376 COMPLETE
22-SEP-2014 16:05:09DEFAULT buffer cache 87,979,720,704 87,560,290,304 8.7560E+10 COMPLETE
22-SEP-2014 16:05:09shared pool
8,573,157,3768,992,587,776 8992587776 COMPLETE
23-SEP-2014 05:00:06DEFAULT buffer cache 87,560,290,304 87,543,513,088 8.7544E+10 COMPLETE
23-SEP-2014 05:00:06shared pool
8,992,587,7769,009,364,992 9009364992 COMPLETE
23-SEP-2014 10:01:02DEFAULT buffer cache 87,543,513,088 87,107,305,472 8.7107E+10 COMPLETE
23-SEP-2014 10:01:02shared pool
9,009,364,9929,445,572,608 9445572608 COMPLETE
23-SEP-2014 11:25:33shared pool
9,445,572,6089,344,909,312 9344909312 COMPLETE
23-SEP-2014 11:25:33DEFAULT buffer cache 87,107,305,472 87,207,968,768 8.7208E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
23-SEP-2014 11:30:33streams pool
33,554,432 16,777,216 16777216 COMPLETE
23-SEP-2014 11:30:33DEFAULT buffer cache 87,207,968,768 87,224,745,984 8.7225E+10 COMPLETE
23-SEP-2014 17:00:43DEFAULT buffer cache 87,224,745,984 86,771,761,152 8.6772E+10 COMPLETE
23-SEP-2014 17:00:43shared pool
9,344,909,3129,797,894,144 9797894144 COMPLETE
23-SEP-2014 18:24:43shared pool
9,797,894,1449,697,230,848 9697230848 COMPLETE
23-SEP-2014 18:24:43DEFAULT buffer cache 86,771,761,152 86,872,424,448 8.6872E+10 COMPLETE
23-SEP-2014 21:00:08DEFAULT buffer cache 86,872,424,448 86,855,647,232 8.6856E+10 COMPLETE
23-SEP-2014 21:00:08streams pool
16,777,216 33,554,432 33554432 COMPLETE
23-SEP-2014 22:54:49shared pool
9,697,230,8489,596,567,552 9596567552 COMPLETE
23-SEP-2014 22:54:49DEFAULT buffer cache 86,855,647,232 86,956,310,528 8.6956E+10 COMPLETE
23-SEP-2014 22:59:49streams pool
33,554,432 16,777,216 16777216 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
23-SEP-2014 22:59:49DEFAULT buffer cache 86,956,310,528 86,973,087,744 8.6973E+10 COMPLETE
24-SEP-2014 08:42:33DEFAULT buffer cache 86,973,087,744 86,503,325,696 8.6503E+10 COMPLETE
24-SEP-2014 08:42:33shared pool
9,596,567,552 10,066,329,600 1.0066E+10 COMPLETE
24-SEP-2014 08:47:03DEFAULT buffer cache 86,503,325,696 86,000,009,216 8.6000E+10 COMPLETE
24-SEP-2014 08:47:03shared pool
10,066,329,600 10,569,646,080 1.0570E+10 COMPLETE
24-SEP-2014 08:54:04DEFAULT buffer cache 86,000,009,216 85,479,915,520 8.5480E+10 COMPLETE
24-SEP-2014 08:54:04shared pool
10,569,646,080 11,089,739,776 1.1090E+10 COMPLETE
24-SEP-2014 10:53:18DEFAULT buffer cache 85,479,915,520 85,463,138,304 8.5463E+10 COMPLETE
24-SEP-2014 10:53:18shared pool
11,089,739,776 11,106,516,992 1.1107E+10 COMPLETE
24-SEP-2014 17:00:44DEFAULT buffer cache 85,463,138,304 84,909,490,176 8.4909E+10 COMPLETE
24-SEP-2014 17:00:44shared pool
11,106,516,992 11,660,165,120 1.1660E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
25-SEP-2014 00:00:51DEFAULT buffer cache 84,909,490,176 84,892,712,960 8.4893E+10 COMPLETE
25-SEP-2014 00:00:51shared pool
11,660,165,120 11,676,942,336 1.1677E+10 COMPLETE
25-SEP-2014 00:33:54shared pool
11,676,942,336 11,576,279,040 1.1576E+10 COMPLETE
25-SEP-2014 00:33:54DEFAULT buffer cache 84,892,712,960 84,993,376,256 8.4993E+10 COMPLETE
25-SEP-2014 01:26:57DEFAULT buffer cache 84,993,376,256 84,976,599,040 8.4977E+10 COMPLETE
25-SEP-2014 01:26:57shared pool
11,576,279,040 11,593,056,256 1.1593E+10 COMPLETE
25-SEP-2014 08:14:44DEFAULT buffer cache 84,976,599,040 84,959,821,824 8.4960E+10 COMPLETE
25-SEP-2014 08:14:44shared pool
11,593,056,256 11,609,833,472 1.1610E+10 COMPLETE
25-SEP-2014 08:40:04DEFAULT buffer cache 84,959,821,824 84,389,396,480 8.4389E+10 COMPLETE
25-SEP-2014 08:40:04shared pool
11,609,833,472 12,180,258,816 1.2180E+10 COMPLETE
25-SEP-2014 10:14:35shared pool
12,180,258,816 12,079,595,520 1.2080E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
25-SEP-2014 10:14:35DEFAULT buffer cache 84,389,396,480 84,490,059,776 8.4490E+10 COMPLETE
25-SEP-2014 13:31:09DEFAULT buffer cache 84,490,059,776 83,886,080,000 8.3886E+10 COMPLETE
25-SEP-2014 13:31:09shared pool
12,079,595,520 12,683,575,296 1.2684E+10 COMPLETE
25-SEP-2014 21:00:08DEFAULT buffer cache 83,886,080,000 83,869,302,784 8.3869E+10 COMPLETE
25-SEP-2014 21:00:08streams pool
16,777,216 33,554,432 33554432 COMPLETE
26-SEP-2014 08:08:32shared pool
12,683,575,296 12,582,912,000 1.2583E+10 COMPLETE
26-SEP-2014 08:08:32DEFAULT buffer cache 83,869,302,784 83,969,966,080 8.3970E+10 COMPLETE
26-SEP-2014 08:13:32streams pool
33,554,432 16,777,216 16777216 COMPLETE
26-SEP-2014 08:13:32DEFAULT buffer cache 83,969,966,080 83,986,743,296 8.3987E+10 COMPLETE
26-SEP-2014 08:27:06DEFAULT buffer cache 83,986,743,296 83,365,986,304 8.3366E+10 COMPLETE
26-SEP-2014 08:27:06shared pool
12,582,912,000 13,203,668,992 1.3204E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
26-SEP-2014 09:00:36DEFAULT buffer cache 83,365,986,304 82,711,674,880 8.2712E+10 COMPLETE
26-SEP-2014 09:00:36shared pool
13,203,668,992 13,857,980,416 1.3858E+10 COMPLETE
26-SEP-2014 10:13:10DEFAULT buffer cache 82,711,674,880 82,694,897,664 8.2695E+10 COMPLETE
26-SEP-2014 10:13:10shared pool
13,857,980,416 13,874,757,632 1.3875E+10 COMPLETE
26-SEP-2014 15:18:43shared pool
13,874,757,632 13,774,094,336 1.3774E+10 COMPLETE
26-SEP-2014 15:18:43DEFAULT buffer cache 82,694,897,664 82,795,560,960 8.2796E+10 COMPLETE
27-SEP-2014 12:34:37shared pool
13,774,094,336 13,673,431,040 1.3673E+10 COMPLETE
27-SEP-2014 12:34:37DEFAULT buffer cache 82,795,560,960 82,896,224,256 8.2896E+10 COMPLETE
27-SEP-2014 21:00:09DEFAULT buffer cache 82,896,224,256 82,879,447,040 8.2879E+10 COMPLETE
27-SEP-2014 21:00:09streams pool
16,777,216 33,554,432 33554432 COMPLETE
28-SEP-2014 00:37:50shared pool
13,673,431,040 13,572,767,744 1.3573E+10 COMPLETE
END_TIME
COMPONENT
INITIAL_SIZETARGET_SIZE FINAL_SIZE STATUS
----------------------- -------------------- ---------------- ---------------- ---------- ---------
28-SEP-2014 00:37:50DEFAULT buffer cache 82,879,447,040 82,980,110,336 8.2980E+10 COMPLETE
28-SEP-2014 00:42:50streams pool
33,554,432 16,777,216 16777216 COMPLETE
28-SEP-2014 00:42:50DEFAULT buffer cache 82,980,110,336 82,996,887,552 8.2997E+10 COMPLETE
每周二、四、六晚上9点进行expdp备份

千问 · 2014-10-9 06:00:13

bizhanjie 发表于 2014-9-23 09:42
SYMPTOMSDataPump fails with errorstack similar to the following:ORA-39014: One or more workers hav ...
在21点备份的时候，stream pool的大小由16MB调整为32MB，

千问 · 2014-10-9 06:00:13

super_sky 发表于 2014-9-23 11:20
看一下你的内存管理方式。是否开启了自动内存管理。如果没有开启，请扩大streams_pool_size值。
您看一下我贴的信息，这个脚本在20号备份失败的，25号我这边去掉了@nberp后备份成功，但是在27号又备份失败

千问 · 2014-10-9 06:00:13

兄弟，300多G的备份还是使用rman吧，更高效。