oracle 复制组删除,高级复制下如何强制删除废弃复制组

高级复制下如何强制删除废弃复制组

在高级复制环境中，有时候某些复制组已经废弃。

主体站点或主体定义站点已经不存在，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-

By eygle on 2006-09-20 11:05 |

Comments (0) |

Advanced | 908 |