高级复制实施手记(3)

3.创建物化视图站点:假定物化视图站点位于mv(网络服务名),作为simis的物化视图站点

本文可以任意转载，转载时请务必以超链接形式标明文章原始出处和作者信息及本声明.

http://husthxd.itpub.net/post/11/111305

1) 配置连接simis的tns service name 'simis'.
2) 创建物化视图站点用户
connect system/manager@mv
创建物化视图管理员

drop user MVIEWADMIN cascade;
create user MVIEWADMIN identified by MVIEWADMIN;
BEGIN
DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (
username => 'mviewadmin');
END;
/
GRANT COMMENT ANY TABLE TO mviewadmin;
GRANT LOCK ANY TABLE TO mviewadmin;
GRANT SELECT ANY DICTIONARY TO mviewadmin;
创建propagator
drop user propagator cascade;
CREATE USER propagator IDENTIFIED BY propagator;
BEGIN
DBMS_DEFER_SYS.REGISTER_PROPAGATOR (
username => 'propagator');
END;
/
创建刷新者refresher
drop user refresher cascade;
create user REFRESHER identified by REFRESHER;
给用户refresher授权
GRANT CREATE SESSION TO refresher;
GRANT ALTER ANY MATERIALIZED VIEW TO refresher;
注册receiver
BEGIN
DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (
username => 'mviewadmin',
privilege_type => 'receiver',
list_of_gnames => NULL);
END;
/

3) 建立数据库链接
建公有数据库链接
connect system/manager@mv
create public database link simis.simis using 'simis';
建立私有数据库链接
connect mviewadmin/mviewadmin@mv
create database link simis.simis CONNECT TO proxy_mviewadmin IDENTIFIED BY proxy_mviewadmin;
CONNECT propagator/propagator@mv
CREATE DATABASE LINK simis.simis CONNECT TO repadmin IDENTIFIED BY repadmin;

4) 定义purge和push事务的时间间隔
CONNECT mviewadmin/mviewadmin@mv
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
next_date => SYSDATE,
interval => 'SYSDATE + 5/1440',
delay_seconds => 0,
rollback_segment => '');
END;
/
CONNECT mviewadmin/mviewadmin@mv
BEGIN
DBMS_DEFER_SYS.SCHEDULE_PUSH (
destination => 'simis.simis',
interval => 'SYSDATE + 1/1440',
next_date => SYSDATE,
stop_on_error => FALSE,
delay_seconds => 0,
parallelism => 0);
END;
/