离线文档分析步骤：
1、增加归档文件
exec dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.1.0\flash_recovery_area\TRAIN\ARCHIVELOG\2010_08_12\O1_MF_1_258_666OMB5V_.ARC',options=>dbms_logmnr.new);
2、增加归档第二个文件，如果需要
exec dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.1.0\flash_recovery_area\TRAIN\ARCHIVELOG\2010_08_12\O1_MF_1_256_666MWOG5_.ARC',options=>dbms_logmnr.addfile);
3、开始分析
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
4、查询
select t.SCN,t.TIMESTAMP,t.SEG_OWNER,t.OPERATION, t.SQL_REDO,t.SQL_UNDO
from v$logmnr_contents t where t.SEG_NAME='AA';
5、停止分析，释放内存
exec sys.dbms_logmnr.end_Logmnr ;
如果是分析在线REDO，则将上述文件修改即可。
==**************************==
实例分析在线日志:
create table a6(id int);
insert into a6 values(1);
insert into a6 values(2);
insert into a6 values(3);
alter database add supplemental log data;
exec dbms_logmnr.add_logfile(logfilename=>'D:\ORACLE\PRODUCT\10.1.0\DB_1\TRAIN\REDO01.LOG',options=>dbms_logmnr.new);
exec dbms_logmnr.add_logfile(logfilename=>'D:\ORACLE\PRODUCT\10.1.0\DB_1\TRAIN\REDO02.LOG',options=>dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile(logfilename=>'D:\ORACLE\PRODUCT\10.1.0\DB_1\TRAIN\REDO03.LOG',options=>dbms_logmnr.addfile);
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
select t.SCN,t.TIMESTAMP,t.SEG_OWNER,t.OPERATION, t.SQL_REDO,t.SQL_UNDO
from v$logmnr_contents t where t.SEG_NAME='A6';
exec sys.dbms_logmnr.end_Logmnr ;
实例分析归档日志：
insert into a6 values(300);
insert into a6 values(400);
insert into a6 values(500);
delete a6 where id =2;
delete a6 where id =3;
alter database add supplemental log data;
exec dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.1.0\flash_recovery_area\TRAIN\ARCHIVELOG\2010_09_06\O1_MF_1_49_6893CXOY_.ARC',options=>dbms_logmnr.new);
exec dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.1.0\flash_recovery_area\TRAIN\ARCHIVELOG\2010_09_06\O1_MF_1_50_6894595C_.ARC',options=>dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.1.0\flash_recovery_area\TRAIN\ARCHIVELOG\2010_09_06\O1_MF_1_49_6893CX12_.ARC',options=>dbms_logmnr.addfile);
exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);
select t.SCN,t.TIMESTAMP,t.SEG_OWNER,t.OPERATION, t.SQL_REDO,t.SQL_UNDO
from v$logmnr_contents t where t.SEG_NAME='A6';
exec sys.dbms_logmnr.end_Logmnr ;
参考文档：
Oracle 10g Logminer 研究及测试
