Post date: 22-Jun-2009 15:29:52
Here i am just covering one of the ways to get information from Logminer and that is , by using ONLINE CATALOG option. These are for friends who have basic theoretical knowledge about Logminer.
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+DATA/rdb/1_320_678179194.dbf',OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+DATA/rdb/1_321_678179194.dbf',OPTIONS => DBMS_LOGMNR.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+DATA/rdb/1_322_678179194.dbf',OPTIONS => DBMS_LOGMNR.ADDFILE);
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '+DATA/rdb/1_323_678179194.dbf',OPTIONS => DBMS_LOGMNR.ADDFILE);
EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG+DBMS_LOGMNR.COMMITTED_DATA_ONLY+DBMS_LOGMNR.PRINT_PRETTY_SQL);
SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' ||Â XIDSQN) AS XID,SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS WHERE username IN ('HR');
EXECUTE DBMS_LOGMNR.END_LOGMNR();