Home » RDBMS Server » Server Utilities » How to setup Data Pump resumable error timeout (Oracle 10gR2)
How to setup Data Pump resumable error timeout [message #492999] Fri, 04 February 2011 03:59 Go to next message
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 Go to previous messageGo to next message
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 #493124 is a reply to message #493081] Sat, 05 February 2011 03:29 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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.

Did you understand why your getting this error? Have you checked ORA-01691?
ORA-01691:
unable to extend lob segment string.string by string in tablespace string
Cause:	 Failed to allocate an extent of the required number of blocks for LOB segment in the tablespace indicated.
Action:	 Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
Re: How to setup Data Pump resumable error timeout [message #493272 is a reply to message #493124] Mon, 07 February 2011 03:35 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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;


Re: How to setup Data Pump resumable error timeout [message #493310 is a reply to message #493301] Mon, 07 February 2011 05:02 Go to previous message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thanks for the feedback, it will be useful.

Regards
Michel
Previous Topic: ORA-31685 and ORA-01932
Next Topic: ora-39082
Goto Forum:
  


Current Time: Thu Dec 03 22:58:03 CST 2020