Hi Micheal,
Thanks, I would do that
cheers,
Ravi
- Michael P Sale <Michael.Sale_at_oracle.com> wrote: >
This is an error that occurred while recovering from
> a rolled back
> transaction. Not a "database" recovery.
>
> This could be caused by doing a control-c while
> trying to truncate a
> large table (Bug 1400739 fixed in 8.1.7.1). Could
> also be from an undo
> operation on a leaf key of a bitmap index. You
> should be able to tell
> this from the trace file. Either way I would open a
> TAR with Oracle
> Support to get a proper diagnosis from the trace
> files.
>
> Ultimately, it looks like you have some form of
> rollback segment
> corruption, likely block corruption in your rollback
> tablespace. I would
> strongly suggest that you open a tar with Oracle
> Support. Check your
> alert log for related trace files, in particular
> SMON trace files. In
> the mean time check out Metalink note 28814.1
> regarding dealing with
> block corruptions just to get an idea of the
> possible implications (e.g.
> logical data corruption).
>
> Regards,
>
> Michael Sale
> Author: Oracle9i for Windows(R) 2000 Tips &
> Techniques
> http://www.amazon.com/exec/obidos/ASIN/0072194626
>
>
> -----Original Message-----
> Sent: Friday, May 31, 2002 6:18 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Dear All,
>
> I am gettying the follwoing error on our alert_log
> file,though no porblem in the activity of database.
> Has any one faced this problem, It is AIX, Oracle
> 8.1.7 Database and non archived mode. We never gave
> like recover any thing, why it is trying to recover
> from error message as follows?
>
> ORA-00600: internal error code, arguments: [2023],
> [5], [1], [], [], [], [], []
> Mon May 13 16:10:59 2002
> ORACLE Instance PAR_D1 (pid = 6) - Error 600
> encountered while recovering transaction (7, 43) on
> object 1.
> Mon May 13 16:10:59 2002
>
> Thanks for your help.
> Ravi
>
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Nalla=20Ravi?=
> INET: vvnrk2001_at_yahoo.co.uk
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Michael P Sale
> INET: Michael.Sale_at_oracle.com
>
> 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).
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Nalla=20Ravi?=
INET: vvnrk2001_at_yahoo.co.uk
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).
Received on Fri May 31 2002 - 17:20:18 CDT
