ORA-3912，ORA-06502：从active data guard expdp导出数据报错

ziyoo0830

数据库版本：11.2.0.1.0
os：redhat4

从adg做exp数据导出测试：
其中oradg为primary database ,exp_dgtest1指向物理standby database ,
物理dg状态如下：

SYS@dgtest1>select status from v$instance ;

STATUS
------------
OPEN

SYS@dgtest1>alter database recover managed standby database disconnect;

Database altered.

SYS@dgtest1>select db_unique_name,open_mode from v$database;

DB_UNIQUE_NAME                 OPEN_MODE
------------------------------ --------------------
dgtest1                        READ ONLY WITH APPLY


下面为输出过程：

*oracle-oradg-/u02/backups/expdp>expdp system/password@oradg directory=expdp_oradg network_link=exp_dgtest1 tables=scott.t dumpfile=scott_t.dump logfile=full_standby.log

Export: Release 11.2.0.1.0 - Production on Fri Mar 28 08:30:52 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_08":  system/********@oradg directory=expdp_oradg network_link=exp_dgtest1 tables=scott.t dumpfile=scott_t.dump logfile=full_standby.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_METADATA", line 2625
ORA-06512: at "SYS.DBMS_METADATA", line 2668
ORA-06512: at "SYS.DBMS_METADATA", line 2974
ORA-06512: at "SYS.DBMS_METADATA", line 5161

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8159

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x449cc794     19028  package body SYS.KUPW$WORKER
0x449cc794      8191  package body SYS.KUPW$WORKER
0x449cc794     12728  package body SYS.KUPW$WORKER
0x449cc794      2425  package body SYS.KUPW$WORKER
0x449cc794      8846  package body SYS.KUPW$WORKER
0x449cc794      1651  package body SYS.KUPW$WORKER
0x4484f3b4         2  anonymous block

Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS []
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMS_METADATA", line 2625
ORA-06512: at "SYS.DBMS_METADATA", line 2668
ORA-06512: at "SYS.DBMS_METADATA", line 2974
ORA-06512: at "SYS.DBMS_METADATA", line 5161

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.KUPW$WORKER", line 8159

----- PL/SQL Call Stack -----
  object      line  object
  handle    number  name
0x449cc794     19028  package body SYS.KUPW$WORKER
0x449cc794      8191  package body SYS.KUPW$WORKER
0x449cc794     12728  package body SYS.KUPW$WORKER
0x449cc794      2425  package body SYS.KUPW$WORKER
0x449cc794      8846  package body SYS.KUPW$WORKER
0x449cc794      1651  package body SYS.KUPW$WORKER
0x4484f3b4         2  anonymous block

Job "SYSTEM"."SYS_EXPORT_TABLE_08" stopped due to fatal error at 08:31:32

ziyoo0830

后发现adg处于 READ ONLY WITH APPLY 不可以，但是处于READ ONLY 状态是可以，下面是输出：

SYS@dgtest1>shutdown


ORA-01013: user requested cancel of current operation

SYS@dgtest1>SYS@dgtest1>SYS@dgtest1>
SYS@dgtest1>
SYS@dgtest1>select select db_unique_name,open_mode from v$database;
select select db_unique_name,open_mode from v$database
       *
ERROR at line 1:
ORA-00936: missing expression


SYS@dgtest1>select db_unique_name,open_mode from v$database;

DB_UNIQUE_NAME                 OPEN_MODE
------------------------------ --------------------
dgtest1                        READ ONLY



*oracle-oradg-/u02/backups/expdp>expdp system/password@oradg directory=expdp_oradg network_link=exp_dgtest1 tables=scott.t dumpfile=scott_t.dump logfile=full_standby.log

Export: Release 11.2.0.1.0 - Production on Fri Mar 28 08:26:17 2014

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

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SYSTEM"."SYS_EXPORT_TABLE_08":  system/********@oradg directory=expdp_oradg network_link=exp_dgtest1 tables=scott.t dumpfile=scott_t.dump logfile=full_standby.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 7 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "SCOTT"."T"                                 5.451 MB   55638 rows
Master table "SYSTEM"."SYS_EXPORT_TABLE_08" successfully loaded/unloaded
******************************************************************************
Dump file set for SYSTEM.SYS_EXPORT_TABLE_08 is:
  /u02/backups/expdp/scott_t.dump
Job "SYSTEM"."SYS_EXPORT_TABLE_08" successfully completed at 08:27:09

dba

参考一下：https://community.oracle.com/thread/2349202?tstart=0

xifenfei

read only 状态，和dg 已经本身无关了，这就不能算是dg 和expdp的关系


最多就是read only 库使用expdp的技巧


谢谢分享