Re: Ora-600 error

Majid,

I am afraid you are correct. This ora-600 is caused by a database block's SCN or transaction id to be invalid in the rollback segment. Basically you are running into a corrupt rollback segment.

I would recommend to open a TAR with support and see if they can help you with this problem. If you were archiving then I would recommend to restore that datafile and apply archive logs. Since you are not, I am not sure what the suggestion would be.

Sorry. Tammy

Majid Kazemi wrote:

> Hi everyone;
> I have an Oracle 7.3.4 database on NT 4.0 with no archive.
> I have received the following error during the database startup:
>
> ORA-00600: internal error code, arguments: [4147], [88], [53], [], [], [],
> [], []
>
> Has anybody encountered this error before. I believe this error is
> happening because of the data corruption. I appreciate any help.
>
> Thanks;
> Majid Kazemi
> --
> Author: Majid Kazemi
> INET: Mkazemi_at_teranet.on.ca
>
> 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).

--
--------------------------------------
Tammy Bednar
Backup & Recovery Product Manager
Data Storage Technologies    phone:  650.506.4780
Server Technologies      fax:    509.461.4477
Oracle Corporation      email:  Tammy.Bednar_at_oracle.com