今天处理数据,遇到两个报错,记录于下
数据库版本:
CORE 12.1.0.2.0 Production
21342624;
24846605;OCW Interim patch for 24846605
24340679;DATABASE BUNDLE PATCH: 12.1.0.2.161018 (24340679)
OPatch succeeded.
小补丁是打到2016年十月份的
报错1:
ORA-19505: failed to identify file "/home/oracle/backup/rms_10.dmp"
ORA-31617: unable to open dump file "/home/oracle/backup/rms_08.dmp" for write
ORA-19505: failed to identify file "/home/oracle/backup/rms_08.dmp"
ORA-31617: unable to open dump file "/home/oracle/backup/rms_11.dmp" for write
ORA-19505: failed to identify file "/home/oracle/backup/rms_11.dmp"
ORA-31617: unable to open dump file "/home/oracle/backup/rms_12.dmp" for write
ORA-19505: failed to identify file "/home/oracle/backup/rms_12.dmp"
ORA-31617: unable to open dump file "/home/oracle/backup/rms_09.dmp" for write
ORA-19505: failed to identify file "/home/oracle/backup/rms_09.dmp"
ORA-31617: unable to open dump file "/home/oracle/backup/rms_14.dmp" for write
这里是因为是rac环境,所以
加上参数
cluster=n
expdp system/****** parallel=15 directory=hdp schemas=rms dumpfile=rms_%U.dmp logfile=rms.log
报错2:
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GATHER_PARSE_ITEMS [JAVA_SOURCE:"RMS"."oracle/retail/integration/services/consumer/DrillBackForwardUrlService/runtime/PingResponse_LiteralSerializer"]
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
这是提oracle support的一个问题,不过后来oracle support过期了 这个事情就不了了知了。可以认定为oracle 12c的一个bug
所以我只能过滤试试,再说我们也没有用到java_source这个东西
exclude=java_source
expdp system/****** parallel=15 directory=hdp schemas=rms dumpfile=rms_%U.dmp cluster=n logfile=rms.log exclude=java_source