1.      Open database supplemental

Alter database add supplemental log data;

2.      Create LogMiner dict

Execute dbms_logmnr_d.bulid(options=>dbms_logmnr_d.store_in_redo_logs);

3.      Create  log list and Add logfile or archivelog

Execute dbms_logmnr.add_logfile(logfilename=>’/oratest/oradata/STCSTEST/redo03.log’,

Options=>dbms_logmnr.new);

or

execute dbms_logmnr.add_logfile(logfilename=>’/oratest/archivelgo/STCSTEST/1_XX.arc’,

options=dbms_logmnr.addfile);

4.      Remove logfile or archivelog from loglist

Execute dbms_logmnr.add_logfile(logfilename=>’/oratest/oradata/STCSTEST/redo03.log’,

Options=>dbms_logmnr.removefile);

5.      Start LogMiner analyse

Execute dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog);

OR

Dbms_logmnr.start_logmnr(

StartTime=>to_date(‘2011-7-1 12:00:00’,’yyyy-mm-dd hh24:mi:ss’,

EndTime=>to_date(‘2011-7-1 15:00:00’,’yyyy-mm-dd hh24:mi:ss’,

StartSCN=>xxx,

EndSCN=>xxxx,

Options=>XXX,)

6.      Alfer start logMiner analyse,check LogMiner result;before select v$logmnr_contents,please start logminer anaylse;

Select username,sql_redo from v$logmnr_contents where username=’xxx’ OR

Table_name=’XX’;

7.      End LogMiner

Execute dbms_logmnr.end_logmnr;

Alter end LogMiner,anaylse result also disapper,because analyse result stay in PGA;