--add supplemental log
alter database add supplemental log data;
alter database add supplemental log data (primary key) columns;
alter database add supplemental log data (unique) columns;
--在一个会话中执行
--logminer
alter session set nls_date_format=‘yyyy-mm-dd HH24:mi:ss‘ ;
begin
dbms_logmnr.start_logmnr(startTime => ‘2018-06-26 04:00:00‘,
endTime => ‘2018-06-26 05:00:00‘,
Options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG+dbms_logmnr.CONTINUOUS_MINE) ;
end ;
/
select t.OS_USERNAME,t.USERNAME,t.MACHINE_NAME,t.SEG_OWNER,t.TABLE_NAME,t.SQL_REDO,t.SQL_UNDO,t.TIMESTAMP from v$logmnr_contents t where t.table_name=‘&table_name‘ order by t.TIMESTAMP desc ;
