ORA-39095 while performing EBS R12.1.3 database export

Posted byIndraneil SealPosted inUncategorized

We encountered ORA-39095 while performing EBS R12.1.3 database export.

It stopped twice with below error.

ORA-39095: Dump file space has been exhausted: Unable to allocate 4096 bytes
Job “SYSTEM”.”SYS_EXPORT_FULL_01″ stopped due to fatal error at Thu Mar 19 14:42:31 2020 elapsed 0 05:01:01

We had sufficient disk space, however we encountered this issue because we limited filesize to 10G that led to creation of 99 dump files so far.

The wildcard format for dump (dumpfile=_%U.dmp) can expand up to 99 files. However in our case the database size was around 2TB and total dump size 1.4TB. Since 99 files(99*10G=990G dump created) have been generated (1.4TB – 990GB=still to go) before the export has completed, it probably ran into the ORA-39095 error.

To overcome this issue, we can set a bigger FILESIZE parameter or use dumpfile format like (dumpfile=1_%U.dmp, 2_%U.dmp, 3_%U.dmp), which can expand up to 3*99 files.

Since we had network bandwidth restriction mandated by the IT team, so instead of setting bigger filesize we used dumpfile=1_%U.dmp, 2_%U.dmp, 3_%U.dmp.

Here’s revised export par file auexpdp.dat:

$ cat auexpdp.dat

directory=dmpdir
dumpfile=expdp_full_1_%U.dmp,expdp_full_2_%U.dmp,expdp_full_3_%U.dmp
filesize=10G
full=y
logfile=LOGDIR:expdp_full.log
metrics=y
parallel=16
logtime=all
EXCLUDE=STATISTICS
CLUSTER=N
QUERY=applsys.wf_item_attribute_values:”where item_type!=’WFERROR’ and name != ‘EVENT_MESSAGE'”

Published by Indraneil Seal

I originally hail from Kolkata, India, and I've dedicated a significant portion of my professional journey to both India and the United States before relocating to Canada during the pandemic. I’m a member of MongoDB's esteemed Technical Services team. Before joining this exceptional group, I held the role of Senior Apps DBA at the Government of Ontario. Prior to that, I spent many years honing my technical(DBA/Cloud) and soft skills with TCS, KBACE Technologies(which later got acquired by Cognizant Technology Solutions) and Oracle Corporation. Throughout my career, I was deeply immersed in day-to-day operations and spearheaded significant projects, including the modernization of platforms, Oracle application and database upgrades. In my last stint at the Government of Ontario, I was also responsible for overseeing various automation initiatives including out-of-place patching, automated EBS Application patching. Outside of my professional life, I have a strong passion for reading, blogging, spending quality time with my family, and my feline buddies, Smokey & Louis. I also relish solitary walks and jogging as personal interests. As a proponent of open source technologies, I'm looking forward to sharing my knowledge and expertise as well as contribute as much as possible to the success of the IT fraternity thereby perpetually expanding my skillset.

Leave a comment