Re: Oracle log files format

If you want to play around with learning about the formatting and content of log files, then you can use the command:

alter system dump logfile 'logfilename';

This gives you a trace file holding a symbolic dump of the file. You might want to do:

alter system switch logfile;

and do a limited amount of work before dumping it though, as the symbolic dump is a bit big.

Once you've done this, look for

    REDO RECORD (especially the LENgth information) and

    CHANGE #N
entries.

The use od -x on the file (for unix systems) and you can start to match up the described bits of the dump with the actual hex content.

As with all 'developer only' aspects of Oracle, the dumps haven't necessarily caught up with all the features, so you may find material in the logfile which doesn't appear to be in the dump.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Next Seminar - UK, April 3rd - 5th
http://www.jlcomp.demon.co.uk/seminar.html

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases


lodz wrote in message ...


>Can any body know Oracle DB log file format?

>

>Thanks.

>

>