@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';

SQL> exec dbms_logmnr.add_logfile
(logfilename=>'d:\jeeva\archives\ARC00015_0644871648.001',
options=>dbms_logmnr.new);

PL/SQL procedure successfully completed.

SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog
+dbms_logmnr.committed_data_only);

PL/SQL procedure successfully completed.

SQL> exec dbms_logmnr.add_logfile(logfilename=>'d:\archives\ARC00016_0644871648.001');

PL/SQL procedure successfully completed.

SQL> exec dbms_logmnr.add_logfile(logfilename=>'d:\archives\ARC00017_0644871648.001');

PL/SQL procedure successfully completed.

SQL> exec dbms_logmnr.add_logfile(logfilename=>'d:\archives\ARC00018_0644871648.001');

PL/SQL procedure successfully completed.

SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog
+dbms_logmnr.committed_data_only+dbms_logmnr.print_pretty_sql);

PL/SQL procedure successfully completed.

SQL> col operation for a15
SQL> col sql_redo for a25
SQL> col sql_undo for a25
SQL> select operation, sql_redo, sql_undo from v$logmnr_contents where seg_name=
'NANDY' and seg_owner='JEEVADB';

OPERATION       SQL_REDO                  SQL_UNDO
--------------- ------------------------- -------------------------
DDL             create table nandy (no nu
                mber, name varchar2(10));

UPDATE          update "JEEVADB"."NANDY"  update "JEEVADB"."NANDY"
                  set                       set
                    "NAME" = 'ALONSO'         "NAME" = 'KUMAR'
                  where                     where
                    "NAME" = 'KUMAR' and      "NAME" = 'ALONSO' and
                    ROWID = 'AAANO0AAIAAA     ROWID = 'AAANO0AAIAAA
                AOMAAB';                  AOMAAB';

SQL> exec dbms_logmnr.end_logmnr()

PL/SQL procedure successfully completed.