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.

16 comments:

amit gandhi said...

Thanks dear... igot the soultion with the given command ..many thanks

Unknown said...

excelent

goutham said...

thanks mate,my problem is solved

Ravi Gour said...

Thanks ..
my problem is solved using the steps

Unknown said...

Thanks!! my problem is solved :)

Unknown said...

Thanks!! my problem is solved :)

Unknown said...

thanks dude:)

Unknown said...
This comment has been removed by the author.
Unknown said...

Thank you So much I got my Issue Resolved:)

mutyalarao said...

Thanks a lot Srini! was stuck badly till i found your post :)

mutyalarao said...
This comment has been removed by the author.
mutyalarao said...
This comment has been removed by the author.
Thrissur SSA said...

Thanks dude,
I Recovered my Database using this command.

Ajeesh Aravind

Unknown said...

Thank you so much,
I Recovered my Database XE 10g using this command.

Geimer Solarte
Medellin - Colombia

pradeep kumar said...

thank u....i got solution..thank u very much

Ishwar said...

Thanks a lot, solution helped