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_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
转载请注明出处