oracle 双向同步

schema_name => 'agc',
streams_type => 'apply',
streams_name => 'applys_src',
queue_name => 'strmadmin.apply_src',
include_dml => true,
include_ddl => true,
schema_name => 'agc',
streams_type => 'apply',
streams_name => 'applys_dest',
queue_name => 'strmadmin.apply_dest',
include_dml => true,
include_ddl => true,
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl206)
)
)
//修改登陆密码
orapwd file=?/dbs/orapwdave password=oracle（修改密码文件）
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
inclusion_rule => true);
end;
//apply
begin
dbms_streams_adm.add_schema_rules(
//process start/turn off (start,stop,drop)
exec dbms_apply_adm.start_apply('applys_dest');
exec dbms_capture_adm.start_capture('captures_dest');
6.5、create propagation process
begin
dbms_streams_adm.add_schema_rules(
schema_name => 'agc',
streams_type => 'capture',
streams_name => 'captures_src',
queue_name => 'strmadmin.capture_src',
include_tagged_lcr => false,
source_database => 'orcl200',
inclusion_rule => true);
end;
conn strmadmin/strmadmin@orcl206
begin
dbms_streams_adm.add_schema_propagation_rules(
创建表空间
create tablespace streams_space
datafile '+DATADG/cboms/datafile/streams_space.dbf'
size 5M autoextend on
创建用户：
create user strmadmin identified by strmadmin default tablespace streams_space;
end;
/
begin
dbms_streams_adm.set_up_queue(
queue_table => 'capture_srctab',
queue_name => 'capture_src',
queue_user=> 'strmadmin');
end;
/
6.2、create queue of capture,apply in dest
source_queue_name => 'strmadmin.capture_src',
destination_queue_name => 'strmadmin.apply_dest@orcl206',
include_dml => true,
include_ddl => true,
//check queue
select owner,queue_table,name from dba_queues where wner='STRMADMIN';
6.3、 create process of capture, apply in src
//capture
conn strmadmin/strmadmin@orcl200
show parameter aq_tm_processes;
// change
alter system set global_names=true scope=both;
alter system set aq_tm_processes=2 scope=both;
alter system set streams_pool_size=500M;
begin
dbms_streams_adm.add_schema_rules(
schema_name => 'agc',
streams_type => 'capture',
streams_name => 'captures_dest',
queue_name => 'strmadmin.capture_dest',
conn strmadmin/strmadmin@orcl200
begin
dbms_streams_adm.add_schema_propagation_rules(
schema_name => 'agc',
streams_name => 'orcl200_to_orcl206',
include_tagged_lcr => false,
source_database => 'orcl200',
inclusion_rule => true);
end;
//check process
select apply_name/capture_name ,status from dba_apply/dba_capture;
end;
/
begin
dbms_streams_adm.set_up_queue(
queue_table => 'capture_desttab',
queue_name => 'capture_dest',
queue_user=> 'strmadmin');
end;
/
//create database link orcl206 connect to strmadmin identified by strmadmin using 'orcl206';
6、STREAM 配置
6.1、create queue of capture,apply in src
include_dml => true,
include_ddl => true,
include_tagged_lcr => false,
source_database => 'orcl206',
inclusion_rule => true);
end;
//check propagation process
select propagation_name, status from dba_propagation;
// propagation start/turn off (start,stop,drop)
exec dbms_propagation_adm.start_propagation('orcl200_to_orcl206');
include_tagged_lcr => false,
source_database => 'orcl206',
inclusion_rule => true);
end;
6.4、create proccess of capture, apply in dest
//capture
conn strmadmin/strmadmin@orcl206
4、添加追加日志
alter database add supplemental log data;
5、创建DB-LINK
配置TNS.ORA，测试远程登陆
格式：：
ORCL206 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.206)(PORT = 1521))