支持软件版本

1 目标库配置

1.1 创建用户及赋权

    create user "zcbus" identified by "***" ;
    grant public to zcbus;
    grant resource to zcbus;
    grant select any table to zcbus;
    grant select any dictionary to zcbus;
    GRANT FLASHBACK ANY TABLE TO ZCBUS;
    GRANT DROP ANY TABLE TO ZCBUS;
    GRANT CREATE ANY TABLE TO ZCBUS;
    GRANT ALTER ANY TABLE TO ZCBUS;
    GRANT CREATE ANY INDEX TO ZCBUS;
    GRANT ALTER ANY INDEX TO ZCBUS;
    GRANT DROP ANY INDEX TO ZCBUS;
    GRANT ALTER SESSION TO ZCBUS;
    GRANT COMMENT ANY TABLE TO ZCBUS;
    GRANT INSERT ANY TABLE TO ZCBUS;
    GRANT UPDATE ANY TABLE TO ZCBUS;
    GRANT DELETE ANY TABLE TO ZCBUS;
    GRANT LOCK ANY TABLE TO ZCBUS;

或者

    create user "zcbus" identified by "***" ;
    grant dba to zcbus;   ---超级用户权限

2 补充说明

2.1 配置目标数据库参数列表

变量 描述 是否隐藏
db_type DAMENG 数据库类型
host 127.0.0.1 数据库主机IP
port 5236 数据库端口
user zcbus 数据库链接用户
password 1qaz!QAZ 数据库链接用户密码
db_name PROD 数据库名
password_encrypt 0 设置为加密(1)时,password和source_password参数使用密文保存,默认为不加密(0)
slave_ip_list 如果目标库有多个节点时,可以填其余的节点的ip列表,用逗号隔开,注意这里不要填主节点的ip了,如:192.168.1.2,192.168.1.3或者192.168.1.2:1521/db2,192.168.1.3:1521/db3
always_connect_master 0 设置slave_ip_list指定多个节点后生效,取值:0- 可以任意连接节点,默认值- 必须连接主节点此参数适用mysql/pg/达梦
label 标签
文档更新时间: 2024-06-19 16:43   作者:阿力