清理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’;