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

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.

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