Tuesday, October 16, 2007

ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [

Problem : ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ due to sudden power failure.

when try to startup Oracle 10g database. it shows that database mounted and then followed by this error

SQL> startup
ORACLE instance started.

Total System Global Area 197772160 bytes
Fixed Size 1347876 bytes
Variable Size 71304572 bytes
Database Buffers 88080384 bytes
Redo Buffers 7139328 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],
[], [], []


Solution: This problem can be solved by using below commands

1. Shutdown the server

Sql> Shutdown Immediate

2. Start the database with MOUNT option

Sql> Startup Mount

3. Recovery the database using below command

Sql> Recover Database

4. Open the database

Sql> Alter Database Open

Above steps will resolve above problem.