美国数据库因为成本原因 使用了 标准版的数据库 ,版本为11.2.0.4 V12
[oracle@eimgdb1 admin]$ impdp eXXXDBA@XXXX_to_rds SCHEMAS=XXXr,XX,XXX DUMPFILE=usa_20170725.dmp DIRECTORY=DATA_PUMP_DIR logfile=to_rds.log
Import: Release 11.2.0.4.0 - Production on Wed Jul 26 20:53:10 2017
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
ORA-39002: invalid operation
ORA-31694: master table "XXXXX"."SYS_IMPORT_SCHEMA_01" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-39776: fatal Direct Path API error loading table "XXXXX"."SYS_IMPORT_SCHEMA_01"
ORA-00600: internal error code, arguments: [klaprs_12], [0], [1], [2246], [], [], [], [], [], [], [], []
查询了mos 如下触发bug
Bug 6368018 Data pump import with compression=data_only fails (OERI:klaprs_11 OERI:klaprs_12)
This note gives a brief overview of bug 6368018.
The content was last updated on: 16-SEP-2011
Click here for details of each of the sections below.
Affects:
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 11.2
Versions confirmed as being affected
11.1.0.6
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in
11.2.0.1 (Base Release)
11.1.0.7 (Server Patch Set)
11.1.0.6 Patch 5 on Windows Platforms
Symptoms:
Related To:
Internal Error May Occur (ORA-600)
ORA-600 [klaprs_11]
ORA-600 [klaprs_12]
Datapump Export/Import
Description
Loading a compressed DataPump dump file may fail loading a table
with ORA-600 [klaprs_11] and/or ORA-600 [klaprs_12] if the export
file was created with compression=data_only
Please note: The above is a summary description only. Actual symptoms can vary. Matching to any symptoms here does not confirm that you are encountering this problem. For questions about this bug please consult Oracle Support.
References
Bug:6368018 (This link will only work for PUBLISHED bugs)
Note:245840.1 Information on the sections in this article
尝试重新导出使用参数 compression = none
expdp \'/ as sysdba\' DIRECTORY=DATA_PUMP_DIR DUMPFILE=usa_20170727.dmp LOGFILE=center20170713.log SCHEMAS=Cxxxxx,aaaa2,ccc COMPRESSION=none cluster=no
BEGIN
DBMS_FILE_TRANSFER.PUT_FILE(
source_directory_object => 'DATA_PUMP_DIR',
source_file_name => 'usa_20170727.dmp',
destination_directory_object => 'DATA_PUMP_DIR',
destination_file_name => 'usa_20170727.dmp',
destination_database => 'to_rds'
);
END;
/
[oracle@xxx log]$ impdp exxxxlDBA@eimgdb_to_rds DUMPFILE=usa_20170727.dmp DIRECTORY=DATA_PUMP_DIR SCHEMAS=xx,xx,sss logfile=to_rds.log