高级复制下如何强制删除复制组节能

在高级复制环境下，有时候由于一些故障，可能导致复制组删除时出现错误。

$ sqlplus repadmin/repadmin SQL*Plus: Release 10.1.0.2.0 - Production on Tue Sep 19 10:34:30 2006

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

Connected to:

Oracle Database 10g Enterprise Edition Release 10.1.0.保管好用。 如果你有着漂亮的腰线2.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL set linesize 120

SQL col sname for a10

SQL col gname for a10

SQL col schema_comment for a1

SQL col fname for a10

SQL col owner for a10

SQL select * from dba_repgroup;

SNAME M STATUS S GNAME FNAME R OWNER

---------- - --------- - ---------- ---------- - ----------

REP_TEST Y NORMAL REP_TEST N PUBLIC

SQL exec dbms_op_master_repgroup(gname='rep_test',all_sites = true);

BEGIN dbms_op_master_repgroup(gname='rep_test',all_sites = true); END;

*

ERROR at line 1:

ORA-23353: deferred RPC queue has entries for object group "PUBLIC"."REP_TEST"

ORA-06512: at "MS_SYS_ERROR", line 95

ORA-06512: at "MS_REPCAT_MAS", line 1190

ORA-06512: at "MS_REPCAT_MAS", line 2666

ORA-06512: at "MS_REPCAT", line 635

ORA-06512: at line 1

这表明此时，在deftran中还有记录，而可能在deftrandest中已经没有需要push的事务

SQL select count(*) from deftran; COUNT(*)

----------

3

SQL select count(*) from deftrandest;

COUNT(*)

----------

0

正常情况下可以通过dbms_defer_rge过程去清除队列。

在异常情况下，我们可以选择直接截断(truncate)，强制删除复制组:

SQL truncate table f$_aqcall; Table truncated.

SQL exec dbms_op_master_re把美食节的摊位吹得“东倒西歪”pgroup(gname='rep_test',all_sites = true);

PL/SQL procedure successfully completed.

此时可以进行其他操作，如恢复复制组等。

查看本文来源

昆明治白癜风的专科医院
德阳看牛皮癣去哪个医院
如何缓解小孩肠绞痛