node1
suse 10
oracle_sid:stream
global_name:stm01
node2
suse 10
oracle_sid:stream
global_name:stm02
步骤:
环境准备:
alter system set global_names = true scope=both;
alter system set nls_date_format = 'YYYY-MM-DD HH24:MI:SS' scope=spfile;
alter system set streams_pool_size = 25m scope=spfile;
alter system set utl_file_dir = '*' scope=spfile;
启动归档
alter database archivelog
alter system set log_archive_dest_1='location=/orasvr/arch/' scope=both;
archive log start
alter database open;
archive log list;
创建stream用户
node1
create tablespace tbs_stream datafile
'/orasvr/stream/tbs_stream01.dbf' size 50m autoextend on maxsize unlimited segment space management auto;
execute dbms_logmnr_d.set_tablespace('tbs_stream');
create user stmadmin identified by stmadmin default tablespace tbs_stream temporary tablespace temp;
grant connect,resource,dba,aq_administrator_role to stmadmin;
begin dbms_streams_auth.grant_admin_privilege( grantee => 'stmadmin' , grant_privileges => true);
end;
/
node2
create tablespace tbs_stream datafile
'/orasvr/stream/tbs_stream01.dbf' size 50m autoextend on maxsize unlimited segment space management auto;
execute dbms_logmnr_d.set_tablespace('tbs_stream');
create user stmadmin identified by stmadmin default tablespace tbs_stream temporary tablespace temp;
grant connect,resource,dba,aq_administrator_role to stmadmin;
begin dbms_streams_auth.grant_admin_privilege( grantee => 'stmadmin' , grant_privileges => true);
end;
/
配置网络连接
配置node1的tnsnames
stm02 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.211.2)(PORT = 1521)) ) (CONNECT_DATA = (SID = stream) (SERVER =DEDICATED) ) )
配置node1的tnsnames
stm01 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL =TCP)(HOST = 192.168.211.1)(PORT = 1521)) ) (CONNECT_DATA = (SID = stream) (SERVER =DEDICATED) ) )
启用数据库附加日志功能
alter database add supplemental log data;
或者
alter table add supplement log group log_group_name(table_column_name) always;
修改数据库global_name