Re: LogMiner and ORA-03113

whats your blocksize, anything other than 2K has been know to cause all kinds of problems.

joe

Walter K wrote:

> I'm trying to analyze some archive logs via LogMiner
> and I keep getting the error ORA-03113 (end of file on
> communications channel) when I query the
> V$LOGMNR_CONTENTS view. I did a "new" and "start"
> prior to running the query. This process that I am
> going through works on some log files but not on
> others. The log files aren't corrupted because I can
> restore/recover the database and apply the logs
> successfully for a roll-forward. I'm just running a
> 'select count(*)' query at this point.
>
> Has anyone else encountered this and come up with a
> solution?
>
> I've checked MetaLink, Google, etc and so far have not
> come up with anything that describes what may be the
> cause. I'm running 8.1.7.2 (64bit) on Solaris 8.
>
> MANY thanks in advance.
>
> -w
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
>

-- 
Joe Testa, Oracle DBA
Want to have a good time with a bunch of geeks? Check out:
http://www.geekcruises.com/standard_interface/future_cruises.html
I'm presenting, when registering drop my name :)






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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).