11 Oracle19c打开logminner

本文目标

打开Oracle的logminner日志

参考文章
https://support.huaweicloud.com/usermanual-roma/fdi-ug-190624017.html
https://debezium.io/documentation/reference/2.0/connectors/oracle.html#oracle-example-configuration

创建LogMiner用户角色并配置权限

create role c##yinyx_logminer_privs container=all;
grant create session,execute_catalog_role, select any transaction,flashback any table,select any table,lock any table,logmining,set container, select any dictionary to c##yinyx_logminer_privs container=all;
grant select on SYSTEM.LOGMNR_COL$ to c##yinyx_logminer_privs container=all;
grant select on SYSTEM.LOGMNR_OBJ$ to c##yinyx_logminer_privs container=all;
grant select on SYSTEM.LOGMNR_USER$ to c##yinyx_logminer_privs container=all;
grant select on SYSTEM.LOGMNR_UID$ to c##yinyx_logminer_privs container=all;
grant select on V_$DATABASE to c##yinyx_logminer_privs container=all;
grant select_catalog_role to c##yinyx_logminer_privs container=all;

GRANT CREATE SESSION TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SET CONTAINER TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$DATABASE to c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT FLASHBACK ANY TABLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ANY TABLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT_CATALOG_ROLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT EXECUTE_CATALOG_ROLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ANY TRANSACTION TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT LOGMINING TO c##yinyx_logminer_privs CONTAINER=ALL; 

GRANT CREATE TABLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT LOCK ANY TABLE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT CREATE SEQUENCE TO c##yinyx_logminer_privs CONTAINER=ALL; 

GRANT EXECUTE ON DBMS_LOGMNR TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT EXECUTE ON DBMS_LOGMNR_D TO c##yinyx_logminer_privs CONTAINER=ALL; 

GRANT SELECT ON V_$LOG TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$LOG_HISTORY TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$LOGMNR_LOGS TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$LOGMNR_CONTENTS TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$LOGMNR_PARAMETERS TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$LOGFILE TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$ARCHIVED_LOG TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$ARCHIVE_DEST_STATUS TO c##yinyx_logminer_privs CONTAINER=ALL; 
GRANT SELECT ON V_$TRANSACTION TO c##yinyx_logminer_privs CONTAINER=ALL; 

创建LogMiner执行用户

create user c##yinyx_logminer identified by password default tablespace users container=all;
grant c##yinyx_logminer_privs to c##yinyx_logminer container=all;
alter user c##yinyx_logminer quota unlimited on users container=all;