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
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
Perfect, thanks for letting me know. Pleased it worked for you.
Thanks man saved my life
You’re welcome, pleased it worked for you.
Thank you!! it’s works!
You’re welcome, good to know it’s helping people out 🙂