创建数据字典
EXECUTE dbms_logmnr_d.build(dictionary_filename=>'v816dict.ora',dictionary_location=>'/home/oracle/d_logs');
添加所有日志
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo01.log',dbms_logmnr.new);
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo02.log',dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo03.log',dbms_logmnr.addfile);
启动
EXECUTE dbms_logmnr.start_logmnr(DictFileName =>'/home/oracle/d_logs/v816dict.ora');
查询
Select to_char(timestamp,'YYYY-MM-DD HH24:MI:SS'),sql_redo
from V$LOGMNR_CONTENTS t
where upper(t.table_name)=upper('表1') 查询出来的结果只有当天的对“表1”的操作。为什么啊。
EXECUTE dbms_logmnr_d.build(dictionary_filename=>'v816dict.ora',dictionary_location=>'/home/oracle/d_logs');
添加所有日志
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo01.log',dbms_logmnr.new);
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo02.log',dbms_logmnr.addfile);
execute dbms_logmnr.add_logfile('/oradb/oradata/ora10g/redo03.log',dbms_logmnr.addfile);
启动
EXECUTE dbms_logmnr.start_logmnr(DictFileName =>'/home/oracle/d_logs/v816dict.ora');
查询
Select to_char(timestamp,'YYYY-MM-DD HH24:MI:SS'),sql_redo
from V$LOGMNR_CONTENTS t
where upper(t.table_name)=upper('表1') 查询出来的结果只有当天的对“表1”的操作。为什么啊。
starttime=>to_date('2008-10-20:10:05:00','YYYY-MM-DD:HH24:MI:SS'),
endtime=>to_date('2003-08-10:30:17:00','YYYY-MM-DD:HH24:MI:SS')
加starttime 和engtime 要注意分析的时间段范围合理。
endtime=>to_date('2008-10-30 10:00:00','YYYY-MM-DD HH24:MI:SS')