oracle读取归档日志内容

logmnr的使用

exec sys.dbms_logmnr.add_logfile(logfilename => '/oracle/archive_log/arch_1_6315_830945706.arc',options => dbms_logmnr.new);    //打开归档日志文件

exec sys.dbms_logmnr.start_logmnr(options => sys.dbms_logmnr.dict_from_online_catalog); //启动logmnr

select seg_owner,count(*) from v$logmnr_contents group by seg_owner;   //按用户查询日志条目


select * from v$logmnr_contents where rownum<'3';

添加归档日志文件

exec sys.dbms_logmnr.add_logfile(logfilename=>'/oracle/archive_log/arch_1_6803_830945706.arc');
exec sys.dbms_logmnr.add_logfile(logfilename=>'/oracle/archive_log/arch_1_6316_830945706.arc');
exec sys.dbms_logmnr.add_logfile(logfilename=>'/oracle/archive_log/arch_1_6317_830945706.arc');

exec sys.dbms_logmnr.add_logfile(logfilename=>'/oracle/archive_log/arch_1_6325_830945706.arc');

关闭logmnr

exec sys.dbms_logmnr.end_logmnr;

##################################

迷途小运维随笔

作者：john

转载请注明出处