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
Printable View
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
Have you enabled on line backup?
using alter tablespace begin backup
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
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
options has stuff like blockno, etcCode:svrmgr> alter system dump logfile < logfile_name > < options >;
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.
after dump the log tell me what do you understand from all those hex numbers heh
Well you got to be inventive there. You hunt the block and then decipher the hexes's.
I wonder if it's possible to read an O7 log file with V8i LogMiner?
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.