Re: LogMiner and Oracle 8.0

Hi Marco:

To my understanding, LogMiner is designed to work with Oracle8.1 and NOT Oracle8.0. I *think* that's your problem....

Regards,

--
David C. Sisk
The Unofficial ORACLE on NT site
http://www.ipass.net/~davesisk/oont.htm

Marco Riegel wrote in message <7lv5p7$j2p$1_at_newsread.do.de.uu.net>...
>Hi,
>
>I am trying to analyze Oracle 8.0 archived redo logs with the LogMiner
>package of Oracle8i.
>
>The log files are taken from a Sun E450 running Solaris 2.5.1 and Oracle
>8.0.5.1.0 . After generating the dictionary on that machine I both
transferred
>the dictionary file and 3 sample archived redo logs to our Oracle 8.1.5
test
>installation on a Sun E10 running Solaris 2.6. I know this doesn't meet
>the requirements stated in the documentation (same hardware and os levels)
>and therefore I necessarily cannot blame Oracle for it.
>
>After selecting 10000 rows from v$logmnr_contents (just 200 rows with
>sql_redo not null) the statements breaks with:
>
>ORA-00356: inconsistent lengths in change description
>ORA-00353: log corruption near block 4099 change 140166141 time 07/05/99
>17:27:0
>1
>ORA-00334: archived log: '/users/home/oracle/spool/1_4666.dbf'
>
>This happens to all the sample redo logs I tried. I am quite sure that
>the redo logs aren't broken.
>
>Does anybody know if there's a switch that changes the behavior to
>"okay, I know that this log does not seem to be okay but I continue to try
>to disclose as much statements as I can".
>Or does it fail because of the different os levels ??
>
>
>Regards,
>
>Marco
>
>Tools Quality Standards UUNET Deutschland GmbH
>Tel. +49 231 972 1355 Sebrathweg 20
>Fax. +49 231 972 1601 44149 Dortmund, Germany
>mr@de.uu.net URL http://www.uunet.de/
Received on Wed Jul 07 1999 - 21:55:49 CDT