HELP !!- How to view the content of archive log in Oracle 7

[victorlung]

How can i view the content of archive log in oracle 7?
because there is an abnormal growth in the archive log, we need to trace the reason.

thx

[paulosekutty]

Have you enabled on line backup?
using alter tablespace begin backup

[victorlung]

yes, the problem is in normal condition, the archive logs per day is around 200 MB.
However, the archive logs on 6/1 was nearly 2GB. I want to look into the content of those archive logs to see whether there was abnormal matter happened. For example, what sql did perform in that date.
I want to know how can I view the content of the archive logs, so that i know what was happening

thx a lot

[Tarry]

This one is a tricky one but you can still do it.
You have the arch logs in a unreadable binary format so you must first convert it into ANSI format.
first dump the file using

svrmgr> alter system dump logfile < logfile_name > < options >;

options has stuff like blockno, etc

To check if all of the dump file was written correctly at the end you must have 'END OF REDO DUMP'

if a particular scn can be provided then maybe you can attempt to recover the db before that 'troublesome 'scn.

[pando]

after dump the log tell me what do you understand from all those hex numbers heh

[Tarry]

Well you got to be inventive there. You hunt the block and then decipher the hexes's.

[marist89]

I wonder if it's possible to read an O7 log file with V8i LogMiner?

[Tarry]

Not that I've heard of, Jeff(you can use it for 80x version). But there is a nice (nostagic) way to get on with those hex to readable output.