FAQ
We are trying to analyze 200G of redologs (archive logs) from past 1 year. The database is on windows and the log miner is taking about 4 hours to analyze 2G log files. Is it possible to move the log files to sun SPARC Solaris and analyze ? I would think the log files between NT and Unix won't be compatible but I am looking for ideas.

Thanks
Rakesh

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rakesh Gupta
INET: GuptaR_at_telecomsys.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Search Discussions

  • Goulet, Dick at Oct 20, 2003 at 4:14 pm
    Rakesh,

    According to a session I attended at this years OraTechs conference, yes you can. Now I haven't experimented with that so throw a shovel full of salt into the mix.

    Dick Goulet
    Senior Oracle DBA
    Oracle Certified 8i DBA

    -----Original Message-----
    Sent: Monday, October 20, 2003 11:59 AM
    To: Multiple recipients of list ORACLE-L

    We are trying to analyze 200G of redologs (archive logs) from past 1 year. The database is on windows and the log miner is taking about 4 hours to analyze 2G log files. Is it possible to move the log files to sun SPARC Solaris and analyze ? I would think the log files between NT and Unix won't be compatible but I am looking for ideas.

    Thanks
    Rakesh

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rakesh Gupta
    INET: GuptaR_at_telecomsys.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Goulet, Dick
    INET: DGoulet_at_vicr.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Mark Leith at Oct 20, 2003 at 4:19 pm
    You need the power of the Grid!;)

    Sorry, can't help from my side - just couldn't resist!

    -----Original Message-----
    Rakesh Gupta
    Sent: 20 October 2003 17:00
    To: Multiple recipients of list ORACLE-L

    We are trying to analyze 200G of redologs (archive logs) from past 1 year.
    The database is on windows and the log miner is taking about 4 hours to
    analyze 2G log files. Is it possible to move the log files to sun SPARC
    Solaris and analyze ? I would think the log files between NT and Unix won't
    be compatible but I am looking for ideas.

    Thanks
    Rakesh

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rakesh Gupta
    INET: GuptaR_at_telecomsys.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
    ---
    Incoming mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003

    ---
    Outgoing mail is certified Virus Free.
    Checked by AVG anti-virus system (http://www.grisoft.com).
    Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Mark Leith
    INET: mark_at_cool-tools.co.uk

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------
    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).
  • Rakesh Gupta at Oct 20, 2003 at 6:14 pm
    FYI,

    I tried the logminer utility ver 8.1.7.2 on solaris to analyze windows os based log files, it didn't work. Apparently, it could not read the file header information.

    Errors:
    ORA-01284: file /export/home/oracle/utldir/ORCLT001S03748.ARC cannot be opened
    ORA-00308: cannot open archived log
    '/export/home/oracle/utldir/ORCLT001S03748.ARC'
    ORA-27047: unable to read the header block of file
    SVR4 Error: 25: Inappropriate ioctl for device
    Additional information: 2

    Thanks
    Rakesh

    --
    Please see the official ORACLE-L FAQ: http://www.orafaq.net
    --
    Author: Rakesh Gupta
    INET: GuptaR_at_telecomsys.com

    Fat City Network Services -- 858-538-5051 http://www.fatcity.com
    San Diego, California -- Mailing list and web hosting services
    ---------------------------------------------------------------------

    To REMOVE yourself from this mailing list, send an E-Mail message
    to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
    the message BODY, include a line containing: UNSUB ORACLE-L
    (or the name of mailing list you want to be removed from). You may
    also send the HELP command for other information (like subscribing).

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 20, '03 at 3:59p
activeOct 20, '03 at 6:14p
posts4
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase