Because of circumstances that would take way too long to explain, I've restored via tape /usr/local/oracle to a different (Linux) server. When I log in as sysdba and type 'startup,' I receive this error message:
SQL> startup ORACLE instance started. Total System Global Area 168892012 bytes Fixed Size 452204 bytes Variable Size 142606336 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytes Database mounted. ORA-00600: internal error code, arguments: [kcratr1_lostwrt], , , , , , , 
I got a verification that the data was backed up on the tape and I received a verification that the files were restored okay from the same tape.
Any help you can offer in helping me get things up and running would be greatly appreciated.
The ORA-600 [kcratr1_lostwrt] error occurs because the last block written by the Oracle database was lost. You'll have to perform some recovery. Try the following steps in SQL*Plus as SYS:
- STARTUP MOUNT
- RECOVER DATABASE;
- ALTER DATABASE OPEN;
This was first published in June 2006