如果主体定义站点down机需要重建复制环境
在其他站点上以sys用户清除相应的视图信息即可.
conn / as sysdba
delete DBA_REPSITES;
delete DBA_REPGROUP;
delete DEFTRANDEST;
delete DEFERROR;
delete DEFSCHEDULE;
truncate table system.DEF$_AQCALL;
truncate table system.DEF$_CALLDEST;
truncate table system.DEF$_ERROR;
truncate table system.DEF$_AQERROR;
delete DEFCALL;
commit;
相关脚本:
-- clear replication dictionary objects (on both sites) using
$ORACLE_HOME/rdbms/admin/catrepr.sql
-- recreat the replication dictionary objects on both sites using
$ORACLE_HOME/rdbms/admin/catrep.sql
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/6906/viewspace-21596/，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
