XSTREAM

数据库准备

创建用户

容器模式

创建数据库用户

create tablespace zctbs datafile '数据文件路径/zctbs.dbf' size 100m reuse autoextend on maxsize unlimited;
create user zcbus_user identified by zcbus_passwd default tablespace zctbs quota unlimited on zctbs;

权限

grant create session to zcbus_user;
grant resource to zcbus_user;
grant select any table to zcbus_user;
grant select any dictionary to zcbus_user;
grant select on sys.user$ to zcbus_user;
grant select on sys.col$ to zcbus_user;
grant select on sys.obj$ to zcbus_user;
grant select_catalog_role to zcbus_user;
注：12C的CDB模式zcbus_user要以c##开头

非容器模式

需要创建CDB用户/PDB用户两种

CDB用于分析日志

创建cdb用户(web配置页面中集群管理的db_type,db_name,host,user,password等信息添加cdb信息)
sqlplus sys/password@host:port/SID as sysdba
create user C##zcbus_user identified by zcbus_user;
alter user c##zcbus_user quota 100m users;
grant create seesion to c##zcbus_user CONTAINER=ALL;
grant resource to c##zcbus_user CONTAINER=ALL;
grant select any table to c##zcbus_user CONTAINER=ALL;
grant select any dictionary to c##zcbus_user CONTAINER=ALL;
grant select on sys.user$ to c##zcbus_user CONTAINER=ALL;
grant select on sys.col$ to c##zcbus_user CONTAINER=ALL;
grant select on sys.obj$ to c##zcbus_user CONTAINER=ALL;
grant select_catalog_role to c##zcbus_user CONTAINER=ALL;

PDB用户PDB中数据导出

--创建pdb用户(web配置页面中集群管理的source_db_name,source_host,source_user,source_passwd填写pdb信息)
Alter session set container=pdb01;
create user zcbus_user identified by zcbus_passwd default tablespace zctbs quota unlimited on zctbs;
grant create session to zcbus_user;
grant resource to zcbus_user;
grant select any table to zcbus_user;
grant select any dictionary to zcbus_user;
grant select on sys.user$ to zcbus_user;
grant select on sys.col$ to zcbus_user;
grant select on sys.obj$ to zcbus_user;
grant select_catalog_role to zcbus_user;
grant flashback any table to zcbus_user;
grant lock any table to zcbus_user;
grant select_catalog_role to zcbus_user;

发布服务配置

1. 数据库配置

sqlplus / as sysdba
alter system set enable_goldengate_replication=true;
alter system set open_cursors = 3000;
begin
   dbms_xstream_auth.grant_admin_privilege(
      grantee                 => 'zcbus_user',
      privilege_type          => 'capture',
      grant_select_privileges => true);
end;
/

#enable_gg_xstream_for_streams
begin 
        dbms_xstream_adm.enable_gg_xstream_for_streams(true);
end;

12C及以上 CDB模式配置：

begin
   dbms_xstream_auth.grant_admin_privilege(
      grantee                 => 'c##zcbus_user',
      privilege_type          => 'capture',
      grant_select_privileges => true,
      container               => 'all');
end;
/

b）开启补充加日志

sqlplus / as sysdba
alter table 数据库名.表名 add supplemental log data(all) columns; 表级别
alter database add supplemental log data; 库级别最小日志

###根据实际情况选择添加附加日志级别
alter database add supplemental log data(all) columns; 库级别

c）使用创建用户连接进行数据参数配置
sqlplus zcbus_user/zcbus_passwd
注：12C的CDB模式zcbus_user要以c##开头【CDB用户】
d）创建xout服务【创建服务的时候，需要所有的PDB处于OPEN状态才可以（可以视情况临时开启所有关闭的PDB）】

declare
    tables  dbms_utility.uncl_array;
    schemas dbms_utility.uncl_array;
  begin
tables(1) :='zcbus_user.tab1'; 
    schemas(1) := null;
    dbms_xstream_adm.create_outbound(
    server_name     =>  'xout',
    table_names     =>  tables,
    schema_names    =>  schemas);
end;
/

调整优化参数

declare
  cursor c_cap is select capture_name from dba_capture;
 begin
  for c in c_cap loop
    dbms_capture_adm.set_parameter(capture_name=>c.capture_name,
parameter=>'inline_lob_optimization',value=>'Y');
dbms_capture_adm.alter_capture(capture_name=>c.capture_name,
checkpoint_retention_time=>1/24);
  end loop;
 end;
 /

• 至少添加一个表，用户名，表名可以不存在【保证服务正常】

ZCBUS准备

1. 添加发布节点

• 资源管理-发布节点
    添加发布节点,选择运行容器位置
    配置发布数据库配置信息【ORACLE】即可