Hi Micheal, Thanks, I would do that
cheers, Ravi --- Michael P Sale <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).