expdp导出报错解决过程

在HP-UNIX 11G RAC 一次逻辑备份报错解决过程：

    

DB01:[/home/oracle/script/bin]$sh expdp_sys_datacenter.sh

Export: Release 11.2.0.3.0 - Production on Fri Nov 8 11:39:37 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
and Data Mining options

UDE-31623: operation generated ORACLE error 31623
ORA-31623: a job is not attached to this session via the specified handle
ORA-06512: at "SYS.DBMS_DATAPUMP", line 3326
ORA-06512: at "SYS.DBMS_DATAPUMP", line 4551
ORA-06512: at line 1

 

--------登陆sqlplus 查看stream 池大小：

DB01:[/home/oracle/script/bin]$sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 8 11:41:06 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
and Data Mining options

SQL> select * from V$sgainfo;

NAME                                  BYTES RES
-------------------------------- ---------- ---
Fixed SGA Size                      2195216 No
Redo Buffers                       26554368 No
Buffer Cache Size                 402653184 Yes
Shared Pool Size                 1073741824 Yes
Large Pool Size                   134217728 Yes
Java Pool Size                    134217728 Yes
Streams Pool Size                         0 Yes
Shared IO Pool Size                       0 Yes
Granule Size                      134217728 No
Maximum SGA Size                 5.3447E+10 No
Startup overhead in Shared Pool   200987080 No

NAME                                  BYTES RES
-------------------------------- ---------- ---
Free SGA Memory Available        5.1674E+10

12 rows selected.

SQL> show parameter streams 

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
streams_pool_size                    big integer 0

 

---------------增加stream 池大小

SQL> alter system set streams_pool_size=1024m scope=spfile;

System altered.

--------------重启此节点实例

SQL> startup
ORACLE instance started.

Total System Global Area 5.5585E+10 bytes
Fixed Size                  2195856 bytes
Variable Size            5.5432E+10 bytes
Database Buffers          134217728 bytes
Redo Buffers               16965632 bytes
Database mounted.
Database opened.
SQL> exit

----------测试问题是否解决

B01:[/home/oracle/script/bin]$expdp   

Export: Release 11.2.0.3.0 - Production on Fri Nov 8 11:57:34 2013

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Username: ******
Password:

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP
and Data Mining options
Starting "SXSTSYS"."SYS_EXPORT_SCHEMA_01":  SXSTSYS/********
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/COMMENT
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
Master table "SXSTSYS"."SYS_EXPORT_SCHEMA_01" successfully loaded/unloaded
******************************************************************************
Dump file set for SXSTSYS.SYS_EXPORT_SCHEMA_01 is:
  /home/oracle/app/oracle/product/11.2.0/db_1/rdbms/log/expdat.dmp
Job "SXSTSYS"."SYS_EXPORT_SCHEMA_01" successfully completed at 11:59:10

DB01:[/home/oracle/script/bin]$