A quick LogMiner exercise

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();