Oracle 10g 配置单向stream流复制.docxVIP

Oracle 10g 配置单向stream流复制，完整记录最简单的stream流复制，不涉及复杂的rule配置1.归档日志配置：SQL archive log list;Database log mode Archive ModeAutomatic archival EnabledArchive destination /u01/oradata/stream1_archDatabase log mode Archive ModeAutomatic archival EnabledArchive destination /u01/oradata/stream2_arch---以下没有专门说明的都是sys用户---2.在源stream1上配置Supplemental loging：SQL alter database add supplemental log data;Database altered.3.两台机器上修改global_name:stream1:SQL alter system set global_names=true scope=both;SQL alter database rename global_name to ;stream2:SQL alter system set global_names=true scope=both;SQL alter database rename global_name to ;5.创建stream管理用户并表空间，配置权限，source和dest：5.1 为strmadmin用户创建独立表空间stream1:SQL CREATE TABLESPACE streams_tbs DATAFILE /u01/oradata/stream1/streams_tbs.dbf?2 SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;Tablespace created.stream2:SQL CREATE TABLESPACE streams_tbs DATAFILE /u01/oradata/stream2/streams_tbs.dbf?2 SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;Tablespace created.5.2 source和dest创建相同用户和权限：SQL CREATE USER strmadmin IDENTIFIED BY strmadminpw2 DEFAULT TABLESPACE streams_tbs3 QUOTA UNLIMITED ON streams_tbs;User created.SQL GRANT DBA TO strmadmin;Grant succeeded.SQL BEGIN2 DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE(3 grantee = strmadmin,?4 grant_privileges = true);5 END;6 /PL/SQL procedure successfully completed.6.配置listener.ora和tnsnames.ora,闲话不多说，最后能保证：stream1上：sqlplus system/system@stream2stream2上：sqlplus system/system@stream1都没有问题就ok---如果没有说明以下都是strmadmin/strmadminpw用户---7.创建DB link:单向复制之需要一个database link即source 到dest:stream1--stream2stream1上：sqlplusstrmadmin/strmadminpw?SQL CREATE DATABASE LINK CONNECT TO strmadmin IDENTIFIED BY strmadminpw USING stream2;Database link created.测试：SQL select * from?global_name@;GLOBAL_NAME-----------------------------------------STREAM2.COM开始stream的配置=8. source和dest创建队列：stream1,stream2都要创建SQL EXEC DBMS_STREAMS_ADM.SET_UP_QUEUE();PL/SQL procedure successfully completed.上面命令会创建一个队列缺省名：streams_queue，队列表缺省是：STREAMS_QUEUE_TA