五.在两个数据库repadmin用户上建立数据库链接
create database link yiliao.master.com connect to REPADMIN identified by REPADMIN using 'myora'; create database link yiliao.saler.com connect to REPADMIN identified by REPADMIN using 'orcl'; |
六.在两个数据库的应用用户t下创建表
在数据库fsws_yiliao用户下创建表t:注意,要进行复制的表必须有主键
CREATE TABLE T(ID NUMBER(10),name varchar2(30)); ALTER TABLE t ADD(CONSTRAINT pk_t_id PRIMARY KEY(ID)); |
七.在主体定义站点开始操作(数据库A:myora)
以REPADMIN登录数据库
创建复制组:
execute dbms_repcat.create_master_repgroup('master_yiliao'); |
查询复制组:
select gname,master,status from dba_repgroup; |
在复制组里加入复制对象:
execute dbms_repcat.create_master_repobject (sname=>'fsws_yiliao',oname=>'t', type=>'TABLE', use_existing_object=>true,gname=>'master_yiliao',copy_rows=>true); |
查询复制组加入的复制对象:
select sname,oname,status,gname from dba_repobject; |
对复制对象产生复制支持:
execute dbms_repcat.generate_replication_support('fsws_yiliao','test','TABLE'); |
在执行下复制组加入的复制对象,这里与加入复制对象是有些区别
selectsname,oname,status,gname from dba_repobject; |
添加主体复制节点:
execute dbms_repcat.add_master_database(gname=>'master_yiliao',master=>'yiliao. saler.com',use_existing_objects=>true,copy_rows=>true, propagation_mode => 'synchronous'); |
查询主节点:
select gname,dblink,masterdef,master from dba_repsites; |
在主体定义站点启动复制:
execute dbms_repcat.resume_master_activity('master_yiliao',true); |
查询下复制主,认真观察下,与开始时的区别
selectgname,master,status from dba_repgroup |
查询job,看是否运行
select job,log_user,this_date,next_date,next_sec,broken,failures,what from user_jobs; |