Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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).Received on Mon Jul 01 2002 - 13:43:27 CDT
- text/plain attachment: InterScan_Disclaimer.txt