【故障解决】ORA-06502错误解决

【故障解决】ORA-06502错误解决

【故障解决】ORA-06502: PL/SQL: numeric or value error: character string buffer too small

一.1  BLOG文档结构图

wpsFD2F.tmp[4] 

 

 

一.2  前言部分

 

一.2.1  导读和注意事项

各位技术爱好者,看完本文后,你可以掌握如下的技能,也可以学到一些其它你所不知道的知识,~O(∩_∩)O~:

① EXPDP和IMPDP基于scn的导出

② ora-06502的解决方法

 

  Tips:

       ① 若文章代码格式有错乱,推荐使用QQ或360浏览器,也可以下载pdf格式的文档来查看,pdf文档下载地址:http://yunpan.cn/cdEQedhCs2kFz  (提取码:ed9b) 

       ② 本篇BLOG中代码部分需要特别关注的地方我都用黄色背景和红色字体来表示,比如下边的例子中,thread 1的最大归档日志号为33,thread 2的最大归档日志号为43是需要特别关注的地方,命令一般使用粉红颜色标注,注释一般采用蓝色字体表示。

 

  List of Archived Logs in backup set 11

  Thrd Seq     Low SCN    Low Time            Next SCN   Next Time

  —- ——- ———- ——————- ———- ———

  1    32      1621589    2015-05-29 11:09:52 1625242    2015-05-29 11:15:48

  1    33      1625242    2015-05-29 11:15:48 1625293    2015-05-29 11:15:58

  2    42      1613951    2015-05-29 10:41:18 1625245    2015-05-29 11:15:49

  2    43      1625245    2015-05-29 11:15:49 1625253    2015-05-29 11:15:53

 

 

[ZFXDESKDB1:root]:/>lsvg -o

T_XDESK_APP1_vg

rootvg

[ZFXDESKDB1:root]:/>

[ZFXDESKDB1:root]:/>lsvg rootvg

 

 

====》2097152*512/1024/1024/1024=1G 

 

 

 

 

 

 

本文如有错误或不完善的地方请大家多多指正,ITPUB留言或QQ皆可,您的批评指正是我写作的最大动力。

 

 

一.2.2  相关参考文章链接

http://blog.itpub.net/29324876/viewspace-1248197/

http://blog.itpub.net/26736162/viewspace-1982160/

 

 

一.2.3  本文简介

 

执行导出操作的时候报错信息如下:

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_01 for user XXXXX

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPV$FT_INT”, line 389

ORA-39077: unable to subscribe agent KUPC$A_2_20210102154238 to queue “KUPC$C_2_20210102154237”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPC$QUE_INT”, line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

   网上查询后有网友已经遇到了,连接地址:http://blog.itpub.net/26736162/viewspace-1982160/ ,我直接根据这个来解决吧。

 

 

一.3  相关知识点扫盲

 

一.4  故障分析及解决过程

 

一.4.1  故障环境介绍

 

 项目

source db

db 类型

rac

db version

10.2.0.5

db 存储

FS type

ORACLE_SID

xxx

db_name

xxx

主机IP地址:

XXX.XXX.XXX.XXX

OS版本及kernel版本

AIX 6

OS hostname

ZTGXPADDB1

 

一.4.2  故障发生现象及报错信息

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX@22.188.131.27:1521/oraXPAD DIRECTORY=DATA_PUMP_DIR DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log FLASHBACK_SCN=12242466617347

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 15:42:47

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_01 for user XXXXX

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPV$FT_INT”, line 389

ORA-39077: unable to subscribe agent KUPC$A_2_20210102154238 to queue “KUPC$C_2_20210102154237”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPC$QUE_INT”, line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

 

 

 

 

一.4.3  故障分析过程

 

 oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX@22.188.131.27:1521/oraXPAD DIRECTORY=DATA_PUMP_DIR DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log FLASHBACK_SCN=12242466617347

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 15:42:47

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-31626: job does not exist

ORA-31638: cannot attach to job SYS_EXPORT_SCHEMA_01 for user XXXXX

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPV$FT_INT”, line 389

ORA-39077: unable to subscribe agent KUPC$A_2_20210102154238 to queue “KUPC$C_2_20210102154237”

ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 95

ORA-06512: at “SYS.KUPC$QUE_INT”, line 249

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

 

 

 

根据资料解决过程如下:

 

SELECT *

  FROM dba_objects d

 WHERE d.OBJECT_NAME like ‘%DATAPUMP%’

   AND D.OBJECT_TYPE = ‘SEQUENCE’;

wpsFD40.tmp[4] 

 

 

SELECT *

  FROM DBA_SEQUENCES D

 WHERE D.sequence_name IN

       (‘AQ$_KUPC$DATAPUMP_QUETAB_N’, ‘AQ$_KUPC$DATAPUMP_QUETAB_1_N’);

wpsFD41.tmp[4] 

 

 

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.5.0 – Production on Sat Jan 2 16:08:47 2021

 

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

 

SQL> SELECT   AQ$_KUPC$DATAPUMP_QUETAB_N.CURRVAL FROM DUAL;

SELECT   AQ$_KUPC$DATAPUMP_QUETAB_N.CURRVAL FROM DUAL

*

ERROR at line 1:

ORA-08002: sequence AQ$_KUPC$DATAPUMP_QUETAB_N.CURRVAL is not yet defined in

this session

 

 

SQL>  SELECT   AQ$_KUPC$DATAPUMP_QUETAB_N.NEXTVAL FROM DUAL;

 

   NEXTVAL

———-

   1194988

 

SQL> DROP SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_1_N;

DROP SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_1_N

              *

ERROR at line 1:

ORA-02289: sequence does not exist

 

 

SQL> DROP SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_N;

 

Sequence dropped.

 

SQL> CREATE SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_N MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20 CYCLE;

 

Sequence created.

 

SQL>  SELECT   AQ$_KUPC$DATAPUMP_QUETAB_N.NEXTVAL FROM DUAL;

 

   NEXTVAL

———-

         1

 

SQL> EXIT

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$

 

 

 

 

 

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ expdp XXXXX/XXXXX DIRECTORY=DATA_PUMP_DIR DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log  FLASHBACK_SCN=12242466617347

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 16:11:46

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

ORA-39002: invalid operation

ORA-39070: Unable to open the log file.

ORA-39087: directory name DATA_PUMP_DIR is invalid

wpsFD61.tmp[4] 

 

oracle@ZTGXPADDB1:/gg/ogg/dirrpt$ cd /oracle/app/oracle/product/10.2.0/db/rdbms/log/

 

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.5.0 – Production on Sat Jan 2 16:17:56 2021

 

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

 

SQL> grant read,write on directory DATA_PUMP_DIR to XXXXX;

 

Grant succeeded.

 

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ expdp XXXXX/XXXXX DIRECTORY=DATA_PUMP_DIR DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log  FLASHBACK_SCN=12242466617347

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 16:18:06

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting “XXXXX”.”SYS_EXPORT_SCHEMA_01″:  XXXXX/******** DIRECTORY=DATA_PUMP_DIR DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log FLASHBACK_SCN=12242466617347

Estimate in progress using BLOCKS method…

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/PROCEDURE

Processing object type SCHEMA_EXPORT/PACKAGE/COMPILE_PACKAGE/PACKAGE_SPEC/ALTER_PACKAGE_SPEC

Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION

Processing object type SCHEMA_EXPORT/PROCEDURE/ALTER_PROCEDURE

Processing object type SCHEMA_EXPORT/VIEW/VIEW

Processing object type SCHEMA_EXPORT/VIEW/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/PACKAGE/PACKAGE_BODY

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/REF_CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/TRIGGER

Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported “XXXXX”.”RICH_CUSTPRODUCTBAL”               63.64 KB     582 rows

. . exported “XXXXX”.”FINANCIAL_SALEBANK”                2.311 GB 28137697 rows

. . exported “XXXXX”.”XPADC_LCCPZTB”                     2.866 MB   32160 rows

. . exported “XXXXX”.”RICH_CUSTOMERINFO”                 616.9 KB    2596 rows

. . exported “XXXXX”.”RICH_CUSTACCOUNT”                  11.33 MB  177757 rows

. . exported “XXXXX”.”FINANCIAL_MESSAGEINFO”             329.7 MB 3067896 rows

. . exported “XXXXX”.”RICH_AUTOTRADE”                    36.53 KB     161 rows

. . exported “XXXXX”.”BASE_SYSLOG”                       24.70 KB     131 rows

. . exported “XXXXX”.”CORP_FINANCIAL_MESSAGEINFO”        7.820 KB       3 rows

. . exported “XXXXX”.”FINANCIAL_POSITIONHIS”             20.93 MB  413414 rows

. . exported “XXXXX”.”BASE_TRANCOURSE”                   23.38 KB     157 rows

 《《《《篇幅原因,有省略。。。。。。。。。。。。。。。》》》

UDE-00008: operation generated ORACLE error 31626

ORA-31626: job does not exist

ORA-39086: cannot retrieve job information

ORA-06512: at “SYS.DBMS_DATAPUMP”, line 2772

ORA-06512: at “SYS.DBMS_DATAPUMP”, line 3886

ORA-06512: at line 1

 

oracle@ZTGXPADDB1:/oracle/app/oracle/product/10.2.0/db/rdbms$ df -g

Filesystem    GB blocks      Free %Used    Iused %Iused Mounted on

/dev/hd4           2.00      1.82    9%     6857     2% /

/dev/hd2          10.00      6.01   40%    69921     5% /usr

/dev/hd9var        2.00      1.19   41%     3613     2% /var

/dev/hd3           2.00      1.75   13%     2572     1% /tmp

/dev/hd1           6.00      6.00    1%        9     1% /home

/proc                 –         –    –         –     –  /proc

/dev/hd10opt       2.00      1.69   16%     7156     2% /opt

/dev/Tlv_oracle     30.00      4.66   85%   645205    37% /oracle

/dev/Tlv_softtmp     80.00     79.56    1%       12     1% /softtmp

/dev/itm_lv        3.00      1.91   37%     5101     2% /opt/IBM/ITM

/dev/Tlv_xpad     95.00     35.89   63%     1118     1% /xpad

ZTINIMSERVER:/sharebin    100.00      2.12   98%  1219019    69% /sharebin

22.188.129.240:/sharebin    100.00      2.12   98%  1219019    69% /sharebin

22.188.129.240:/sharebkup   5500.00   1890.76   66%  2455955     1% /sharebkup

/dev/fslv00      300.00    284.07    6%       21     1% /ggbak

/dev/Tlv_gg      218.50     43.95   80%     4772     3% /gg

 

 

wpsFD72.tmp[4] 

 

 

 

 

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX DIRECTORY=DMP DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log  FLASHBACK_SCN=12242466617347

oracle@ZTGXPADDB1:/softtmp$ sqlplus / as sysdba

 

SQL*Plus: Release 10.2.0.5.0 – Production on Sat Jan 2 16:38:32 2021

 

Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.

 

 

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

 

SQL>  Select current_scn from v$database;

 

CURRENT_SCN

———–

  1.2242E+13

 

SQL>  col current_scn format 999999999999999

SQL> Select current_scn from v$database;

 

      CURRENT_SCN

—————-

   12242466771468

 

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX DIRECTORY=DMP DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log  FLASHBACK_SCN=12242466771468

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 16:39:06

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

FLASHBACK automatically enabled to preserve database integrity.

Starting “XXXXX”.”SYS_EXPORT_SCHEMA_01″:  XXXXX/******** DIRECTORY=DMP DUMPFILE=XXXXX_20160125.dmp LOGFILE=XXXXX_20160125.log FLASHBACK_SCN=12242466771468

Estimate in progress using BLOCKS method…

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 11.15 GB

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Processing object type SCHEMA_EXPORT/SYNONYM/SYNONYM

Processing object type SCHEMA_EXPORT/DB_LINK

Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE

Processing object type SCHEMA_EXPORT/TABLE/TABLE

Processing object type SCHEMA_EXPORT/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX

Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type SCHEMA_EXPORT/TABLE/COMMENT

 

Export> status

 

Job: SYS_EXPORT_SCHEMA_01

   Operation: EXPORT                        

   Mode: SCHEMA                        

   State: EXECUTING                     

   Bytes Processed: 0

   Current Parallelism: 1

   Job Error Count: 0

   Dump File: /softtmp/dmp/XXXXX_20160125.dmp

     bytes written: 4,096

  

Worker 1 Status:

   State: EXECUTING                     

   Object Schema: XXXXX

   Object Name: XPAD_SH

   Object Type: SCHEMA_EXPORT/PACKAGE/PACKAGE_SPEC

   Completed Objects: 1

   Total Objects: 1

   Worker Parallelism: 1

 

Export> kill_job

Are you sure you wish to stop this job ([yes]/no): yes

 

oracle@ZTGXPADDB1:/softtmp$

oracle@ZTGXPADDB1:/softtmp$

 

 

 

wpsFD73.tmp[4] 

wpsFD83.tmp[4] 

oracle@ZTGXPADDB1:/softtmp$

oracle@ZTGXPADDB1:/softtmp$ expdp XXXXX/XXXXX directory=DMP dumpfile=XXXXX_20160125_01.dmp LOGFILE=XXXXX_20160125.log  TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE,BASE_BRCHBANKCTRL,BASE_CERTIFICATE,BASE_CESS,BASE_COREBANK,BASE_CURRENCY,BASE_DEPARTMENT,BASE_HOLIDAYCALENDAR,BASE_HOLIDAYDATE,BASE_INTEREST,BASE_INTERESTHIS,BASE_MAINAREA,BASE_MENU,BASE_PRODTYPECODE,BASE_RATE,BASE_ROLE,BASE_SYSLOG,BASE_SYSPARAM,BASE_TERMINALTELLER,BASE_USER,FINANCIAL_BANKPROFITLOG,FINANCIAL_DIVIDENDPLAN,FINANCIAL_FUNDPRICE,FINANCIAL_INTERESTRESET,FINANCIAL_ISSUE,FINANCIAL_ISSUEAUDIT,FINANCIAL_ISSUEAUDITHIS,FINANCIAL_ISSUEBRAND,FINANCIAL_ISSUECFL,FINANCIAL_ISSUECONTROL,FINANCIAL_ISSUEDIFFRATE,FINANCIAL_ISSUEDISCOUNT,FINANCIAL_ISSUEEXPD,FINANCIAL_ISSUEEXT,FINANCIAL_ISSUEFEE,FINANCIAL_ISSUEFORCUSTRISKLVL,FINANCIAL_ISSUEFUNDSTRANSFER,FINANCIAL_ISSUEOBSERV,FINANCIAL_ISSUEPAY,FINANCIAL_ISSUEPROFIT,FINANCIAL_ISSUEQTYSPLIT,FINANCIAL_ISSUESELLCTRL,FINANCIAL_ISSUESERIAL,FINANCIAL_ISSUEVARIABLE,FINANCIAL_ISSUEWORKTIME,FINANCIAL_LIQUIDATEACT,FINANCIAL_MESSAGEINFO,FINANCIAL_PERIOD,FINANCIAL_PRICE,FINANCIAL_PRICEHIS,FINANCIAL_REFERINDEX,FINANCIAL_POSITION,RICH_AUTOTRADE,RICH_CUSTACCOUNT,RICH_CUSTAUTOTRADE,RICH_CUSTAUTOTRADEHIS,RICH_CUSTCAPITAL,RICH_CUSTFAVORABLE,RICH_CUSTFREEZEUNIT,RICH_CUSTFUNDPROFIT,RICH_CUSTIMPAWN,RICH_CUSTKEEPBAL,RICH_CUSTOMERINFO,RICH_CUSTOMERINFOHIS,RICH_CUSTORDERTRADE,RICH_CUSTPAYAMOUNTLOG,RICH_CUSTPRODUCTBAL,RICH_CUSTPRODUCTBALQTY,RICH_CUSTPROFITDCCY,RICH_CUSTPROFITLOG,RICH_CUSTPROFITNORMAL,RICH_CUSTPROFITPAYMODE,RICH_CUSTPROFITPAYMODEHIS,RICH_CUSTRISKLVL,RICH_FUNDTRADELOG,RICH_NOPAYAMOUNT,RICH_NORMALPAY,RICH_ORDERTRADE,RICH_SMSCMDSIGN,RICH_SMSCMDTRADE,RICH_STARTBAL,RICH_STARTBALHIS,financial_positionhis,financial_positiontra,financial_positioncst,financial_positionacc,corp_stattemptab,corp_stattemptabacc,corp_stattemptabcst,FINANCIAL_ICCARDCODE,BASE_FINANCIALICCARD,FINANCIAL_ISSUESPECIFICATION,PA_RPT_PARAM,FINANCIAL_SALEBANK_HIS,RICH_TRADELOG_HIS,RICH_CUSTPAYAMOUNTHIS_HIS,RICH_CUSTPRODUCTBALHIS_HIS,RIC

 

Export: Release 10.2.0.5.0 – 64bit Production on Saturday, 02 January, 2021 16:41:50

 

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

 

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, Real Application Clusters, Data Mining and Real Application Testing options

Starting “XXXXX”.”SYS_EXPORT_TABLE_01″:  XXXXX/******** directory=DMP dumpfile=XXXXX_20160125_01.dmp LOGFILE=XXXXX_20160125.log TABLES=BASE_ACTIONPOWER,BASE_BANK,BASE_BANKMERGE,BASE_BANKTREE,BASE_BRCHBANKCTRL,BASE_CERTIFICATE,BASE_CESS,BASE_COREBANK,BASE_CURRENCY,BASE_DEPARTMENT,BASE_HOLIDAYCALENDAR,BASE_HOLIDAYDATE,BASE_INTEREST,BASE_INTERESTHIS,BASE_MAINAREA,BASE_MENU,BASE_PRODTYPECODE,BASE_RATE,BASE_ROLE,BASE_SYSLOG,BASE_SYSPARAM,BASE_TERMINALTELLER,BASE_USER,FINANCIAL_BANKPROFITLOG,FINANCIAL_DIVIDENDPLAN,FINANCIAL_FUNDPRICE,FINANCIAL_INTERESTRESET,FINANCIAL_ISSUE,FINANCIAL_ISSUEAUDIT,FINANCIAL_ISSUEAUDITHIS,FINANCIAL_ISSUEBRAND,FINANCIAL_ISSUECFL,FINANCIAL_ISSUECONTROL,FINANCIAL_ISSUEDIFFRATE,FINANCIAL_ISSUEDISCOUNT,FINANCIAL_ISSUEEXPD,FINANCIAL_ISSUEEXT,FINANCIAL_ISSUEFEE,FINANCIAL_ISSUEFORCUSTRISKLVL,FINANCIAL_ISSUEFUNDSTRANSFER,FINANCIAL_ISSUEOBSERV,FINANCIAL_ISSUEPAY,FINANCIAL_ISSUEPROFIT,FINANCIAL_ISSUEQTYSPLIT,FINANCIAL_ISSUESELLCTRL,FINANCIAL_ISSUESERIAL,FINANCIAL_ISSUEVARIABLE,FINANCIAL_ISSUEWORKTIME,FINANCIAL_LIQUIDATEACT,FINANCIAL_MESSAGEINFO,FINANCIAL_PERIOD,FINANCIAL_PRICE,FINANCIAL_PRICEHIS,FINANCIAL_REFERINDEX,FINANCIAL_POSITION,RICH_AUTOTRADE,RICH_CUSTACCOUNT,RICH_CUSTAUTOTRADE,RICH_CUSTAUTOTRADEHIS,RICH_CUSTCAPITAL,RICH_CUSTFAVORABLE,RICH_CUSTFREEZEUNIT,RICH_CUSTFUNDPROFIT,RICH_CUSTIMPAWN,RICH_CUSTKEEPBAL,RICH_CUSTOMERINFO,RICH_CUSTOMERINFOHIS,RICH_CUSTORDERTRADE,RICH_CUSTPAYAMOUNTLOG,RICH_CUSTPRODUCTBAL,RICH_CUSTPRODUCTBALQTY,RICH_CUSTPROFITDCCY,RICH_CUSTPROFITLOG,RICH_CUSTPROFITNORMAL,RICH_CUSTPROFITPAYMODE,RICH_CUSTPROFITPAYMODEHIS,RICH_CUSTRISKLVL,RICH_FUNDTRADELOG,RICH_NOPAYAMOUNT,RICH_NORMALPAY,RICH_ORDERTRADE,RICH_SMSCMDSIGN,RICH_SMSCMDTRADE,RICH_STARTBAL,RICH_STARTBALHIS,financial_positionhis,financial_positiontra,financial_positioncst,financial_positionacc,corp_stattemptab,corp_stattemptabacc,corp_stattemptabcst,FINANCIAL_ICCARDCODE,BASE_FINANCIALICCARD,FINANCIAL_ISSUESPECIFICATION,PA_RPT_PARAM,FINANCIAL_SALEBANK_HIS,RICH_TRA

Estimate in progress using BLOCKS method…

Processing object type TABLE_EXPORT/TABLE/TABLE_DATA

Total estimation using BLOCKS method: 6.913 GB

Processing object type TABLE_EXPORT/TABLE/TABLE

Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX

Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/COMMENT

Processing object type TABLE_EXPORT/TABLE/TRIGGER

Processing object type TABLE_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX

Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS

Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS

. . exported “XXXXX”.”RICH_CUSTPRODUCTBAL”               63.64 KB     582 rows

. . exported “XXXXX”.”RICH_CUSTOMERINFO”                 616.9 KB    2596 rows

. . exported “XXXXX”.”RICH_CUSTACCOUNT”                  11.33 MB  177757 rows

. . exported “XXXXX”.”FINANCIAL_MESSAGEINFO”             329.7 MB 3067896 rows

 《《《《篇幅原因,有省略。。。。。。。。。。。。。。。》》》

. . exported “XXXXX”.”RICH_TRADELOG_HIS”:”P_201411″          0 KB       0 rows

. . exported “XXXXX”.”RICH_TRADELOG_HIS”:”P_201412″          0 KB       0 rows

. . exported “XXXXX”.”RICH_TRADELOG_HIS”:”P_999999″          0 KB       0 rows

ORA-39166: Object RIC was not found.

Master table “XXXXX”.”SYS_EXPORT_TABLE_01″ successfully loaded/unloaded

******************************************************************************

Dump file set for XXXXX.SYS_EXPORT_TABLE_01 is:

   /softtmp/dmp/XXXXX_20160125_01.dmp

Job “XXXXX”.”SYS_EXPORT_TABLE_01″ completed with 1 error(s) at 16:42:37

 

 

 

一.5  故障处理总结

删除sys下的DATAPUMP序列号,因为该序列号不能超过6位,后续版本已经fixed的了。

SQL> DROP SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_N;

 

Sequence dropped.

 

SQL> CREATE SEQUENCE AQ$_KUPC$DATAPUMP_QUETAB_N MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20 CYCLE;

 

到此所有的处理算是基本完毕,过程很简单,但是不同的场景处理方式有很多种,我们应该学会灵活变通。

 

 

 

一.6  About Me

 

…………………………………………………………………………………………………………………………………………………………………….

本文作者:小麦苗,只专注于数据库的技术,更注重技术的运用

ITPUB BLOG:http://blog.itpub.net/26736162

本文地址:http://blog.itpub.net/26736162/viewspace-1982193/

本文pdf版:http://yunpan.cn/cdEQedhCs2kFz (提取码:ed9b)

QQ:642808185 若加QQ请注明所正在读的文章标题

2016-01-25 10:00~ 2016-01-25 19:00 在中行完成

<版权所有,文章允许转载,但须以链接方式注明源地址,否则追究法律责任!>

…………………………………………………………………………………………………………………………………………………………………….

 

 

版权声明:本文内容由互联网用户自发贡献,该文观点仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 举报,一经查实,本站将立刻删除。

发布者:全栈程序员-用户IM,转载请注明出处:https://javaforall.cn/109158.html原文链接:https://javaforall.cn

【正版授权,激活自己账号】: Jetbrains全家桶Ide使用,1年售后保障,每天仅需1毛

【官方授权 正版激活】: 官方授权 正版激活 支持Jetbrains家族下所有IDE 使用个人JB账号...

(0)
blank

相关推荐

  • vue跨域解决的几种方案「建议收藏」

    vue跨域解决的几种方案「建议收藏」vue跨域解决的几种方案一、开发环境解决跨域方法平时使用vue开发的时候,大多会使用vue-cli搭建项目,在vue-cli搭建的项目中有一个配置文件vue.config.js,可以在该文件中进行相应的配置解决开发环境的跨域问题。第一步设置公共urlapi/index.jsimportaxiosfrom’axios’importrouterfrom’@/router/index.js’importstorefrom’@/store/index.js’//创建一个axios

  • Android Hook技术实践

    Android Hook技术实践一、hook简介hook俗称钩子,主要作用是替换系统内存中的对象,在上层调用此对象的方法的时候可以修改传入参数或者返回值,达到欺骗上层的目的,就像小红帽故事里的大灰狼,通过扮演小红帽的外婆的角色来达到欺骗小红帽的目的。其实hook就是一种中间人劫持的思想,如图所示:在安卓中实现hook主要通过两种方式:1.反射技术和代理实现,当然代理不管是动态还是静态的都是可以实现的,但是只能ho

  • Java开发框架!高级java工程师简历模板[通俗易懂]

    第一部分必读系列:01.学习算法和刷题的思路指南02.学习数据结构和算法读什么书03.动态规划解题套路框架04.动态规划答疑篇05.动态规划答疑篇06.回溯算法解题套路框架07.二分查找解题套路框架08.滑动窗口解题套路框架09.双指针技巧总结10.BFS算法套路框架11.Linux的进程、线程、文件描述符是什么12.Git/SQL/正则表达式的在线练习平台第二部分动态规划系列:01.动态规划设计:最长递增子序列02.经典动态规划:0-1背包问题03.经典动态规划:完

  • vmware虚拟机linux使用教程_vmware ubuntu安装教程

    vmware虚拟机linux使用教程_vmware ubuntu安装教程一、安装VMware下载地址(16pro):https://www.aliyundrive.com/s/FSktJJXsfa8安装:选一下安装地址,一直下一步即可。(可能会要求重启电脑,重启即可)二、安装Linux下载地址:CentOS-7.5提取码:486k接下来看图操作2.1新建虚拟机现在我们就相当于买电脑,先把电脑配置整好。什么cpu啊内存条啊硬盘啊什么乱七八糟的,先不着急装系统。这里看你装什么版本的Linux了,我装的是GenOS7.564位所以选的是Ge

    2022年10月21日
  • css动画和js动画的差异_css过渡和动画的区别

    css动画和js动画的差异_css过渡和动画的区别在工作中,经常会写点动画效果,常用的方式有CSS动画还有JS动画,根据项目的需求,采用的方案各不相同,但是两者实现的性能分析没有进行对比。总结网上相关资料,在这里简单整理下本文主要讲以下这些内容1、浏览器渲染流程2、回流和重绘3、CSS动画4、JS动画两者对比????1.浏览器的渲染流程渲染流程主要有4个步骤解析HTML生成DOM树解析CSS样式生成CSSOM树,CSSOM树与DOM树结合生成Rendertree布局RenderTree对每个节点进

    2022年10月15日
  • iOS 开发之实现 App 消息推送(最新)[通俗易懂]

    iOS 开发之实现 App 消息推送(最新)[通俗易懂]今天就由本菜鸟给大家做一个简单的IOSApp消息推送教程吧!一切从0开始,包括XCode6,IOS8,以及苹果开发者中心最新如何注册应用,申请证书以及下载配置概要文件,相信很多刚开始接触ios的人会很想了解一下。(ps:网上看了一下虽然有很多讲述推送的好教程,我也是看着一步步学会的,但是这些教程的时间都是去年或者更早时期的,对引导新手来说不是很合适)

发表回复

您的电子邮箱地址不会被公开。

关注全栈程序员社区公众号