oracle 19c 数据泵备份错误 ORA-31693 ORA-39155 ORA-48128 ORA-19505 ORA-27037

问题描述

oracle19c下，使用数据泵备份数据库时，提示以下错误：

ORA-31693: Table data object "U1"."T1" failed to load/unload and is being skipped due to error:
ORA-39155: error expanding dump file name "/backup/D1_05.DMP"
ORA-48128: opening of a symbolic link is disallowed
ORA-19505: failed to identify file "/backup/D1_05.DMP"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 7

解决办法

经检查，发现新库使用RAC模式，此时进行数据泵并发备份或还原时，需要添加参数cluster=N

• 单实例下备份命令

expdp u1/pwd@ip/d1 dumpfile=d1_%U.dmp parallel=5 logfile=d1.expdp.log directory=dir_dp compression=all

• RAC模式下的备份命令

expdp u1/pwd@ip/d1 dumpfile=d1_%U.dmp parallel=5 cluster=N logfile=d1.expdp.log directory=dir_dp compression=all