logminer的基本组成
package
- dbms_logmnr_d:包含一个用于提取数据字典信息的过程，即dbms_logmnr_d.build()
还包含一个重建logminer表的过程,dbms_logmnr_d.set_tablespace,默认情况下，
longminer表建立在system表空间中
- dbms_logmnr: add_logfile(name varchar2,options number) 添加/删除用于分析的日志文件
start_logmnr(start_scn number,end_scn number,start_time number,end_time number,
dictfilename varchar2,options number)用于开启日志分析，同时确认分析的时间/scn窗口以及
确认是否使用提取出来的数据字典信息。
end_logmnr() 终止分析会话，他将释放logminer所占用的内存。
view
- v$logmnr_dictionary :logminer可以使用的数据字典信息，因为logmnr可以有个字典文件，该视图用于显示这个信息
- v$logmnr_parameters:当前logminer所设定的参数
- v$logmnr_logs: 当前用于分析的日志列表
- v$logmnr_contents:日志分析结果
Package created.
Grant succeeded.
SQL> @?/rdbms/admin/dbmslmd.sql
Package created.
SQL> alter system set utl_file_dir='/u01/logminer' scope=spfile;
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
startup
ORACLE instance started.
Total System Global Area 432013312 bytes
Fixed Size 2021344 bytes
Variable Size 180357152 bytes
Database Buffers 247463936 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
System altered.
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
startup
ORACLE instance started.
Total System Global Area 432013312 bytes
Fixed Size 2021344 bytes
Variable Size 180357152 bytes
Database Buffers 247463936 bytes
Redo Buffers 2170880 bytes
Database mounted.
Database opened.
SQL> exec dbms_logmnr_d.build(dictionary_filename => 'dictionary.ora',dictionary_location => '/u01/logminer');
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL> exec dbms_logmnr.add_logfile(logfilename => '/u01/oradata/oracle10/redo01.log',options => dbms_logmnr.new);
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL> exec dbms_logmnr.start_logmnr(dictfilename => '/u01/logminer/dictionary.ora');
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
SQL> exec dbms_logmnr.end_logmnr;
其他操作：
select filename from v$logmnr_logs;
exec dbms_logmnr.add_logfile(logfilename => '/u01/arch/1_11_798025652.dbf',options => dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile(logfilename => '/u01/arch/1_12_798025652.dbf',options => dbms_logmnr.removefile);