清理Oracle Streams配置

清理Oracle Streams配置

 

备份capture的信息
select * from dba_capture;

检查stream

SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn)
from dba_capture
where capture_type=’LOCAL’;

使用管理员用户登陆后删除Streams配置:

 

exec dbms_apply_adm.stop_apply('sync_apply');                                   /*目标端数据库 */
exec dbms_capture_adm.drop_capture('sync_capture',true);                   /*源端数据库    */
exec dbms_apply_adm.drop_apply('sync_apply',true);                            /*目标端数据库 */


SQL>DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION;

 

再次检查stream

SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn)
from dba_capture
where capture_type=’LOCAL’;

 

查询stream进程应为空,表明已删除成功

SQL> select min(required_checkpoint_scn) ,min(source_resetlogs_scn)
from dba_capture
where capture_type=’LOCAL’;

 

 

Comments

  1. 备份capture和apply的信息select * from dba_capture;select * from dba_apply;停止CAPTURE和APPLY并移出exec dbms_capture_adm.stop_capture(‘CAPTURE_NAME’,true);exec dbms_capture_adm.drop_capture(‘CAPTURE_NAME’,true);exec dbms_apply_adm.stop_apply(‘APPLY_NAME’,true); exec dbms_apply_adm.drop_apply(‘APPLY_NAME’,true);exec DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION;

Comment

*

沪ICP备14014813号

沪公网安备 31010802001379号