Parâmetros de exemplo do export:
[oracle@oel7 BSS]$ cat expdp.par
USERID=SYSTEM/"*******"
SCHEMAS=TESTE
DIRECTORY=BSS
DUMPFILE=DUMP.dmp
LOGFILE=DUMP.log
COMPRESSION=ALL
PARALLEL=2
Após o disparo do EXPDP, o seguinte erro é reportado:
[oracle@oel7 BSS]$ cat DUMP.log.old
;;;
Export: Release 12.2.0.1.0 - Production on Mon Feb 15 10:09:28 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
;;; **************************************************************************
;;; Parfile values:
;;; parfile: parallel=2
;;; parfile: compression=ALL
;;; parfile: logfile=DUMP.log
;;; parfile: dumpfile=DUMP.dmp
;;; parfile: directory=BSS
;;; parfile: schemas=TESTE
;;; parfile: userid=SYSTEM/********
;;; **************************************************************************
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": SYSTEM/******** parfile=expdp.par
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS [USER]
USER:"TESTE"
ORA-19505: failed to identify file "/stage/BSS/DUMP.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 12098
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPF$FILE", line 9298
ORA-06512: at "SYS.KUPF$FILE_INT", line 1111
ORA-06512: at "SYS.KUPF$FILE", line 9241
ORA-06512: at "SYS.KUPW$WORKER", line 10727
----- PL/SQL Call Stack -----
object line object
handle number name
0x229543850 32239 package body SYS.KUPW$WORKER.WRITE_ERROR_INFORMATION
0x229543850 12119 package body SYS.KUPW$WORKER.DETERMINE_FATAL_ERROR
0x229543850 11099 package body SYS.KUPW$WORKER.CREATE_OBJECT_ROWS
0x229543850 14526 package body SYS.KUPW$WORKER.FETCH_XML_OBJECTS
0x229543850 3689 package body SYS.KUPW$WORKER.UNLOAD_METADATA
0x229543850 13063 package body SYS.KUPW$WORKER.DISPATCH_WORK_ITEMS
0x229543850 2311 package body SYS.KUPW$WORKER.MAIN
0x17fae75d8 2 anonymous block
Object row index into parse items is: 1
Parse item count is: 4
In function CHECK_FOR_REMAP_NETWORK
Nothing to remap
In procedure BUILD_OBJECT_STRINGS - non-base info
In procedure BUILD_SUBNAME_LIST with USER:TESTE.TESTE
In function NEXT_PO_NUMBER
PO number assigned: 16285
KUPF$FILE.WRITE_LOB
In procedure DETERMINE_FATAL_ERROR with ORA-19505: failed to identify file "/stage/BSS/DUMP.dmp"
ORA-06512: at "SYS.KUPF$FILE", line 9298
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7
ORA-06512: at "SYS.KUPF$FILE_INT", line 1111
ORA-06512: at "SYS.KUPF$FILE", line 9241
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" stopped due to fatal error at Mon Feb 15 10:11:39 2021 elapsed 0 00:02:07
[oracle@oel7 BSS]$
Percebi que meu ambiente de origem é um Oracle RAC, e que devido isso, deveria adicionar o parâmetro CLUSTER no momento do export:
[oracle@oel7 BSS]$ cat expdp.par
USERID=SYSTEM/"*******"
SCHEMAS=TESTE
DIRECTORY=BSS
DUMPFILE=DUMP.dmp
LOGFILE=DUMP.log
COMPRESSION=ALL
PARALLEL=2
CLUSTER=NO
Após a alteração, o processo finalizou com êxito:
[oracle@oel7 BSS]$ cat DUMP.log
;;;
Export: Release 12.2.0.1.0 - Production on Mon Feb 15 10:14:37 2021
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
;;;
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
;;; **************************************************************************
;;; Parfile values:
;;; parfile: cluster=N
;;; parfile: parallel=2
;;; parfile: compression=ALL
;;; parfile: logfile=DUMP.log
;;; parfile: dumpfile=DUMP.dmp
;;; parfile: directory=BSS
;;; parfile: schemas=TESTE
;;; parfile: userid=SYSTEM/********
;;; **************************************************************************
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_02": SYSTEM/******** parfile=expdp.par
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/STATISTICS/MARKER
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/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE
Processing object type SCHEMA_EXPORT/VIEW/VIEW
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT
Processing object type SCHEMA_EXPORT/TABLE/TRIGGER
...
Master table "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_SCHEMA_02 is:
/stage/BSS/DUMP.dmp
Job "SYSTEM"."SYS_EXPORT_SCHEMA_02" successfully completed at Mon Feb 15 10:29:01 2021 elapsed 0 00:14:22
Portuguese
English
Spanish