--开启归档模式
SQL> SHUTDOWN IMMEDIATE
SQL> STARTUP MOUNT
SQL> ARCHIVE LOG LIST
SQL> ALTER DATABASE ARCHIVELOG;
SQL> ARCHIVE LOG LIST
SQL> ALTER DATABASE OPEN;
--校验归档模式
SQL> ARCHIVE LOG LIST
===================================================
-- Enable supplemental logging for database 配置库
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
-- Enable supplemental logging for database 配置表
ALTER TABLE DB.tableName ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS
===================================================
sqlplus sys/password@host:port/SID AS SYSDBA;
create USER flinkuser IDENTIFIED BY flinkuserPW DEFAULT TABLESPACE USERS QUOTA UNLIMITED ON USERS;
GRANT CREATE SESSION TO flinkuser;
GRANT SET CONTAINER TO flinkuser;
GRANT SELECT ON V_$DATABASE to flinkuser;
GRANT FLASHBACK ANY TABLE TO flinkuser;
GRANT SELECT ANY TABLE TO flinkuser;
GRANT SELECT_CATALOG_ROLE TO flinkuser;
GRANT EXECUTE_CATALOG_ROLE TO flinkuser;
GRANT SELECT ANY TRANSACTION TO flinkuser;
GRANT LOGMINING TO flinkuser;
GRANT CREATE TABLE TO flinkuser;
GRANT LOCK ANY TABLE TO flinkuser;
GRANT ALTER ANY TABLE TO flinkuser;
GRANT CREATE SEQUENCE TO flinkuser;
GRANT EXECUTE ON DBMS_LOGMNR TO flinkuser;
GRANT EXECUTE ON DBMS_LOGMNR_D TO flinkuser;
GRANT SELECT ON V_LOG_HISTORY TO flinkuser;
GRANT SELECT ON V_LOGMNR_CONTENTS TO flinkuser;
GRANT SELECT ON V_LOGFILE TO flinkuser;
GRANT SELECT ON V_ARCHIVE_DEST_STATUS TO flinkuser;
exit;
======================================================
测试时候使用！ 授权 可以修改数据 校验修改数据是否同步 生产不用操作
4、使用以下GRANT语句授予flinkuser 用户权限：
SQL> GRANT CONNECT, RESOURCE, DBA TO flinkuser
