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.Ð޸ijõʼ»¯²ÎÊý£º
²Î¿¼¹Ù·½ÎĵµÈ·¶¨ÐèÒªÀ´¼ì²éºÍÉ趨²ÎÊý
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