Logminer可以对归档日志进行分析
1、查找数据库归档日志序号
SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss ';
SQL>select sequence#,first_time from v$log_history order by first_time desc;
2、确定要分析的日志
SQL>select first_time,name from v$archived_log order by first_time desc;
3、使用logminer分析数据
SQL> execute dbms_logmnr.add_logfile(logfilename=>'D:\ORACLE\PRODUCT\10.2.0\ARCH IVELOG\XYHORCL\1_9_842540062.ARC',options=>dbms_logmnr.new);
4、启动Logminer
SQL> execute dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_cata log);
5、把分析数据放入表并授权给普通用户
SQL> create table logminer_20140320 as select * from v$logmnr_contents;
grant select on logminer_20140320 to scott;
6、结束LogMiner分析
SQL> execute dbms_logmnr.end_logmnr;
7、查看分析日志结果
SQL> select timestamp,sql_redo,sql_undo from sys.logminer_20140320 where seg_own
er='SCOTT' and sql_undo is not null;
1、查找数据库归档日志序号
SQL>alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss ';
SQL>select sequence#,first_time from v$log_history order by first_time desc;
2、确定要分析的日志
SQL>select first_time,name from v$archived_log order by first_time desc;
3、使用logminer分析数据
SQL> execute dbms_logmnr.add_logfile(logfilename=>'D:\ORACLE\PRODUCT\10.2.0\ARCH IVELOG\XYHORCL\1_9_842540062.ARC',options=>dbms_logmnr.new);
4、启动Logminer
SQL> execute dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_cata log);
5、把分析数据放入表并授权给普通用户
SQL> create table logminer_20140320 as select * from v$logmnr_contents;
grant select on logminer_20140320 to scott;
6、结束LogMiner分析
SQL> execute dbms_logmnr.end_logmnr;
7、查看分析日志结果
SQL> select timestamp,sql_redo,sql_undo from sys.logminer_20140320 where seg_own
er='SCOTT' and sql_undo is not null;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29489498/viewspace-1125756/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29489498/viewspace-1125756/