个人网站有哪些板块,新型营销方式,网站开发是打代码吗,建站平台系统使用Flink CDC实现 Oracle数据库数据同步的oracle配置操作#xff0c;包括开启日志归档和用户授权。
flink官方参考资料#xff1a; https://nightlies.apache.org/flink/flink-cdc-docs-master/zh/docs/connectors/flink-sources/oracle-cdc/ 操作步骤#xff1a;
1.启用…使用Flink CDC实现 Oracle数据库数据同步的oracle配置操作包括开启日志归档和用户授权。
flink官方参考资料 https://nightlies.apache.org/flink/flink-cdc-docs-master/zh/docs/connectors/flink-sources/oracle-cdc/ 操作步骤
1.启用归档日志
alter system set db_recovery_file_dest_size 10G;
alter system set db_recovery_file_dest /opt/oracle/oradata/recovery_area scopespfile;
shutdown immediate;
startup mount;
alter database archivelog;
alter database open; 2.查看是否已经启用归档模式
显示“Archive Mode”表示已启用
archive log list;
3.创建表空间
CREATE TABLESPACE logminer_tbs DATAFILE /opt/oracle/oradata/SID/logminer_tbs.dbf SIZE 25M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
4.创建用户并授权
CREATE USER flinkuser IDENTIFIED BY flinkpw DEFAULT TABLESPACE LOGMINER_TBS QUOTA UNLIMITED ON LOGMINER_TBS;
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 ANALYZE ANY 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 TO flinkuser;
GRANT SELECT ON V_$LOG_HISTORY TO flinkuser;
GRANT SELECT ON V_$LOGMNR_LOGS TO flinkuser;
GRANT SELECT ON V_$LOGMNR_CONTENTS TO flinkuser;
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO flinkuser;
GRANT SELECT ON V_$LOGFILE TO flinkuser;
GRANT SELECT ON V_$ARCHIVED_LOG TO flinkuser;
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO flinkuser;
