oracle（rac 非cdb） flink cdc配置

oracle rac开启日志归档 非CBD数据库

1、 开启归档

1.1、查看归档模式

archive log list;

未开启响应

Database log mode           No Archive Mode
Automatic archival           Disabled
Archive destination           USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     23
Current log sequence           24

1.2、设置归档目录

非共享模式

本地盘创建目录，两台机器分别执行，这个ha切换回导致实例切换不成功
mkdir -p /opt/oracle/oradata/recovery_area
chown -R oracle:oracle /opt/oracle
chmod -R 755 /opt/oracle
alter system set db_recovery_file_dest_size = 200G;
alter system set db_recovery_file_dest = '/opt/oracle/oradata/recovery_area' scope=spfile;

共享模式

alter system set db_recovery_file_dest_size=200G scope=both; 
#指定共享存储位置
alter system set db_recovery_file_dest='+DGRECOVERY' scope=both; 

1.3、重启数据库实例

备注： rac19cdb是数据库实例名称，rac19cdb1数据库节点名称，需自行调整，下同

su oracle
srvctl stop database -d rac19cdb
srvctl start instance -d rac19cdb -i rac19cdb1 -o mount

执行sql,开启归档

alter database archivelog;

启动另外一台数据库实例

srvctl start instance -d rac19cdb -i rac19cdb2 -o mount

2、数据库配置

开启数据库

alter database open;

开启扩充日志

alter database add supplemental log data (all) columns;

3、 检查 logMiner 是否安装

-- 检查LogMiner是否安装，若有信息返回，说明LogMiner已安装，不需要再安装logminer
desc DBMS_LOGMNR
desc DBMS_LOGMNR_D

3.1、 安装LogMiner

如果上述步骤检查有安装则不用执行

@$ORACLE_HOME/rdbms/admin/dbmslm.sql
@$ORACLE_HOME/rdbms/admin/dbmslmd.sql

4、创建cdc用户

#示例为共享存储
CREATE TABLESPACE logminer_tbs DATAFILE '+DATA/RACDB/DATAFILE/logminer_tbs.dbf' size 1024M REUSE AUTOEXTEND ON MAXSIZE UNLIMITED;
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 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;