DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-29913 ORA-39155 ORA-48128 ORA-19505 ORA-27037 In a RAC Environment

Problem:

執行datapump資料庫匯出到NFS空間,發生ORA-錯誤

$ cat expdp_PST_20231004.par

userid=system/password
directory=stdump
dumpfile=expdp_PST_20231004_%U.dmp
logfile=expdp_PST_20231004.log
parallel=16
compression=all
exclude=grant,statistics
schemas=PST

$ expdp parfile=expdp_PST_20231004.par

Log output ORA Errors

ORA-31693: Table data object "PST"."ROLE_PRIVILEGE" failed to load/unload and is being skipped due to error:
ORA-29913: error in executing ODCIEXTTABLEPOPULATE callout
ORA-39155: error expanding dump file name "/all_dmp/expdp_pst_cloud_20231004_07.dmp"
ORA-48128: opening of a symbolic link is disallowed
ORA-19505: failed to identify file "/all_dmp/expdp_pst_cloud_20231004_07.dmp"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

Solution:

1. Share/mount the dumpfile destination with all RAC nodes performing the expdp

- OR -

2. Use CLUSTER=N during Datapump so it will only run on the node which has the mount point and permissions to write to it.

$ cat expdp_PST_20231004.par

userid=system/password
directory=stdump
dumpfile=expdp_PST_20231004_%U.dmp
logfile=expdp_PST_20231004.log
parallel=16
cluster=n
compression=all
exclude=grant,statistics
schemas=PST

Ref:

DataPump Export (EXPDP) Fails With Errors ORA-31693 ORA-31617 ORA-19505 ORA-27037 In a RAC Environment (Doc ID 1597395.1)

張貼留言

0 留言