1.在init.ora初始化参数文件中,指定数据字典文件的位置,也就是添加一个参数UTL_FILE_DIR,该参数值为服务器中放置数据字典文件的目录。如:UTL_FILE_DIR = ($ORACLE_HOME\logs) ,重新启动数据库,使新加的参数生效
show parameter utl;
alter system set utl_file_dir ='/hotbak/logmnr' scope =spfile sid='*';
shutdown immediate;
startup force;
2.创建数据字典:
execute dbms_logmnr_d.build(dictionary_filename => 'jydict.ora',dictionary_location => '/databak');
3.创建要分析的日志文件列表
1)添加分析日志
execute dbms_logmnr.add_logfile(LogFileName =>'/databak/fictarc/arch_1_113450.arc',Options => dbms_logmnr.new); (第一次用new,接下来用addfile)
execute dbms_logmnr.add_logfile(LogFileName => '/databak/fictarc/arch_1_113451.arc',Options => dbms_logmnr.ADDFILE);
。。。。。。
2)删除分析日志
exec dbms_logmnr.add_logfile('/databak/fictarc/arch_1_113451.arc',dbms_logmnr.removefile);
3)查询分析日志视图\字典
select * from v$logmnr_logs
select * from v$logmnr_dictionary
4.使用logMiner进行日志分析
execute dbms_logmnr.start_logmnr(DictFileName => '/databak/jydict.ora');
5.创建一张表用于保存分析文件
create table ctms.test as select * from v$logmnr_contents;
6.分析结束后要释放内存
execute dbms_logmnr.end_logmnr;
附:怡讯系统(青州测试机)上,所用数据字典.
execute dbms_logmnr.start_logmnr(DictFileName => '/databak/ ora817dict.ora');
execute dbms_logmnr.start_logmnr(DictFileName => '/databak/jydict.ora');
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/15242702/viewspace-666011/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/15242702/viewspace-666011/