日志挖掘

1.找到当前redo日志文件

select * from v$log

Group1为活动

2.找到日志文件路径：

Select * from v$logfile；

/home/oracle/oracle/product/10.2.0/oradata/orcl/redo01.log

3.找到当前scn号

select dbms_flashback.get_system_change_number from dual；

4.插入9条记录到表testT

Insert into testT select rownum from dual connect by rownum < 10;

5.重新获取scn号

6.运行logminer包

exec dbms_logmnr.add_logfile('/home/oracle/oracle/product/10.2.0/oradata/orcl/redo01.log',dbms_logmnr.new);

7.抓取scn间日志

exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog ,startScn =>2091153,endScn =>2091256 )

8.查看日志

select operation , sql_redo, sql_undo from v$logmnr_contents;

ITPub博客

logminer日志挖掘