最近做impdp数据泵全库导入的时候遇到了好多报错，现在记录下处理过程。 导入命令：
impdp \'/ as sysdba\' directory=EXPDP2020 dumpfile=xxxdb_%U.dump logfile=xxxdb_impdp.log PARALLEL=4 full=y table_exists_action=replace
报错如下：
.....
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM
>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1.
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS_TMP" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE GLOBAL TEMPORARY TABLE "ORDDATA"."ORDDCM_DOCS_TMP" ("DOC_ID" NUMBER(*,0) NOT NULL ENABLE, "DOC_NAME" VARCHAR2(100 CHAR) NOT NULL ENABLE, "DOC_TYPE_ID" NUMBER NOT NULL ENABLE, "DOC_CONTENT" "SYS"."XMLTYPE" NOT NULL ENABLE, "ORACLE_INSTALL" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, "CREATE_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE) ON COMMIT PRESERVE ROWS
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_CT_PRED_OPRD_TMP" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE GLOBAL TEMPORARY TABLE "ORDDATA"."ORDDCM_CT_PRED_OPRD_TMP" ("PID" NUMBER(*,0), "POS" NUMBER(3,0), "OPERAND" "SYS"."XMLTYPE" ) ON COMMIT PRESERVE ROWS
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS_WRK" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_DOCS_WRK" ("DOC_ID" NUMBER(*,0), "DOC_NAME" VARCHAR2(100 CHAR) NOT NULL ENABLE, "DOC_TYPE_ID" NUMBER NOT NULL ENABLE, "DOC_CONTENT" "SYS"."XMLTYPE" NOT NULL ENABLE, "ORACLE_INSTALL" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, "CREATE_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 2
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_MAPPING_DOCS_WRK" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_MAPPING_DOCS_WRK" ("DOC_ID" NUMBER(*,0) NOT NULL ENABLE, "ROOT_TAG" VARCHAR2(128 CHAR) NOT NULL ENABLE, "METADATA_NS" VARCHAR2(700 CHAR), "MAPPED_ELEM" VARCHAR2(128 CHAR), "UNMAPPED_ELEM" VARCHAR2(128 CHAR), "XSLT" "SYS"."XMLTYPE" , "IS_COVERED" NUMBER(1,0) NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 M
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_MAPPING_DOCS" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_MAPPING_DOCS" ("DOC_ID" NUMBER(*,0) NOT NULL ENABLE, "ROOT_TAG" VARCHAR2(128 CHAR) NOT NULL ENABLE, "METADATA_NS" VARCHAR2(700 CHAR), "MAPPED_ELEM" VARCHAR2(128 CHAR), "UNMAPPED_ELEM" VARCHAR2(128 CHAR), "XSLT" "SYS"."XMLTYPE" , "IS_COVERED" NUMBER(1,0) NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_CT_PRED_OPRD_WRK" ("PID" NUMBER(*,0), "POS" NUMBER(3,0), "OPERAND" "SYS"."XMLTYPE" ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_MAPPING_DOCS_TMP" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE GLOBAL TEMPORARY TABLE "ORDDATA"."ORDDCM_MAPPING_DOCS_TMP" ("DOC_ID" NUMBER(*,0) NOT NULL ENABLE, "ROOT_TAG" VARCHAR2(128 CHAR) NOT NULL ENABLE, "METADATA_NS" VARCHAR2(700 CHAR), "MAPPED_ELEM" VARCHAR2(128 CHAR), "UNMAPPED_ELEM" VARCHAR2(128 CHAR), "XSLT" "SYS"."XMLTYPE" , "IS_COVERED" NUMBER(1,0) NOT NULL ENABLE) ON COMMIT PRESERVE ROWS
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_DOCS" ("DOC_ID" NUMBER(*,0), "DOC_NAME" VARCHAR2(100 CHAR) NOT NULL ENABLE, "DOC_TYPE_ID" NUMBER NOT NULL ENABLE, "DOC_CONTENT" "SYS"."XMLTYPE" NOT NULL ENABLE, "ORACLE_INSTALL" NUMBER(1,0) DEFAULT 0 NOT NULL ENABLE, "CREATE_DATE" DATE DEFAULT SYSDATE NOT NULL ENABLE) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOM
ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_CT_PRED_OPRD" failed to create with error:
ORA-01031: insufficient privileges
Failing sql is:
CREATE TABLE "ORDDATA"."ORDDCM_CT_PRED_OPRD" ("PID" NUMBER(*,0), "POS" NUMBER(3,0), "OPERAND" "SYS"."XMLTYPE" ) SEGMENT CREATION IMMEDIATE PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/PRE_TABLE_ACTION
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
ORA-39083: Object type PRE_TABLE_ACTION failed to create with error:
ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
Failing sql is:
BEGIN
SYS.DBMS_DEFER_IMPORT_INTERNAL.QUEUE_IMPORT_CHECK('FINCDB','x86_64/Linux 2.4.xx');
END;
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
ORA-31693: Table data object "SMART"."TD_CUST_CAPITAL_LOG_H":"P202009" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/db/oracle/backup/fincdb_20201124_04.dump" for read
ORA-19505: failed to identify file "/home/db/oracle/backup/fincdb_20201124_04.dump"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3
ORA-31693: Table data object "SMART"."TD_CUST_CAPITAL_LOG_H":"P202007" failed to load/unload and is being skipped due to error:
ORA-31640: unable to open dump file "/home/db/oracle/backup/fincdb_20201124_02.dump" for read
ORA-19505: failed to identify file "/home/db/oracle/backup/fincdb_20201124_02.dump"
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
错误处理：1、Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PRE_SYSTEM_ACTIONS/PROCACT_SYSTEM>>> Cannot set an SCN larger than the current SCN. If a Streams Capture configuration was imported then the Apply that processes the captured messages needs to be dropped and recreated. See My Oracle Support article number 1380295.1.处理：添加参数STREAMS_CONFIGURATION=N，参考文档1380295.12、 ORA-39083: Object type TABLE:"ORDDATA"."ORDDCM_DOCS_TMP" failed to create with error: ORA-01031: insufficient privileges 处理：忽略，也可以手动执行失败的sql，可以执行成功。参考文档 DOC id 1909772.13、 global name不匹配 ORA-39083: Object type PRE_TABLE_ACTION failed to create with error: ORA-23327: imported deferred rpc data does not match GLOBAL NAME of importing db
目标端查询： SQL> select * from global_name; GLOBAL_NAME ------------------------------------------------------------------------- XXPDB alter database rename global_name to XXXCDB; impdp alter database rename global_name to XXPDB;
临时将global_name改为源端的global_name，导入完成后再改回去。 参考文档：DOC id 1568721.14、 Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA ORA-31693: Table data object "SMART"."TD_CUST_CAPITAL_LOG_H":"P202009" failed to load/unload and is being skipped due to error: ORA-31640: unable to open dump file "/home/db/oracle/backup/fincdb_20201124_04.dump" for read ORA-19505: failed to identify file "/home/db/oracle/backup/fincdb_20201124_04.dump" ORA-27037: unable to obtain file status Linux-x86_64 Error: 2: No such file or directory 解决：添加参数 clutter=n 参考文档 DOC id 14672321.1
