Logminer not showing recent actions
I basically follow this procedure:
The logminer-package is already compiled.
I add the logfiles (adding all with dbms_logmnr.add_logfile())
Then I start the logminer - typically dbms_logmnr.start_logmnr(options => dbms_logmnr.dict_from_online_catalog + dbms_logmnr.print_pretty_sql)
I do a search through v$logmnr_contents and find the expected.
Now I do some inserts, updates and deletes. Should I expect them to show up when searching v$logmnr_contents or do I have to "start" the logminer again?
Here's my problem:
Even if I do restart the logminer (stop it, then start it again), the new inserts, updates and deletes mentioned above do not show in v$logmnr_contents. It still just contains the old ones. Some statements from the 18th, for instance.
Will they only show after a while? Or what is going on here?
The code I am using (run one by one, not as a script):
Code:
@D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\dbmslm.sql
grant execute_catalog_role to system
create public synonym dbms_logmnr for sys.dbms_logmnr
select distinct member logfilename from v$logfile
begin
sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO03.LOG');
sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO01.LOG');
sys.dbms_logmnr.add_logfile('D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\REDO02.LOG');
end;
execute sys.dbms_logmnr.START_LOGMNR(options => sys.dbms_logmnr.dict_from_online_catalog + sys.dbms_logmnr.print_pretty_sql);
select username, to_char(timestamp,'dd/mm/yyyy hh24:mi:ss') timestamp, seg_type_name, table_name, table_space, session# SID, serial#, sql_undo, sql_redo
from v$logmnr_contents where table_name='RAB_TEST';
Thank you for any help.
