教你如何使用LogMiner方法分析数据库日志(1)

@$ORACLE_HOME\rdbms\admin\dbmslm.sql;

@ $ORACLE_HOME\rdbms\admin\dbmslmd.sql;

SQL> connect /as sysdba
SQL> execute dbms_logmnr_d.build(dictionary_filename => 
'dict.ora',dictionary_location => 'G:\oracle\logs');

PL/SQL procedure successfully completed

SQL> execute dbms_logmnr.add_logfile(LogFileName => 
'G:\ORACLE\ORADATA\ORADBSP\REDO04.LOG',Options => dbms_logmnr.new);

PL/SQL procedure successfully completeds

SQL> 
execute dbms_logmnr.add_logfile(LogFileName => 
'G:\ORACLE\ORADATA\ORADBSP\REDO05.LOG',
Options => dbms_logmnr.ADDFILE);

PL/SQL procedure successfully completed

SQL> execute dbms_logmnr.start_logmnr
(DictFileName => 'G:\oracle\logs\dict.ora');

PL/SQL procedure successfully completed

SQL> execute dbms_logmnr.start_logmnr
(startTime => to_date('20070228100000','yyyy-mm-dd hh24:mi:ss'),
endTime => to_date('20070228150000','yyyy-mm-dd hh24:mi:ss'),
DictFileName => 'G:\oracle\logs\dict.ora');

PL/SQL procedure successfully completed

PROCEDURE start_logmnr(
startScn INNUMBER default 0 ,
endScnINNUMBER default 0,
startTimeINDATE default '',
endTime INDATE default '',
DictFileNameINVARCHAR2 default '',
Options INBINARY_INTEGER default 0 );

SQL> execute dbms_logmnr.end_logmnr;

PL/SQL procedure successfully completed

exec dbms_logmnr.add_logfile
('G:\ORACLE\ORADATA\ORADBSP\REDO04.LOG',
dbms_logmnr.removefile);