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博客 ” ,链接:http://blog.itpub.net/26179376/viewspace-1981682/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/26179376/viewspace-1981682/