使用dbms_logmnr挖掘误操作

SQL> create table t1(id int) tablespace test; 
SQL> insert into t1 values(1); 
SQL> commit; 
SQL> drop table t1 purge; 
SQL> alter system switch logfile; 
SQL> / 
SQL> / 
SQL> select name from v$archived_log; 
NAME 
-----------------------------------------------------------------------
/u01/disk1/timran/arch_1_782662700_129.log 
/u01/disk1/timran/arch_1_782662700_130.log 
/u01/disk1/timran/arch_1_782662700_131.log 
/u01/disk1/timran/arch_1_782662700_132.log 
/u01/disk1/timran/arch_1_782662700_133.log     //drop table t1 purge
/u01/disk1/timran/arch_1_782662700_134.log 
/u01/disk1/timran/arch_1_782662700_135.log

SQL> show parameter utl     
NAME        TYPE        VALUE 
------------------------------------ ----------- 
utl_file_dir  string      /home/oracle/logmnr 

SQL> execute dbms_logmnr_d.build('dict.ora','/home/oracle/logmnr',dbms_logmnr_d.store_in_flat_file);  
SQL> execute dbms_logmnr.add_logfile(logfilename=>'/u01/disk1/timran/arch_1_782662700_133.log ',options=>dbms_logmnr.new);  
SQL> execute dbms_logmnr.add_logfile(logfilename=>'/u01/disk1/timran/arch_1_782662700_134.log ',options=>dbms_logmnr.addfile); 
SQL> execute dbms_logmnr.start_logmnr(dictfilename=>'/home/oracle/logmnr/dict.ora',options=>d bms_logmnr.ddl_dict_tracking);   

SQL> select username,scn,to_char(timestamp,'yyyy-mm-dd hh24:mi:ss'),sql_redo from v$logmnr_contents WHERE lower(sql_redo) like 'drop table%'; 

USERNAME SCN TO_CHAR(TIMESTAMP,'YYYY-MM-DDH SQL_REDO 
------------------------------ ---------- ------------------------------ 
SCOTT   1917250   2012-07-18 16:44:55           drop table test purge; 
SCOTT    1917267   2012-07-18 16:45:01          drop table student purge; 
SCOTT    1918000   2012-08-01 17:28:29          drop table t1 purge; 

SQL> execute dbms_logmnr.end_logmnr;