配备oracle stream(step by step setup schema level Streams Replication)
配置oracle stream(step by step setup schema level Streams Replication)过程和database level基本一样，
配置oracle stream(step by step setup schema level Streams Replication)
过程和database level基本一样，本篇只简单介绍下过程
说明：
source 为hrdbprim，target db为hrdb，此处的数据库名称必须和global_name一致
hrdbprim =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.124.239)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hrdbprim)
)
)
hrdb =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.4.124.233)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = hrdb)
)
)
STRMADMIN = stream管理用户
WJ = 需要复制同步的用户
一、环境准备
1,删除原有的stream配置execute DBMS_STREAMS_ADM.REMOVE_STREAMS_CONFIGURATION();
2，配置数据库参数，一般需要设置global_names, _job_queue_interval, sga_target, streams_pool_size四个参数
3，创建管理用户STRMADMIN
