alter database add supplemental log data;

select SUPPLEMENTAL_LOG_DATA_MIN from v$database;

select NAME,THREAD#,SEQUENCE#,FIRST_TIME from v$archived_log;

alter system set utl_file_dir='/home/oracle/dict' scope=spfile;

exec dbms_logmnr_d.build('abcd.ora','/home/oracle/dict');

exec dbms_logmnr.add_logfile('/u01/app/oracle/flash_recovery_area/SHIHFA/archivelog/2014_08_07/o1_mf_1_4_9y75gc5y_.arc',dbms_logmnr.new);

exec dbms_logmnr.add_logfile('/u01/app/oracle/flash_recovery_area/SHIHFA/archivelog/2014_08_07/o1_mf_1_5_9y75r486_.arc',dbms_logmnr.addfile);

exec dbms_logmnr.start_logmnr(dictfilename=>'/home/oracle/dict/abcd.ora');

exec dbms_logmnr.end_logmnr;

v$logmnr_contents;

select seg_owner,sql_redo,sql_undo from v$logmnr_contents where seg_owner='TEST';

create table tt1 as select * from v$Logmnr_contents;

ITPub博客

Logmnr