远程impdp 导入 遇到 [klaprs_12], [0], [1], [2246], [], [], [], [], [], [], [], []

美国数据库因为成本原因 使用了 标准版的数据库 ,版本为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




  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值