Re: Log Miner for dummies - need help viewing the contents of an archived redo log

  • From: oracle@xxxxxxxxxxxx
  • To: jclarke@xxxxxxxxxxxxxxx
  • Date: Tue, 30 Aug 2005 10:26:58 -0400

John Clarke wrote:

If you're on 9iR2+, Check out Metalink doc 291686.1. Specifically, section 10-2.



That was very helpful.


I got what I needed with this:



EXECUTE DBMS_LOGMNR.ADD_LOGFILE (LOGFILENAME =>
'/path/0000012454.arc',OPTIONS => DBMS_LOGMNR.NEW);

EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS =>
DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

SELECT   SCN, TO_CHAR (TIMESTAMP, 'DD-MON-YYYY HH24:MI:SS') TIMESTAMP,
        seg_owner, sql_redo
   FROM v$logmnr_contents
  WHERE seg_owner LIKE '%' AND sql_redo LIKE '%'
ORDER BY SCN;

EXECUTE DBMS_LOGMNR.end_LOGMNR;



thanks to everyone for their help.


-- //www.freelists.org/webpage/oracle-l

Other related posts: