1 修改配置

1.1 开启附加日志

alter database force logging;
alter database add supplemental log data;
alter database add supplemental log data (all) columns;

1.2 ADG 环境

数据库连接用户使用 sys 用户即可，如果使用普通用户 zcbus，则在 adg 源端按非 ADG 环境执
行以下语句

1.3 非 ADG 环境

1.视图权限

create or replace view XKCCLE as select * from sys.x$kccle;
create or replace view XKCCCP as select * from sys.x$kcccp;
create or replace view FZS_XKSPPI as select * from X$KSPPI;
create or replace view FZS_XKSPPSV as select * from X$KSPPSV;
create or replace view FZS_ASM_DISKGROUP as select * from sys.v$asm_diskgroup;
create or replace view FZS_ASM_ALIAS as select * from sys.v$asm_alias;
create or replace view FZS_XKFFIL as select * from sys.x$kffil;

1.4 创建 zcbus 用户以及对应授权

create user zcbus identified by zcbus;
create role zcbus_role identified by zcbus_role;
grant connect, select any table,select any dictionary to zcbus_role;
grant zcbus_role to zcbus;
alter user zcbus quota 200m on users;
drop table zcbus.fzstemp purge;
create table zcbus.fzstemp (f1 int);
grant create session to zcbus;
grant select on sys.ts$ to zcbus;
grant select on sys.tabsubpart$ to zcbus;
grant select on sys.obj$ to zcbus;
grant select on sys.seg$ to zcbus;
grant select on sys.coltype$ to zcbus;
grant select on sys.xkccle to zcbus;
grant select on sys.xkcccp to zcbus;
grant select on sys.seq$ to zcbus;
grant select on sys.user$ to zcbus;
grant select on sys.col$ to zcbus;
grant select on sys.ind$ to zcbus;
grant select on sys.tab$ to zcbus;
grant select on sys.lob$ to zcbus;
grant select on sys.indpart$ to zcbus;
grant select on sys.lobfrag$ to zcbus;
grant select on sys.user$ to zcbus;
grant select on sys.source$ to zcbus;
grant select on sys.view$ to zcbus;
grant select on sys.ts$ to zcbus;
grant select on sys.profname$ to zcbus;
grant select on sys.profile$ to zcbus;
grant select on sys.sysauth$ to zcbus;
grant select on sys.props$ to zcbus;
grant select on sys.idl_ub1$ to zcbus;
grant select on sys.user$ to zcbus;
grant select on sys.ntab$ to zcbus;
grant select on sys.sum$ to zcbus;
grant select on sys.com$ to zcbus;
grant select on sys.partlob$ to zcbus;
grant select on sys.attrcol$ to zcbus;
grant select on sys.ccol$ to zcbus;
grant select on sys.subpartcol$ to zcbus;
grant select on sys.tabpart$ to zcbus;
grant select on sys.indpart$ to zcbus;
grant select on sys.indcompart$ to zcbus;
grant select on sys.defrole$ to zcbus;
grant select on sys.v_$instance to zcbus;
grant select on SYS.v_$database to zcbus;
grant select on sys.v_$datafile to zcbus;
grant select on sys.V_$SESSION to zcbus;
grant select on sys.v_$log to zcbus;
grant select on sys.v_$logfile to zcbus;
grant select on sys.gv_$logfile to zcbus;

2 客户端安装及配置

2.1 客户端安装

2.2 客户端配置

2.3 注册

2.4 服务启动