ORA-3912,ORA-06502:从active data guard expdp导出数据报错
数据库版本:11.2.0.1.0os: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 lineobject
handle numbername
0x449cc794 19028package body SYS.KUPW$WORKER
0x449cc794 8191package body SYS.KUPW$WORKER
0x449cc794 12728package body SYS.KUPW$WORKER
0x449cc794 2425package body SYS.KUPW$WORKER
0x449cc794 8846package body SYS.KUPW$WORKER
0x449cc794 1651package body SYS.KUPW$WORKER
0x4484f3b4 2anonymous 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 lineobject
handle numbername
0x449cc794 19028package body SYS.KUPW$WORKER
0x449cc794 8191package body SYS.KUPW$WORKER
0x449cc794 12728package body SYS.KUPW$WORKER
0x449cc794 2425package body SYS.KUPW$WORKER
0x449cc794 8846package body SYS.KUPW$WORKER
0x449cc794 1651package body SYS.KUPW$WORKER
0x4484f3b4 2anonymous block
Job "SYSTEM"."SYS_EXPORT_TABLE_08" stopped due to fatal error at 08:31:32
后发现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
参考一下:https://community.oracle.com/thread/2349202?tstart=0 read only 状态,和dg 已经本身无关了,这就不能算是dg 和expdp的关系
最多就是read only 库使用expdp的技巧
谢谢分享
页:
[1]