Pages

Tuesday, February 28, 2017

ORA-00600 kcratr1_lastbwr

======================
Issue
======================
Oracle is crashing with ORA-00600 kcratr1_lastbwr

======================
Oracle documentation
======================
ORA-00600 kcratr1_lastbwr
After a disk failure that caused the database to crash, the instance fails to start up with ORA-00600: arguments: [kcratr1_lastbwr].

The alert log file shows the following entries :
Completed: ALTER DATABASE MOUNT
Tue Sep 19 09:43:03 2006
ALTER DATABASE OPEN
Block change tracking file is current.
Tue Sep 19 09:43:04 2006
Beginning crash recovery of 1 threads
parallel recovery started with 2 processes
Tue Sep 19 09:43:04 2006
Started redo scan
Tue Sep 19 09:43:05 2006
Errors in file gns80_ora_9936.trc:
ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],[], [], []
Tue Sep 19 09:43:06 2006
Aborting crash recovery due to error 600

CHANGES
There was a disk problem that caused the database to crash.

CAUSE
Oracle is unable to perform instance recover but it works when is invoked manually.

SOLUTION
Mount the database and issue a recover statement

======================
Commands to do
======================
STARTUP MOUNT;
RECOVER DATABASE;
ALTER DATABASE OPEN;

No comments:

Post a Comment