Oracle Stream 配置

Oracle  Stream 配置
环境：
OS:Redhat Linux
Oracle 10.2.0.4
source:TEST
destnation:STANDBY
==准备==
1.归档日志配置：
SQL> archive log list;
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/archivelog
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /home/oracle/archivelog
---以下没有专门说明的都是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 TEST.com;
stream2:
SQL> alter system set global_names=true scope=both;
SQL> alter database rename global_name to STANDBY.com;
4.修改初始化参数：
参考官方文档确定需要来检查和设定参数
5.创建stream管理用户并表空间，配置权限，source和dest：
5.1 为strmadmin用户创建独立表空间
TEST:
SQL> CREATE TABLESPACE streams_tbs DATAFILE '/oradata/TEST/streams_tbs.dbf'
SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Tablespace created.
STANDBY:
SQL> CREATE TABLESPACE streams_tbs DATAFILE '/oradata/STANDBY/streams_tbs.dbf'
SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
Tablespace created.
5.2 source和dest创建相同用户和权限：
SQL> CREATE USER strmadmin IDENTIFIED BY strmadminpw
     DEFAULT TABLESPACE streams_tbs
     QUOTA UNLIMITED ON streams_tbs;
User created.
SQL> GRANT DBA TO strmadmin;
Grant succeeded.
SQL> BEGIN
2&nb