HELP !!- How to view the content of archive log in Oracle 7
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

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

Hybrid View

  1. #1
    Join Date
    Jan 2003
    Posts
    3

    Question 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

  2. #2
    Join Date
    Aug 2002
    Posts
    16
    Have you enabled on line backup?
    using alter tablespace begin backup

  3. #3
    Join Date
    Jan 2003
    Posts
    3
    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

  4. #4
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- Everything was meant to be---

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    after dump the log tell me what do you understand from all those hex numbers heh

  6. #6
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    Well you got to be inventive there. You hunt the block and then decipher the hexes's.
    Tarry Singh
    I'm a JOLE(JavaOracleLinuxEnthusiast)
    TarryBlogging
    --- Everything was meant to be---

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    I wonder if it's possible to read an O7 log file with V8i LogMiner?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jan 2002
    Location
    Netherlands
    Posts
    1,587
    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)
    TarryBlogging
    --- 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
  •  



Click Here to Expand Forum to Full Width