Oracle Log Miner相關

create directory log_dir as 'd:\oraclelogs';


BEGIN
  dbms_logmnr_d.build('ora11g.ora', dictionary_location => 'LOG_DIR');
END;

begin
  dbms_logmnr.add_logfile('C:\ORACLE\FAST_RECOVERY_AREA\ORCL\ONLINELOG\O1_MF_3_97OZM5HJ_.LOG',dbms_logmnr.NEW);
end;

--利用線上資料字典 exec DBMS_LOGMNR.START_LOGMNR(OPTIONS => SYS.DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG); 
跳過build資料字典

begin
  dbms_logmnr.start_logmnr(DictFileName => 'd:/oraclelogs/ora11g.ora');
end;

DECLARE
  v_index PLS_INTEGER;
BEGIN
  v_index := 0;
  FOR rec IN (SELECT * FROM v$archived_log g WHERE g.name IS NOT NULL) LOOP
    IF v_index = 0 THEN
      dbms_logmnr.add_logfile(rec.name, dbms_logmnr.new);
    ELSE
      dbms_logmnr.add_logfile(rec.name, dbms_logmnr.addfile);
    END IF;
    v_index := v_index + 1;
  END LOOP;
END;


select * from v$logmnr_contents

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-777006/，如需轉載，請註明出處，否則將追究法律責任。