Oracle91数据库同步配置文档.docVIP

Oracle91数据库同步配置文档 Oracle 9i Streams设置简明步骤 源数据库SID：source 目标数据库SID：target 一.设置如下初始化参数： AQ_TM_PROCESSES = 1－10 GLOBAL_NAMES = true JOB_QUEUE_PROCESSES =2 COMPATIBLE = 9.2.0 or higher LOG_PARALLELISM = 1 设置命令----conn ........ as sysdba alter 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 log_parallelism=1 scope=spfile; 源数据库必须工作在自动归档模式： 设置参数 *.log_archive_start=true *.log_archive_dest_1=LOCATION=/tpdata/admin/source/arc 设置命令----conn ........ as sysdba 说明:F:\oracle\yang\arch为归档日志目录 alter system set log_archive_dest_1=location=F:\oracle\oradata\doma\arch scope=spfile;　　 alter system set log_archive_start=TRUE scope=spfile;　　　　 shutdown immediate;　　 startup mount;　　 alter database archivelog;　------开启归档模式　 alter database open; 在source上建strmadmin用户： 说明：F:\oracle\yang\oradata\source为空间数据目录 create tablespace DATA datafile F:\oracle\yang\oradata\source\DATA.dbf size 512m; 创建用户： create user strmadmin identified by strmadmin default tablespace DATA; 授权： grant connect,resource,select_catalog_role to strmadmin; grant execute on dbms_aqadm to strmadmin; grant execute on dbms_capture_adm to strmadmin; grant execute on dbms_propagation_adm to strmadmin; grant execute on dbms_streams_adm to strmadmin; BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_SET_OBJ, grantee = strmadmin, grant_option = FALSE); END; / BEGIN DBMS_RULE_ADM.GRANT_SYSTEM_PRIVILEGE( privilege = DBMS_RULE_ADM.CREATE_RULE_OBJ, grantee = strmadmin, grant_option = FALSE); END; / 四.在source上建streams queue(流队列) connect strmadmin/strmadin SQL exec dbms_streams_adm.set_up_queue(); 建source到target的dblink 注意：要与ora里面的别名配置相同，link别名要与global_name名字相同，global_name名字要与数据库名字相同 create database link target connect to strmadmin identified by strmadmin using target 创建用户：----conn ........ as sysdba create user hstest identified by hstest default tablespace DATA; 授权： grant dba to hstest; 创建表：