OracleLogMiner使用

1. 添加要分析的日志文件 EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -LOGFILENAME = '/home/duanbb/oracle/oradata/mydb/redo01.log', -OPTIOnS= DBMS_LOGMNR.NEW);EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -LOGFILENAME = '/home/duanbb/oracle/oradata/mydb/redo02.log

1. 添加要分析的日志文件

EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => '/home/duanbb/oracle/oradata/mydb/redo01.log', - OPTIOnS=> DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => '/home/duanbb/oracle/oradata/mydb/redo02.log', - OPTIOnS=> DBMS_LOGMNR.ADDFILE); EXECUTE DBMS_LOGMNR.ADD_LOGFILE( - LOGFILENAME => '/home/duanbb/oracle/oradata/mydb/redo03.log', - OPTIOnS=> DBMS_LOGMNR.ADDFILE);

2. 启动日志分析

EXECUTE DBMS_LOGMNR.START_LOGMNR( - OPTIOnS=> DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

3. 查询：eg. 查询表 "MYDB1.TEST_USER"的操作记录

select sql_redo from v$logmnr_contents where seg_owner = 'MYDB1' and table_name = 'TEST_USER';