oracle工具：logminer的简单使用

我的环境：
[root@localhost ~]# uname -a
Linux localhost.localdomain 2.6.18-308.el5xen #1 SMP Fri Jan 27 17:59:00 EST 2012 i686 i686 i386 GNU/Linux

sys@ORCL> select * from v$version where rownum=1;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod

 

    10g其实不需要生成dictionary文件了。只要直接把日志文件加载，然后分析即可。

    1 产生数据库操作

hr@ORCL> drop table t purge;

Table dropped.

hr@ORCL> create table logmnr_test (id number,name varchar2(20));

Table created.

hr@ORCL> insert into logmnr_test values(1,'think');

1 row created.

hr@ORCL> insert into logmnr_test values(2,'water');

1 row created.

hr@ORCL> commit;                    

Commit complete.

hr@ORCL> select sequence#,status from v$log;

 SEQUENCE# STATUS
---------- ------------