logminer

 

SQL> execute dbms_logmnr_d.build(options=>dbms_logmnr_d.store_in_redo_logs);

PL/SQL 过程已成功完成。

---

---

SQL> alter system set utl_file_dir='D:\oracle\product\10.2.0\admin\orcl' scope=s
pfile;

系统已更改。

SQL> shutdown immediate

SQL> startup

 

--建立字典文件

execute dbms_logmnr_d.build('dict.ora','D:\oracle\product\10.2.0\admin\orcl',dbms_logmnr_d.store_in_flat_file)

---

--分析日志

SQL> execute dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.2.0\orad
ata\orcl\redo02.log',options=>dbms_logmnr.new);

PL/SQL 过程已成功完成。

SQL> execute dbms_logmnr.add_logfile(logfilename=>'D:\oracle\product\10.2.0\orad
ata\orcl\redo01.log',options=>dbms_logmnr.addfile);

PL/SQL 过程已成功完成。

---

--启动logminer               MDL

execute dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

---

SQL> select username,timestamp,sql_redo from v$logmnr_contents where seg_name like '%LOGMINER%';
 
USERNAME                       TIMESTAMP   SQL_REDO
------------------------------ ----------- --------------------------------------------------------------------------------
JASON                          2011-3-8 10 create table logminer(id number,name varchar2(20))
                                           ;
 
JASON                          2011-3-8 10 insert into "JASON"."LOGMINER"("ID","NAME") values ('1','a');
JASON                          2011-3-8 10 insert into "JASON"."LOGMINER"("ID","NAME") values ('2','f');
JASON                          2011-3-8 10 update "JASON"."LOGMINER" set "NAME" = 'g' where "NAME" = 'f' and ROWID = 'AAAMm

--

结束logminer

EXECUTE DBMS_LOGMNR.END_LOGMNR;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/25323853/viewspace-688594/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/25323853/viewspace-688594/