ORA-00600 [4146] while opening Database

[xav]

Hello,

We have these messages when we start our DB :

PMON started
DBWR started
LGWR started
Tue Jan 14 14:22:21 2003
alter database mount exclusive
Successful mount of redo thread 1.
Tue Jan 14 14:22:21 2003
Completed: alter database mount exclusive
Tue Jan 14 14:22:21 2003
alter database open
Beginning crash recovery of 1 threads
Crash recovery completed successfully
Tue Jan 14 14:22:23 2003
Thread 1 advanced to log sequence 214
Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf
Thread 1 opened at log sequence 214
Current log# 1 seq# 214 mem# 0: /ora733/oracle/adminoralog/log1ADMIN.dbf
Successful open of redo thread 1.
Tue Jan 14 14:22:23 2003
SMON: enabling cache recovery
SMON: enabling tx recovery
Tue Jan 14 14:22:24 2003
Completed: alter database open
Tue Jan 14 14:22:24 2003
Errors in file /ora733/oracle/adminoralog/rdbms/smon_28778.trc:
ORA-00600: internal error code, arguments: [4146], [41], [38], [], [], [], [], []

We tried to suppress the rollback_segs from init.ora without effect.
We tried to use _corrupted_rollback_segments without effect.
Can you help us ?

[pando]

when you have corrupted rollback segment you best bet is call support because depending on situation the way of solving is different

to start with I would make a cold backup of your current database

[agasimani]

Using _corrupted_rollback_segments is not a wise solution unless:
1. You are a genius DBA and you know what you are doing
2. Oracle support asks you to do so

My suggestion is take a cold backup asap as pando has suggested and contact Oracle.

[SANJAY_G]

ORA-600 Lookup on Metalink.

http://metalink.oracle.com/metalink/...&p_id=153788.1


But it doesn't return anything for the argument in your ORA-600.

[xav]

Now I can open the database (after the command ALTER DATABASE DATAFILE 'Path of the RBS.dbf' OFFLINE DROP') .... BUT !

... the RBS are in NEEDS RECOVERY status and I can't put them offline to drop them.

I tried once again to use the _corrupted_rollback_segments parameter without success.
I can't anymore drop the tablespace.

Thanks for your help.

[xav]

Some news :

When I try to export the full database, I receveive these messages :

EXP-00008: ORACLE error 376 encountered
ORA-00376: file 2 cannot be read at this time
ORA-01110: data file 2: 'Path of the RBS tablespace.dbf'

... for all the tables to export.

Then core dump.....

[supower]

1. Shutdown the database and modified init.ora file,
_offline_rollback_segments=R01, R02....

2. Restart database and now those rollback_segments will be offline and you can drop them.

[xav]

I've found this solution :

To put the datafile in OFFLINE status:
- RECOVER DATABASE USING BACKUP CONTROLFILE
then
- ALTER DATABASE OPEN RESETLOGS

Then using _CORRUPTED_ROLLBACK_SEGMENTS in init.ora it's possible to drop the RBS then their tablespace.

Now I can re-create the tablespace (reusing the datafile) then re-create the rollback segments.