-
ORA-00600 [4146] while opening Database
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 ?
XD
-
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
-
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.
Agasimani
OCP(10g/9i/8i/8)
-
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.
Sanjay G.
Oracle Certified Professional 8i, 9i.
"The degree of normality in a database is inversely proportional to that of its DBA"
-
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.
XD
-
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.....
XD
-
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.
-
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.
XD
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|