Results 1 to 6 of 6
  1. #1
    Join Date
    Oct 2009
    Location
    South Africa, the land of mystery
    Posts
    5

    Unanswered: Oracle Archive Logs from Unix to Windows

    Hi there,

    I have an Archive log file that was created on a Sparc Unix server in Oracle 11g.
    I need to mine this file on a windows platform.
    The format is not readable in Windows - I do understand why.

    Are there any tools or conversion routines that will allow me access this log file in windows?

    Thank You,
    Markus
    Last edited by markusv; 10-09-09 at 21:16.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Are there any tools or conversion routines that will allow me access this log file in windows?
    If you had transfered the file via FTP in ASCII mode, it would be better.
    You can open it with WORDPAD & it will be OK.
    Alternatively find & use the utility "unix2dos" on it.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Oct 2009
    Location
    South Africa, the land of mystery
    Posts
    5

    Ho do I extract the log files from the Archivelogs?

    Thanks,

    The problem is that Unix2Dos works for text files and the archive logs are in binary format. Is it possible to extract the log files from an archive file for parsing?

    Thanks

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You are correct & I totally misread/misunderstood what you were asking.

    If transferring the file via FTP in binary mode does not work, then I am out of ideas.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    check out the following link for info on logminer

    Using LogMiner to Analyze Redo Log Files
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  6. #6
    Join Date
    Oct 2009
    Location
    South Africa, the land of mystery
    Posts
    5
    I seem to get different views and messages. Can anyone confirm if I can read the binary Archivelog file with Logminer. Documentation seems to point to logfiles only.

    ...so does practice...
    Last edited by markusv; 10-12-09 at 15:15.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •