oracle archivelog mining

1. 安装配置

1.数据库设置

在oracle数据库服务器上

sqlplus / as sysdba
shutdown immediate;
startup mount;
alter database archivelog;
alter database open;
alter database add supplemental redoLog data (all) columns;

2.添加数据库用户

登录数据库运行以下脚本

普通数据库模式下

create role mining_role;
grant  create session,logmining,execute_catalog_role,select any transaction ,select any dictionary to mining_role;
create user kminer identified by kminerpass;
grant  mining_role to kminer;
alter user kminer quota unlimited on users;

cdb模式下

create role c##mining_role;
grant  create session,logmining,execute_catalog_role,select any transaction ,select any dictionary to c##mining_role;
create user c##kminer identified by kminerpass;
grant  c##mining_role to c##kminer;
alter user c##kminer quota unlimited on users;

在oracle里安装logminer包

sqlplus sys@orclcdb as sysdba
@$ORACLE_HOME/rdbms/admin/dbmslm.sql; --用来分析日志文件
@$ORACLE_HOME/rdbms/admin/dbmslmd.sql; --用来创建数据字典文件

启动时可以手工指定起始同步的scn

java -jar logmining.jar