ORA-39171: Job is experiencing a resumable wait

While exporting my one of the database with data pump backup utility, Backup has been stuck with ORA-01691: unable to extend lob segment & ORA-39171: Job is experiencing a resumable wait ora errors.

Oracle error pretty much self explanatory. After diagnosing ORA-01691 & ORA-39171, I came across the system tablespace having lack of space allocated, after adding new datafile ( alter tablespace… ) to system tablespace backup job has been resumed & successfully completed.

//Export Logs as below:

OracleDB:ora 19> expdp system/manager directory=dirdmp schemas=Prod dumpfile=Prod_260314%U.dmp logfile=Prod_260314.log compression=all parallel=4
Export: Release 11.2.0.3.0 – Production on Thu Mar 27 11:06:15 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting “SYSTEM”.”SYS_EXPORT_SCHEMA_03″: system/******** directory=dirdmp schemas=Prod dumpfile=Prod_260314%U.dmp logfile=Prod_260314.log compression=all parallel=4
Estimate in progress using BLOCKS method…
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 310.1 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
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment SYSTEM.SYS_LOB0000653170C00045$$ by 1024 in tablespace SYSTEM
ORA-39171: Job is experiencing a resumable wait.

// SQL command use to increase tablespace size is as below:
SQL>alter tablespace SYSTEM add datafile ‘/oracle/Prod/sapdata1/system_1/system.data2.dbf’ size 500m autoextend on maxsize unlimited;

***********************************************************************
Note: Please don’t hesitate to revert in case of any query OR feedback.

Thanking you.

Have a easy life ahead.

Leave a Reply