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;
Dig Deeper on Oracle database backup and recovery
Related Q&A from Brian Peasland
Oracle expert Brian Peasland answers one reader's question about common pitfalls when connecting Oracle to outside programs. Continue Reading
One reader asks expert Brian Peasland a question about datafile sizes with the Oracle RMAN duplicate 10g command. Continue Reading
Managing parent table-child table relations in Oracle SQL environments is key to efficient programming. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.