Oracle_10g配置单向stream流复制.docVIP

Oracle 10g配置单向stream流复制 标签： Oracle? 流复制? 到了Oracle 10g,有了DBMS_STREAMS_ADM之后，Stream流复制已经很好配置了下面的只是一个最简单的stream流复制，不涉及复杂的rule配置环境：OS:Redhat LinuxOracle source:stream1destnation:stream2 ==准备==1.归档日志配置：SQL archive log list;Database log mode????????????? Archive ModeAutomatic archival???????????? EnabledArchive destination??????????? /u01/oradata/stream1_arch Database 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. (为无主键或唯一键的表实现无条件追加日志，如: alter table sms.mo_flow_2009_05 add supplemental log group log_group_mo_flow_2009_05(innerid) always; ) 确认源库的追加日志模式: ??? 数据库级别:??? SELECT supplemental_log_data_pk, supplemental_log_data_ui FROM V$DATABASE; ??? 检查追加日志组:??? Select log_group_name, table_name, decode(always, ALWAYS, Unconditional,NULL, Conditional) ALWAYS from DBA_LOG_GROUPS??? 检查追加日志组的列:??? Select log_group_name, column_name, position from dba_log_group_columns where table_name = DEPARTMENTS and owner=HR; 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 ; 4.修改初始化参数：参考官方文档确定需要来检查和设定参数 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 succee