高级复制下怎么强制删除废弃复制组

作者:eygle | English
Version
【转载时请务必以超链接形式表明文章本来出处及作者信息与本声明】
链接:http://www.eygle.com/archives/2006/09/delete_repcat_repcat.html

当高级复制环境中,有时候某些复制组已经废弃。
核心站点还是重点定义站点已经不在,db link为已休有或者受重建。

以这种情况下,删除复制组将改为一个不便。
我们的品味大轻为以下错误了。

$ sqlplus repadmin/repadmin

 

SQL*Plus: Release 10.1.0.2.0 – Production on Tue Sep 19 16:54:10 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> select gname, status from dba_repgroup;

GNAME STATUS


REP_TT QUIESCED

SQL> EXEC dbms_repcat.drop_master_repgroup(gname =>
‘REP_TT’,
2 drop_contents => false,all_sites => false);
BEGIN dbms_repcat.drop_master_repgroup(gname => ‘REP_TT’,
drop_contents => false,all_sites => false); END;

*
ERROR at line 1:
ORA-23313: object group “PUBLIC”.”REP_TT” is not mastered at
EYGLE.HURRAY.COM.CN
ORA-06512: at “SYS.DBMS_SYS_ERROR”, line 105
ORA-06512: at “SYS.DBMS_REPCAT_UTL4”, line 2860
ORA-06512: at “SYS.DBMS_REPCAT_MAS”, line 2660
ORA-06512: at “SYS.DBMS_REPCAT”, line 635
ORA-06512: at line 1

 

咱们得查阅转dba_repgroup依赖之最底层基本对象:

SQL> set autotrace on explain
SQL> select gname,status,owner from dba_repgroup;

 

GNAME STATUS OWNER



REP_TT QUIESCED PUBLIC

Execution Plan

0 SELECT STATEMENT Optimizer=ALL_ROWS (Cost=2 Card=2 Bytes=82)
1 0 NESTED LOOPS (OUTER) (Cost=2 Card=2 Bytes=82)
2 1 TABLE ACCESS (FULL) OF ‘REPCAT$_REPCAT’ (TABLE) (Cost=2
Card=2 Bytes=44)

3 1 INDEX (UNIQUE SCAN) OF ‘REPCAT$_FLAVORS_UNQ1’ (INDEX (UN
IQUE)) (Cost=0 Card=1 Bytes=19)

 

设若对系统状况足够了解和确认,我们得一直打底部表’REPCAT$_REPCAT’
中删除这个复制组的音讯:

SQL> delete from system.REPCAT$_REPCAT;

1 row deleted.

SQL> commit;

Commit complete.

SQL> select gname,status,owner from dba_repgroup;

no rows selected

 

每当进行这些操作前,请做好备份,并做好确认。

斯故事告诉我们的是,做工作必然要是按科学的步子,即使失败了,也该以正规的步骤退回原点,否则留下的各项不净操作可能吗数据库留下种种隐患。

-The End-

 

这篇
【高等复制下怎么强制删除废弃复制组】来自
http://www.eygle.com/ |
CSDN技术网摘.text:”):(d.getSelection?d.getSelection():”);void(saveit=window.open(‘http://wz.csdn.net/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=590,height=300,left=75,top=20,status=no,resizable=yes'));saveit.focus();)|[del.icio.us](http://del.icio.us/post?url=http://www.eygle.com/archives/2006/09/delete_repcat_repcat.html&title=%E9%AB%98%E7%BA%A7%E5%A4%8D%E5%88%B6%E4%B8%8B%E5%A6%82%E4%BD%95%E5%BC%BA%E5%88%B6%E5%88%A0%E9%99%A4%E5%BA%9F%E5%BC%83%E5%A4%8D%E5%88%B6%E7%BB%84)|[365Key](http://www.cnblogs.com/Godblessyou/admin/javascript:d=document;t=d.selection?(d.selection.type!='None'?d.selection.createRange().text:''):(d.getSelection?d.getSelection():'');void(keyit=window.open('http://www.365key.com/storeit.aspx?t='+escape(d.title)+'&u='+escape(d.location.href)+'&c='+escape(t),'keyit','scrollbars=no,width=475,height=575,left=75,top=20,status=no,resizable=yes'));keyit.focus();)

 

相关文章