-
HELP !!- How to view the content of archive log in Oracle 7
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
Code:
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
-
I wonder if it's possible to read an O7 log file with V8i LogMiner?
Jeff Hunter
-
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.
Tarry Singh
I'm a JOLE(JavaOracleLinuxEnthusiast)
--- Everything was meant to be---
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|