Oracle 10g高级复制.docVIP

信息： 1设置global_name为true。（global_name 由两部分组成。sid +db_domain.） SQL show parameter global_name NAME???????????????????????????????? TYPE??????? VALUE ------------------------------------ ----------- --------????????????????????? global_names???????????????????????? boolean???? TRUE??? alter system set global_name=true scope=spfile; ( alter database rename global_name to sid.domain_name. 更该完毕。 重起两台数据库。 参数修改完毕。 create user test identified by test default tablespace users; create table test(id number,name varchar2(20),constraint test_id_pk primary key(id));( SQLcreate user repadmin identified by repadmin default tablespace users temporary tablespace temp; SQLexecute dbms_defer_sys.register_propagator(repadmin); SQLgrant execute any procedure to repadmin; SQLexecute dbms_repcat_admin.grant_admin_any_repgroup(repadmin); SQLexecute dbms_repcat_admin.grant_admin_any_schema(username = repadmin); SQLgrant select any dictionary to repadmin; （两台数据库都要相同的配置） SQL execute dbms_repcat.create_master_repgroup(REP_MYTEST); SQL select gname,master,status from dba_repgroup where gname=REP_MYTEST; GNAME???????????????????????? MASTER??????????????????????? STATUS --------------------------- ----------------------------? ------------------------ REP_MYTEST????????????????? Y???????????????????????????? QUIESCED SQL execute dbms_repcat.create_master_repobject (sname=test,oname=test, type=TABLE,? use_existing_object=true,gname=REP_MYTEST,copy_rows=true); SQLselect sname,oname,status,gname from dba_repobject where gname=REP_MYTEST; SNAME????????????????????????? ONAME??????????????????????????? STATUS???? GNAME ----------------------------- ------------------------------ ------------- ------------------------------ SCOTT???????????????????????? DEPT?????????????????????????? VALID???????? REP_MYTEST SQL execute dbms_repcat.generate_replication_support(test,test,TABLE); SQL select gname,master,status from dba_repgroup where gname=REP_MYTEST; GNAME???????????????????????? MASTER??????????????