RE: How to read REDO log

alter system dump logfile <logfilename> <options> will let you decode the contents of a redo logfile to a text file. Remember, by text file, I do not mean it is a verbose text, but much more understandable compared to the encoded redo log file.  

Please make sure that background_dump_dest points to a directory that has enough space available, I have seen examples of a 5MB redo file creating a trace file about 5 times it size. You may also need to set max_dump_file_size appropriately (to unlimited).  

I read all this information in an article written by Graham Thornton date 9/26/2000.  

Raj

Rajendra Jamadagni MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot com

Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!

-----Original Message-----
Sent: Monday, July 01, 2002 1:58 PM
To: Multiple recipients of list ORACLE-L

I think you can do this being in a 8i database.

-----Original Message-----
Sent: Monday, July 01, 2002 12:29 PM
To: Multiple recipients of list ORACLE-L

Can I setup LogMiner to read REDO log of Oracle8.0.5? Someone tells me LogMiner only works for Oracle8.1 or above, is it correct? Is there another tool to read REDO log besides LogMiner?  

Thanks,
David

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jamadagni, Rajendra
  INET: Rajendra.Jamadagni_at_espn.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



text/plain attachment: InterScan_Disclaimer.txt