real_timedownstream配置.docVIP

1. 在source和destination机（注以下操作需要在2个机器上进行） 1.1 创建stream用户的表空间 SQLcreate tablespace tbs_stream datafile C:\tbs_stream.dbf size 200M; 1.2 将logmnr的默认表空间转到刚刚建立的表空间 SQL execute dbms_logmnr_d.set_tablespace(tbs_stream); 1.3 创建stream user和授权 SQL CREATE USER strmadmin IDENTIFIED BY strmadmin DEFAULT TABLESPACE tbs_stream ; SQL grant dba to strmadmin; 1.4 赋予流管理特权 SQL BEGIN DBMS_STREAMS_AUTH.GRANT_ADMIN_PRIVILEGE( grantee = strmadmin, grant_privileges = true); END; / 1.5 check stream admin用户的情况： SQL SELECT * FROM dba_streams_administrator; 1.6 查一下arch目录是否设置正确，是否启动归档模式。 主库 SQLalter system set log_archive_dest_1=location=C:\oracle\product\10.2.0\flash_recovery_area\prod\archivelog; 备库 SQLalter system set log_archive_dest_1=location=C:\oracle\product\10.2.0\flash_recovery_area\h10g\archivelog; SQL shutdown immediate SQL startup mount; SQL alter database archivelog; SQL alter database open; SQL archive log list; 1.7 设置tnsname，能tnsping到对方的机器。 C:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\ tnsnames.ora 文件中添加对方主机信息： H10G = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.102)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = h10g) ) ) *********添加到PROD主机中********* ----------------------------------------------------- PROD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.2.101)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = prod) ) ) *********添加到H10G主机中********* 1.8 设置stream需要的初始化参数： SQLalter system set aq_tm_processes=2 scope=both; alter system set global_names=true scope=both; alter system set job_queue_processes=10 scope=both; alter system set parallel_max_servers=20 scope=both; alter system set undo_retention=3600 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