1
alter system set utl_file_dir='D:\archivelog' scope=spfile;
2
重启数据库
3
BEGIN
dbms_logmnr_d.build(dictionary_filename=>'dict.ora',dictionary_location=>'D:\archivelog');
END;
4 增加要分析的文件
BEGIN
dbms_logmnr.add_logfile(
options=>dbms_logmnr.new,
logfilename=>'c:\oracle\phj\archive\test1.arc');
END;
BEGIN
sys.dbms_logmnr.add_logfile(
ptions => sys.dbms_logmnr.new,
logfilename => 'C:\1_427_694605987.dbf'
);
END;
/
BEGIN
sys.dbms_logmnr.add_logfile(
ptions => sys.dbms_logmnr.addfile,
logfilename => 'C:\1_427_694605987.dbf'
);
END;
/
5 分析
BEGIN
sys.dbms_logmnr.start_logmnr(dictfilename => 'C:\aa\logminer_dict.dat');
END;
Create table tab_logmnr
SELECT *
FROM V$logmnr_contents;
6 结束挖掘
BEGIN
dbms_logmnr.end_logmnr;
end;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15747463/viewspace-736807/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15747463/viewspace-736807/