ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

·

2 min read

El otro día me enviaron este error:

[oracle@]$ expdp \'sys/******@****** as sysdba\' parfile=export.par
Export: Release 19.0.0.0.0 - Production on Wed Mar 27 16:11:24 2024
Version 19.19.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 19c EE High Perf Release 19.0.0.0.0 - Production
27-MAR-24 16:11:26.297: FLASHBACK automatically enabled to preserve database integrity.
27-MAR-24 16:11:28.452: Starting "SYS"."SYS_EXPORT_SCHEMA_01":  "******/********@****** AS SYSDBA" parfile=export.par
27-MAR-24 16:11:29.070: W-1 Startup took 0 seconds
27-MAR-24 16:11:32.411: W-2 Startup took 0 seconds
27-MAR-24 16:11:33.412: W-1 Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
27-MAR-24 16:11:35.299: W-3 Startup took 0 seconds
27-MAR-24 16:11:37.551: W-8 Startup took 0 seconds
27-MAR-24 16:11:38.833: W-1 . . exported ....
27-MAR-24 16:11:43.549: ORA-39095: Dump file space has been exhausted: Unable to allocate 8192 bytes

Revisando el parfile, vi que faltaba el "%u" del parámetro DUMPFILE. Este comodín indica a Oracle que cree de manera consecutiva ficheros dmp del tamaño que le especifiques (parámetro FILESIZE), así hasta un total de 99.

Modificamos el parfile indicando el comodín junto con el tamaño de cada dmp, quedando de la siguiente manera:

DIRECTORY=DIR
FLASHBACK_TIME=SYSTIMESTAMP
PARALLEL=8
LOGTIME=ALL
METRICS=YES
EXCLUDE=STATISTICS
LOGFILE=XXXXXX.log
DUMPFILE=XXXXXX%U.dmp
FILESIZE=50G
CONTENT=DATA_ONLY
SCHEMAS=XXXXXX

Ejecutamos de nuevo

27-MAR-24 16:17:33.935: ******************************************************************************
27-MAR-24 16:17:33.936: Dump file set for SYS.SYS_EXPORT_SCHEMA_02 is:
27-MAR-24 16:17:33.938:   /export/DAG01.dmp
27-MAR-24 16:17:33.938:   /export/DAG02.dmp
27-MAR-24 16:17:33.938:   /export/DAG03.dmp
27-MAR-24 16:17:33.939:   /export/DAG04.dmp
27-MAR-24 16:17:33.939:   /export/DAG05.dmp
27-MAR-24 16:17:34.361: Job "SYS"."SYS_EXPORT_SCHEMA_02" successfully completed at Wed Mar 27 16:17:34 2024 elapsed 0 00:01:48

Listo. El export ha funcionado correctamente. Espero que os sirva.