:

ORA-00600 Internal Error Code Arguments: kcratr_scan_lastbwr

The Problem

I had refreshed one of our dev databases but the database we were refreshing it from was still open at the time when the disks were flushed at the SAN level and there must have been transactions still in process. One of the steps is to enable archivelog mode and it failed with the following error:

alter database archivelog
*
ERROR at line 1:
ORA-00265: instance recovery required, cannot set ARCHIVELOG mode

Before getting the exact sequence of commands to run I first tried opening the database and got an ORA00600 error:

SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []

The Cause

This is documented on Metalink note “ORA-600 [kcratr_scan_lastbwr] [ID 1267231.1]” and the workaround suggested below

The Solution

To recover from this use the following sequence of commands:

SQL> alter database recover database;

Database altered.

SQL> alter database open;

Database altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT PFILE='D:\oracle\cloneDB\initTEST.ora
ORACLE instance started.

Total System Global Area 1068937216 bytes
Fixed Size                  2262048 bytes
Variable Size             557845472 bytes
Database Buffers          503316480 bytes
Redo Buffers                5513216 bytes
Database mounted.
SQL> alter database archivelog;

Database altered.

And there you have it, the answer to all your problems….Well, maybe just this little ORA-00600 error but that’s better than nothing!

Like it, share it...

Category: ORA 600


Related Posts

Comments (6)

Trackback URL | Comments RSS Feed

  1. nkl says:

    I tried following on 12.1, it worked for me
    SQL> shutdown immediate
    SQL> startup mount
    SQL>alter database recover database;
    SQL> alter database open

  2. Julia says:

    Thank you!! it’s works!

Leave a Reply

Your email address will not be published. Required fields are marked *