| How to setup Data Pump resumable error timeout [message #492999] |
Fri, 04 February 2011 03:59  |
metabaron
Messages: 13
Registered: September 2010
|
Junior Member |
|
|
Hi all
Do you know if there is a way to setup Data Pump Export timeout on resumable error (like with classique export).
Seems that default timeout is 2h (7200s).
I have tried to set system parameter 'resumable_timeout' from 0 to 60 but no change.
I would like to script an export, but I just want that the script exits on errors like this one:
ORA-39171: Le travail se heurte à une attente avec possibilité de reprise.
ORA-01691: impossible d'étendre le segment LOB SYS.SYS_LOB0000145352C00039$$ de 128 dans le tablespace SYSTEM
Actually, the script have to wait 2h for expdp timeout.
Thank you
[Updated on: Fri, 04 February 2011 06:41] Report message to a moderator |
|
|
|
| Re: How to setup Data Pump resumable error timeout [message #493081 is a reply to message #492999] |
Fri, 04 February 2011 11:50  |
claessen
Messages: 1
Registered: November 2009
|
Junior Member |
|
|
Per documentation, download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_export.htm#g1022624 (add the http, I'm not able to post links), there is no corollary in DataPump to the RESUMABLE_TIMEOUT in the original export utility.
Would it help to provide the status parameter? Also referenced in the above documentation; this provides the interval (in seconds) between periodic status updates on the job.
|
|
|
|
|
|
| Re: How to setup Data Pump resumable error timeout [message #493272 is a reply to message #493124] |
Mon, 07 February 2011 03:35 |
metabaron
Messages: 13
Registered: September 2010
|
Junior Member |
|
|
Yes I have read the doc about this RESUMABLE_TIMEOUT original parameter. But maybe there was someone that know a way to get around with this limitation that seems to be a 'regression' from original export utility.
The STATUS parameter seems to be about the export log monitoring. But I cant use it as it's just an interactive mode command, not a command line mode one.
And yes I know why I have this error. This was just an example of 'resumable error'. Like I explained, this will be run by SCRIPT,so I have other tasks after this export and I need a way to avoid the script to be stuck on ANY error: There will be no one to manage these errors before the end, especially if the script cant send a warning mail on errors ... because it's stuck!!
|
|
|
|
| Re: How to setup Data Pump resumable error timeout [message #493301 is a reply to message #493272] |
Mon, 07 February 2011 04:52 |
metabaron
Messages: 13
Registered: September 2010
|
Junior Member |
|
|
OK I got it. The solution is to use AFTER SUSPEND trigger:
download.oracle.com/docs/cd/B28359_01/server.111/b28310/schema002.htm#insertedID3
Also working for oracle 10g
CREATE OR REPLACE TRIGGER resumable_default_timeout
AFTER SUSPEND
ON DATABASE
BEGIN
DBMS_RESUMABLE.SET_TIMEOUT( timeout );
END;
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
