I was working on my Oracle 9i database and 6i form server. windows 2003
my server suddenly restarted and after that oracle showing the error ORA-01033: ORACLE initialization or shutdown in progress...
I try to resolve this error through this method. I received above mentioned error. please help how to resolve this error. ORA-00600.
C:\>sqlplus
SQL*Plus: Release 9.2.0.1.0 -
Copyright (c) 1982, 2005, Oracle Corporation. All rights reserved.
Enter user-name: sys as sysdba
Enter password :password
Shutdown Database
SQL> shutdown immediate;
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
Startup Database (force)
SQL> startup force;
ORACLE instance started.
Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
ORA-00600: internal error code, arguments: kcratr1_lostwrt],[,],[..................
Please note I dont have metalink Id to access.
ORA-00600 how to resolve this error?
Hi there
What's the use of database, it's TEST or PROD? It looks like some data file(s) got corrupted.
If it's PROD then should be in ARCHIVED LOG mode try to use following commands sequence to recover database before it got crashed.
SQL> STARTUP MOUNT;
SQL> RECOVER DATABASE UNTIL TIME '2008-12-15:23:59:00' USING BACKUP CONTROLFILE;
If it's not PROD then I would suggest to drop your database with DBCA and recreate it.
Thanks
Amir
What's the use of database, it's TEST or PROD? It looks like some data file(s) got corrupted.
If it's PROD then should be in ARCHIVED LOG mode try to use following commands sequence to recover database before it got crashed.
SQL> STARTUP MOUNT;
SQL> RECOVER DATABASE UNTIL TIME '2008-12-15:23:59:00' USING BACKUP CONTROLFILE;
If it's not PROD then I would suggest to drop your database with DBCA and recreate it.
Thanks
Amir
Who is online
Users browsing this forum: No registered users and 0 guests