How to use log miner in Oracle Database
SELECT *
FROM V$ARCHIVED_LOG
WHERE FIRST_CHANGE# <= 12435785206731
AND NEXT_CHANGE# >= 12435785206731;
FROM V$ARCHIVED_LOG
WHERE FIRST_CHANGE# <= 12435785206731
AND NEXT_CHANGE# >= 12435785206731;
EXECUTE DBMS_LOGMNR.ADD_LOGFILE( -
LOGFILENAME => 'arch file', -
OPTIONS => DBMS_LOGMNR.NEW);
LOGFILENAME => 'arch file', -
OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE DBMS_LOGMNR.START_LOGMNR( -
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
SELECT username AS USR, (XIDUSN || '.' || XIDSLT || '.' || XIDSQN) AS XID, SQL_REDO, SQL_UNDO FROM V$LOGMNR_CONTENTS where XIDUSN=49 and XIDSLT=25 and XIDSQN=22415431;
EXECUTE DBMS_LOGMNR.END_LOGMNR();
Comments
Post a Comment